I am using asp.net where i am wanting to use a datagrid with the column of 'location'. When the datagrid is loaded I would like it two have the value of the current dataset with respect to 'location' where I can then change the value through a combobox. The way I have the following 'location' has the values from the location column within the combobox, but it does not default to the current value of the dataset. I guess what I am trying to do is default the combobox item to the corresponding dataset value per the individual datarow. I am not sure how to do this though.
When data is changed and all changes are complete I will loop through the datagrid and modify the dataset. This part I am able to do.
--BIND DATA TO DATAGRDID COMBOBOX THREE
<asp:DropDownList id="Dropdownlist1" runat="server" DataSource="<%# dsSql %>" DataMember="WorkRequest" DataTextField="location" DataValueField="location" >
<asp:TextBox Font-Bold=True MaxLength="10" Width="80" runat="server" id="ITEMNUM" text='<%# DataBinder.Eval(Container.DataItem, "ITEMNUM") %>' />