Fill Dropdown List....

Question

Hi Frnds,
i have a dropdown control.while displaying it i have to show the Item name...but while saving in the Database i have to save Item Code which is integer not the Item Name.
how can it be done.

Regards,
aamir

Santhosh Kumar Jayaraman · Answer

Just to clarify..You are getting 3 items in dataset. But only one item is displayed in dropdown, right?

Aamir Khan · Answer

the dataset showing the 3 ItemNames with its Code

Santhosh Kumar Jayaraman · Answer

Code is proper. Put breakpoint and check what you are getting in the sql query command output. Check your dataset

Aamir Khan · Answer

hi santosh, while on SelectedIndexChanged of my Gridview i have used the ur above given soln, but i am not getting the related ItemName,its showing the 1st value (itemName) and not the different one. in my aspx i have used following code: ' Visible="false"/> and in Gridview_SelectedIndexChanged following code: SqlConnection Conn = new SqlConnection(); Conn.ConnectionString = ConfigurationManager.ConnectionStrings["LIMS_Conn"].ConnectionString; SqlDataAdapter adp=new SqlDataAdapter("select dbo.Inv_InventoryMaster.MaterialDesc+'-'+Inv_SupplierMaster.Supplier_Company_Name as 'Supplier', Inv_InventoryMaster.ID as'Inv_id' from Inv_InventoryMaster inner join Inv_SupplierMaster on Inv_InventoryMaster.SPL_ID=Inv_SupplierMaster.SPL_ID where Inv_InventoryMaster.ID='"+drpDescription.SelectedValue+"'",Conn); DataSet ds = new DataSet(); adp.Fill(ds); drpDescription.DataSource = ds; drpDescription.DataTextField = "Supplier";//display in UI drpDescription.DataValueField = "Inv_Id";//Saves this in DB drpDescription.DataBind(); what might be the mistake? reply

Santhosh Kumar Jayaraman · Answer

In gridview selection event, use the above code which i shared already. it is both to save as well as retrieve

Aamir Khan · Answer

dear santosh, i got the above query solved, while saving in DB i get the code...but now i want, on select of the Gridview row to show the ItemName not the code in the DropDownList control.

Santhosh Kumar Jayaraman · Answer

ddlItems.Datasource=Items; ddlItems.DataTextField="Name";//display in UI ddlItems.DataValueField="ItemCode";//Saves this in DB ddlItems.DataBind();

Fill Dropdown List....

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (7)