From sql db to dropdownlist

Question

Is there a method to transfer 2 fields from an sql table to a dropdownlist as option and value? what are the dropdownlist methods to assign values to option and value respectively? Thanks

send2manivannan · Answer

Yes You can Step 1: Load the DB value in DataSet. Step 2: Set the DropDownList's DataSource Property to DataSet.Tables[0] Step 3: Set the DropDownList's DataValueField Property to Value Data Column Name Step 4: Set the DropDownLists' DataTextField Property to Option/Text Data Column Name Step 5: Call the DropDownList's DataBind() Function. Example DataSet ds = new DataSet(); daAdap.Fill(ds); drpList.DataSource = ds.Tables[0]; drpList.DataValueField = ItemCode; drpList.DataTextField = ItemName; drpList.DataBind();