开发者

ComboBox not populating correctly

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

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜