I use following code to populate a Combo Box. It displays: System.Data.DataRowView instead of the actual column values in it. What I am missing?
string Query = "SELECT institutename FROM institutemaster";
DataSet ds = new DataSet();
MySqlDataAdapter da = new MySqlDataAdapter(Query, ConnectionClass.CN);
da.Fill(ds, "Institutes");
cmbInstitutes.DataSource = ds.Tables["Institutes"开发者_JAVA技巧];
You may need to set DisplayMember and ValueMember properties:
cmbInstitutes.DisplayMember = "NameOfTheColumnForText";
cmbInstitutes.ValueMember = "NameOfTheColumnForValues";
or DataValueField and DataTextField if it is an ASP.NET application.
you can populate two columns in same combobox using following code.
string Query = "SELECT (institutename +', '+city) as Institute FROM institutemaster";
DataSet ds = new DataSet();
MySqlDataAdapter da = new MySqlDataAdapter(Query, ConnectionClass.CN);
da.Fill(ds, "Institutes");
cmbInstitutes.DataSource = ds.Tables["Institutes"];
cmbInstitutes.DisplayMember = "Institute";
cmbInstitutes.ValueMember = "Institute";
精彩评论