Best way to fill a combobox dropdown from an sql db using c# winform

Question

0.00/5 (No votes)

See more:

Hi frnds
i have a form and i have about five combox that i wil want to draw their dropdown item from a db the purpose is because i want user to be able to add or remove combobox item. heres the code i use to draw items

C#

..
try
{
SqlDataAdapter da = new SqlDataAdapter("select * from manag where category ='Light' ", con);
DataTable dt = new DataTable();
da.Fill(dt);
cbIlluminate.DataSource=dt;
cbIlluminate.DisplayMember="Choices";
con.Close();
}
Catch(System.Exception){}

i used the above code format for my five diferent comboboxes, this result in me creating five diferent datatable for each of them. Is this a good practice, i realy dont want my app to be slow because of this. Please need sugestions.
Thanks

Posted 9-Jul-13 3:47am

Ese ochuko

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

maneavnash · Accepted Answer · 2013-07-09T04:29:00

this

C#

you can use single datatable  for all .

try  this code 


//declare   datatable 
DataTable dt = new DataTable();
protected void Page_Load(object sender, EventArgs e)
    {

    }


1.
try
{
SqlDataAdapter da = new SqlDataAdapter("select * from manag where category ='Light' ", con);
 dt=new datatable();
da.Fill(dt);
cbIlluminate.DataSource=dt;
cbIlluminate.DisplayMember="Choices";
con.Close();
}
Catch(System.Exception){}

2.
try
{
SqlDataAdapter da = new SqlDataAdapter("select * from manag where category ='Light' ", con);
 dt=new datatable();
da.Fill(dt);
cbIlluminate.DataSource=dt;
cbIlluminate.DisplayMember="Choices";
con.Close();
}
Catch(System.Exception){}

3.
try
{
SqlDataAdapter da = new SqlDataAdapter("select * from manag where category ='Light' ", con);
 dt=new datatable();
da.Fill(dt);
cbIlluminate.DataSource=dt;
cbIlluminate.DisplayMember="Choices";
con.Close();
}
Catch(System.Exception){}