ComboBox not populating correctly.

Question

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"];

Answer 1

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.

Answer 2

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";