Loading new values from database into combo box using c#

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

, +

I am working on windows application, I have two forms first form which contains combobox to retrieve data from database and second form which contains textbox to save data in database. I have created a method in first form which does the work of retrieving the data and load in combobox and then I called the same method in second form where I save the data from textbox to database. The method I wrote is as follows:-

C#

public void Bank_Name()
        {
            //Connection String
            SqlConnection cone = new SqlConnection(cnstd);
            cone.Open();
            SqlDataAdapter adpi = new SqlDataAdapter("Select distinct Cust_Name from Customer", cone);
            DataSet ds = new DataSet();
            adpi.Fill(ds);
            cmbCust_Name.DataSource = ds.Tables[0];
            cmbCust_Name.DisplayMember = "Cust_Name";
            cone.Close();
        }

In debug mode when I run the project the when I save the value from textbox, it can be seen in dataset, but the combobox is not getting the new value even though it is loaded in dataset.

Thanks in Advance !!!

Posted 4-Dec-12 18:52pm

Ank_ush

Add a Solution

Comments

vivektiwari97701 5-Dec-12 1:05am

debug ur code and find exactly where is the problem...

Sergey Alexandrovich Kryukov 5-Dec-12 1:05am

Where is the combo box in your code? Always show all relevant declarations...
--SA

Ank_ush 5-Dec-12 1:12am

cmbCust_Name is the name of combobox

Ank_ush 5-Dec-12 1:15am

In debug mode when I place the mouse on adpi.fill(ds), i.e. adadpter.fill(Dataset) the newly added value is loaded, but in combobox, it is not shown.

vivektiwari97701 5-Dec-12 1:25am

just try to use DataTable in place of DataTable and set ValueMember property of Combo Box..

DataTable ds = new DataTable();
adpi.Fill(ds);
cmbCust_Name.DataSource = ds;
cmbCust_Name.DisplayMember = "Cust_Name";
cmbCust_Name.ValueMember ="Cust_Name"
cone.Close();
}

make sure after binding combo box u r not doing any clear operation.and ur calling this method in right event...

2 solutions

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)

choudhary.sumit · Answer 1 · 2012-12-04T19:13:00

clear your dataset every time before it loads new data from database. and also your combobox.

public void Bank_Name()
        {   
            cmbCust.items.clear();
            DataSet ds = new DataSet();
            Ds.Clear();
            //Connection String
            SqlConnection cone = new SqlConnection(cnstd);
            cone.Open();
            SqlDataAdapter adpi = new SqlDataAdapter("Select distinct Cust_Name from Customer", cone);           
            adpi.Fill(ds);
            cmbCust_Name.DataSource = ds.Tables[0];
            cmbCust_Name.DisplayMember = "Cust_Name";
            cone.Close();
        }

azizulhoque.bd · Answer 2 · 2012-12-04T19:18:00

hi dear,

check this solution.

SqlConnection cone = new SqlConnection(cnstd);
string SQL = "Select distinct Cust_Name from Customer";
SqlCommand cmd = new SqlCommand(SQL, cone);            
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
  comboBox1.DataSource = dt;
  comboBox1.DisplayMember = "Cust_Name";
  comboBox1.ValueMember = "Cust_Name";               
}

Loading new values from database into combo box using c#

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0