drop down binding

neha verma

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.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sreekanth Reddy7y ago
Accepted 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.
Amit Gupta7y ago
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
Madan Shekar7y ago
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
Sanwar Ranwa7y ago
Hello Neha

Please check this Link

https://www.c-sharpcorner.com/UploadFile/rohatash/binding-dropdownlist-with-database-and-display-data-in-gridv/