Reply to thread

Message

<blockquote data-quote="mumick" data-source="post: 7458" data-attributes="member: 2818">Hi vb.net pros,I got a big problem with my dropdownlist control, it keeps bothering me more, more. I have a web form with datagrid on it. That datagrid contains multiple columns, one of them has dropdownlist control in it. How do I populate that dropdownlist control for each record in my datagrid.ProductID is my unique field, ServiceLevel has multiple values for each ProductID (ELITE, SELECT, NEXT DAY, MLC). So what I need to do is to populate dropdownlist for each ProductID.ProductID | ListPrice | ContractPrice | ServiceLevel | TotalSellPrice1312-231 | $100.00| $20.00 | ELITE,SELECT, | $90.00NEXT DAYHere is the code behind I use to populate dropdownlist for one ProductID[CODE] Public Function BindServiceLevel() As SqlDataReader Dim Conn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings(&quot;Connection&quot;))Dim cmdSelectDDL As SqlCommand = New SqlCommand(&quot;SELECT ServiceLevel FROM ServicePlan WHERE ProductID='44SB150-0000' &quot;, Conn)Conn.Open()Return cmdSelectDDL.ExecuteReader(CommandBehavior.CloseConnection)End Function[/CODE]Here is my HTML:[HTML]&lt;asp:TemplateColumn HeaderText=&quot;Service Level&quot;&gt;&lt;ItemTemplate&gt;&lt;asp:DropDownList id=&quot;ddlServiceLevel&quot; DataSource='&lt;%# BindServiceLevel()%&gt;' DataTextField=&quot;ServiceLevel&quot; DataValueField=&quot;ServiceLevel&quot; runat=&quot;server&quot; AutoPostBack=&quot;False&quot;&gt;&lt;/asp:DropDownList&gt;&lt;/ItemTemplate&gt;&lt;/asp:TemplateColumn&gt;[/HTML]Please help, thanks in advance.</blockquote>

[QUOTE="mumick, post: 7458, member: 2818"] Hi vb.net pros, I got a big problem with my dropdownlist control, it keeps bothering me more, more. I have a web form with datagrid on it. That datagrid contains multiple columns, one of them has dropdownlist control in it. How do I populate that dropdownlist control for each record in my datagrid. ProductID is my unique field, ServiceLevel has multiple values for each ProductID (ELITE, SELECT, NEXT DAY, MLC). So what I need to do is to populate dropdownlist for each ProductID. ProductID | ListPrice | ContractPrice | ServiceLevel | TotalSellPrice 1312-231 | $100.00| $20.00 | ELITE,SELECT, | $90.00 NEXT DAY Here is the code behind I use to populate dropdownlist for one ProductID [CODE] Public Function BindServiceLevel() As SqlDataReader Dim Conn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("Connection")) Dim cmdSelectDDL As SqlCommand = New SqlCommand("SELECT ServiceLevel FROM ServicePlan WHERE ProductID='44SB150-0000' ", Conn) Conn.Open() Return cmdSelectDDL.ExecuteReader(CommandBehavior.CloseConnection) End Function [/CODE] Here is my HTML: [HTML]<asp:TemplateColumn HeaderText="Service Level"> <ItemTemplate> <asp:DropDownList id="ddlServiceLevel" DataSource='<%# BindServiceLevel()%>' DataTextField="ServiceLevel" DataValueField="ServiceLevel" runat="server" AutoPostBack="False"></asp:DropDownList> </ItemTemplate> </asp:TemplateColumn>[/HTML] Please help, thanks in advance. [/QUOTE]

Verification