C#Net2008 Fill LISTBOX With DATASET

Lennie · March 31st, 2010, 03:54 AM

Hi Good Guys,

I am learning how to use C#Net2008 to develop Window Application. I was a VB.NET2008 developer. I need your help, Please Help me.

I am encountering 2 problems trying to fill LISTBOX with DATASET and CATCH to display error message.

In the LISTBOX dropdown list instead of displaying CUSTOMERNAME, it displays System.Data.DataViewManagerListItemTypeDescriptor

Here are the Coding to fill LISTBOX with DATASET

Code:

  private void FLoadListBox()
        {
            string strSql  = "Select CustomerID, CompanyName from Customers   order by CompanyName";
            sqlconn = new SqlConnection(connstr);
            sqlconn.Open();
            sqlDA = new SqlDataAdapter(strSql, sqlconn);
            DS = new DataSet("DS");

            try
               {
                DS.Clear();
                DS.CaseSensitive = true;
                sqlDA.Fill(DS,"Cust");

                // fill listbox
                this.listBoxCust.DisplayMember = "CompanyName";
                this.listBoxCust.ValueMember = "CustomerID";
                this.listBoxCust.DataSource = DS;
                sqlconn.Close();
               }
            catch (SystemException MsgException)
               {
            
                }
            
   }

melvik · March 31st, 2010, 10:40 AM

Dear good Lennie

use the code below.
I guess u'll get where was ur little mistake

Code:

                this.listBoxCust.DisplayMember = "CompanyName";
                this.listBoxCust.ValueMember = "CustomerID";
                this.listBoxCust.DataSource = DS.Tables["Cust"];
                sqlconn.Close();