> <asp:SqlDataSource ID="SchoolsDataSource" ConnectionString="< %$ ConnectionStrings:FCCMSConnectionString % >" > SelectCommand="SELECT RTRIM([School]) + COALESCE(' - ' + [SchoolPhone],'') as SchoolInfo, [School], [SchoolPhone] FROM [Schools] WITH (NOLOCK) WHERE ([siteID] = @siteID)" > runat="server"> > <SelectParameters> > <asp:ProfileParameter Name="SiteID" PropertyName="SiteID" Type ="Int32" /> > </SelectParameters> > </asp:SqlDataSource> > ><div class="cl"> > <label class="bx"> > School </label><span class="bx"> > <asp:DropDownList ID="ddlSchool" runat="server" > DataSourceID="SchoolsDataSource" > DataTextField="School" DataValueField="School" Width="260px" > > > </asp:DropDownList> > </span> > <asp:Literal ID="litSchoolPhone" runat="server" Text=" " ></asp:Literal> > <br /> > <br /> ></div> >>I only made changes in the SelectCommand and also added new literal control. I also added SchoolPhone to SP in the ASPX that calls this UserControl (and also exposed this property and Bind SchoolPhone in my page).
><!-- 4th --> > <div id="info4" class="cl dn"> > <ScGr:SchoolGradeInfo ID="SchoolGradeVol" runat="server" EditMode ="false" > Grade='< %# Bind("Grade") % >' > School='< %# Bind("School") % >' SchoolPhone ='< %# Bind("SchoolPhone") % >' />>