Fill Dropdown List....

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

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

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: 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

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

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