CODEWITHSUNDEEP
c#visual-studiocomboboxuserform
Ax3landra
Ax3landra

Reputation: 33

ComboBox doesn't show the data

ComboBox doesn't show the data, I populate my combobox with data from my database this way:

private void PartDefective(string id)
{
    cmd = new SQLiteCommand("Select * FROM Part_defective where testers = '" + id + "'", DBcon);
    if (DBcon.State == ConnectionState.Closed)
        DBcon.Open();
    myDA = new SQLiteDataAdapter(cmd);
    myDataSet = new DataSet();
    myDA.Fill(myDataSet, "comboBox6");
    this.comboBox6.DataSource = myDataSet.Tables["comboBox6"].DefaultView;
    this.comboBox6.ValueMember = "Part";
    this.comboBox6.DisplayMember = "Part";
    this.comboBox6.SelectedItem = "ID";
    this.comboBox6.SelectedIndex = -1;

    DBcon.Close();
}

And to show the data from the database I used :

private void comboBox6_SelectedIndexChanged(object sender, EventArgs e)
{
    if (this.comboBox6.SelectedValue == null)
    {
        testerid = "1";
    }
    else
    {
      part = this.comboBox6.SelectedText.ToString();
    }
}

Upvotes: 1

Views: 149

Answers (2)

Oceans
Oceans

Reputation: 3509

There is absolutely no reason to define the SelectedItem or SelectedIndex. The SelectedIndexChanged Event is also completely redundant for displaying your combobox.

Remove these lines and see if it solved your problem. 

this.comboBox6.SelectedItem = "ID";
this.comboBox6.SelectedIndex = -1;

If the combobox is still empty, the root of problem has to be with the fetching of your data and filling the datasource.

Upvotes: 1

Derek
Derek

Reputation: 8793

Put a breakpoint on this line: 

this.comboBox6.DataSource = myDataSet.Tables["comboBox6"].DefaultView;

And then look at the value of myDataSet.Tables["comboBox6"] in the watch or quickwatch window. Are there any rows?

Also change your code:

string sql = "Select * FROM Part_defective where testers = '" + id + "'";
cmd = new SQLiteCommand(sql, DBcon);

Put a breakpoint there, see what the value of sql is.

Manually run the sql against your database and see if there are any results.

Upvotes: 0

Related Questions