bdrvm
asked on
DropDownList having a DataTextField value of two columns from one DataTable (C#)
Hi everyone,
Is there a way of giving 2 columns of one DataTable in the DataTextField of a DropDownList?
Code snippet always appreciated!
Is there a way of giving 2 columns of one DataTable in the DataTextField of a DropDownList?
Code snippet always appreciated!
ASKER
Here is my code:
DataSet myDataSet = new DataSet();
OleDbDataAdapter myOleDbDataAdapter = new OleDbDataAdapter("Select * From T_Employee", myConnection);
myOleDbDataAdapter.Fill(my DataSet,"E mployee");
DDLemployee.DataSource = myDataSet.Tables["Employee "];
DDLemployee.DataTextField = " ? "
// What I want is something like
//myDataSet.Tables["Employ ee"].Colum ns["FirstN ame"] + " " + myDataSet.Tables["Employee "].Columns ["LastName "];
// but how?
DDLemployee.DataValueField = myDataSet.Tables["Employee "].Columns ["id"];
DataSet myDataSet = new DataSet();
OleDbDataAdapter myOleDbDataAdapter = new OleDbDataAdapter("Select * From T_Employee", myConnection);
myOleDbDataAdapter.Fill(my
DDLemployee.DataSource = myDataSet.Tables["Employee
DDLemployee.DataTextField = " ? "
// What I want is something like
//myDataSet.Tables["Employ
// but how?
DDLemployee.DataValueField
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks...you found it !.
Here is my final code
OleDbDataAdapter myOleDbDataAdapter = new OleDbDataAdapter("Select *, FirstName + ' ' + LastName as empName From T_Employee", myConnection);
myOleDbDataAdapter.Fill(my DataSet,"T _Employee" );
DDLemployee.DataSource = myDataSet.Tables["T_Employ ee"];
DDLemployee.DataTextField = "empName";
...
it work!
Here is my final code
OleDbDataAdapter myOleDbDataAdapter = new OleDbDataAdapter("Select *, FirstName + ' ' + LastName as empName From T_Employee", myConnection);
myOleDbDataAdapter.Fill(my
DDLemployee.DataSource = myDataSet.Tables["T_Employ
DDLemployee.DataTextField = "empName";
...
it work!
SELECT Name = (FirstName + ' ' + LastName) From Addresses;
DropDownList1.DataTextFiel
-tushar