how to get data from two different tables in different combobox?

Question

1.00/5 (1 vote)

See more:

i have two tables class and category, i want to show all the classes in combobox1 and all categories in combobox2... can anyone help?

Posted 11-Feb-14 6:52am

ArmanKhan19

Add a Solution

Comments

Richard C Bishop 11-Feb-14 12:53pm

Where are you stuck? What have you tried?

ArmanKhan19 12-Feb-14 5:30am

void fillclasscmb()
{
dataadapter.selectcommand = new sqlcommand("Select Classn from class", connection);
datareader dr = new datareader();
while (dr.read())
{
string classnames = dr[0].tostring();
cmb_class.items.add(classnames);
}
}

and same for category and call them in constructor but im getting only class names in cmb_class but not category names in cmb_category.. what should i do??

ZurdoDev 11-Feb-14 12:54pm

Many of us can help. Where are you stuck?

Sergey Alexandrovich Kryukov 11-Feb-14 13:51pm

Why could it possibly be a problem? What's the difference, two or one control?
—SA

ArmanKhan19 12-Feb-14 12:24pm

im getting the data in class combobox by this code
void fillclasscmb()
{
dataadapter.selectcommand = new sqlcommand("Select Classn from class", connection);
datareader dr = new datareader();
while (dr.read())
{
string classnames = dr[0].tostring();
cmb_class.items.add(classnames);
}
}

but im not getting the data from category table in category combobox by this code simultaneously,

khurram ali lashari 11-Feb-14 14:15pm

i have updated my solution... Thankx..I hope it will solve your problem

ArmanKhan19 12-Feb-14 5:17am

im getting the values in class combobox but not in category combox, the problem is same there

khurram ali lashari 12-Feb-14 14:05pm

Post the error which you are getting

ArmanKhan19 12-Feb-14 23:39pm

im not getting any error, but when i run the program it show me class combobox filled but category combobox didn't filled..

ArmanKhan19 12-Feb-14 23:45pm

i fix that, there was some error in my database,.. thnx for your help man....

khurram ali lashari 13-Feb-14 12:18pm

You Always Wellcome Amarkhan19

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)

khurram ali lashari · Accepted Answer · 2014-02-11T07:56:00

Here is a Sample Code For Class ComboBox

C#

public DataTable classComboBox()
 {
     DataTable dt = new DataTable();
     SqlConnection conn = new SqlConnection("your connection string");
     SqlCommand comm = new SqlCommand("Select * from class", conn);
     SqlDataAdapter SDA = new SqlDataAdapter(comm);
     SDA.SelectCommand = comm;
     SDA.Fill(dt);
     return dt;
 }

Here is a sample Code For category ComboBox

C#

public DataTable categoryComboBox()
 {
     DataTable dt = new DataTable();
     SqlConnection conn = new SqlConnection("your connection string");
     SqlCommand comm = new SqlCommand("Select * from category ", conn);
     SqlDataAdapter SDA = new SqlDataAdapter(comm);
     SDA.SelectCommand = comm;
     SDA.Fill(dt);
     return dt;
 }

And You Can Call Into Form Like This.......

C#

public void FillClasscombox()
{
    DataTable dt = classComboBox();
    yourClassCombobox.DataSource = dt;
    yourClassCombobox.DisplayMember = "className"; // Here Put Your Display Member Which Yow want display into ComboBox....
    yourClassCombobox.ValueMember = "classId";// Here Put Your value Member

}

Here Your Calling Method Of catogry

C#

public void FillCatogrycombox()
   {
       DataTable dt = categoryComboBox();
       yourClassCombobox.DataSource = dt;
       yourClassCombobox.DisplayMember = "category"; // Here Put Your Display Member Which           Yow want display into ComboBox....
       yourClassCombobox.ValueMember = "categoryId";// Here Put Your value Member

   }

Finaly call FillClasscombox() and FillCatogrycombox() into the Constructor
like this

C#

public yourconstructor()
{
  InitializeComponent();
  FillClasscombox();
   FillCatogrycombox();
}