Member Avatar for LennieKuah

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 problem trying to fill LISTBOX with DATASET and CATCH to display error message.

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

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)
               {
            
               }
            
   }

Thank you .

Edited by LennieKuah because: type error
  • 2 Contributors
  • 5 Replies
  • 206 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by LennieKuah
Member Avatar for kvprajapati

Qualify the fields.

this.listBoxCust.DisplayMember = "Cust.CompanyName";
this.listBoxCust.ValueMember = "Cust.CustomerID";
this.listBoxCust.DataSource = DS;
Member Avatar for LennieKuah

Hi AdataPost,
Thank for your suggestion. Will try it out and get back to you.
If the coding is running well, I will post it here to share with other Newbies who may have similar problems.

Member Avatar for LennieKuah

Hi Good Guys,
Thanks to all of you for sharing your knowledge and information with me.
I am learn alot from it and now my coding is working.

Edited by LennieKuah because: type error
Member Avatar for kvprajapati

You're welcome.

I'm glad you got it working. Please mark this thread as solved

Member Avatar for LennieKuah

Thanks to this wondeful FORUM whose members are so helpful and generous in sharing their knowledge with me. I am so glad that I have registered myself here.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.