drop down binding

Question

SqlCommand cmd = new SqlCommand("select FirstName+''+LastName from EmployeeMaster", con); SqlDataAdapter dap = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); dap.Fill(ds); ddldetails.DataSource = ds; ddldetails.DataTextField = "FirstName+''+LastName";//Database table filed name for display in dropdown ddldetails.DataBind(); getting an exception- DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'FirstName+''+LastName'. Please help me with this.

Sreekanth Reddy · Answer

Hi Neha, Provide alias name, and give that alias name as datatextfield property. SqlCommand cmd = new SqlCommand("select FirstName+ ',' + LastName as FullName from EmployeeMaster", con); ddldetails.DataTextField = "FullName"; If it helps, Mark as answer. Thank you.

Madan Shekar · Answer

i think problem with sql query please change like this ,i guess like you are concatingfname and lname so select FirstName+ ',' + LastName as empname from EmployeeMaster so change your SqlCommand cmd = new SqlCommand("select FirstName+ ',' + LastName as empname from EmployeeMaster", con); in case of any issue pls ping if it help u means accept the ans

Amit Gupta · Answer

Binding is working on the column name, firstname and Lastname is your individual columnName. Either make a single column name while fetching query or bind a single columnname to your drop-down

Sanwar Ranwa · Answer

Hello Neha Please check this Link https://www.c-sharpcorner.com/UploadFile/rohatash/binding-dropdownlist-with-database-and-display-data-in-gridv/