Combobox logic

The query is not the problem, I am using a tableadapter from the designer that has a stored procedure. And everytime i call the tableadapter it takes long, its only three records in the database, so it should not be taking 15 seconds, this is my first time using mysql, i am normally using SQL Server 2008.


Keep in mind there is two combo boxes, and they are both related to each other, so they can select any item from either combo box. So if i to reload the combo box base upon the item select in the combo box, the minute i select an item in combo box a , I have to reload the combo box B with the related records, vi versa etc.........


can you also tell which is the quicker way for the data to return faster then what its doing, I am using linq to pull from from the database.
I am using similiar below, and its slow, the database only have three records at the moment. Any suggestions.

example:

IF ComboBox A is selected first then do this below
{

var List = from l in colorTableAdapter.GetData
              where l.ColorSerialNumber == ComboBoxA.Text
              select l,



ComboBoxB.Datasource = List.Select( t => t.ColorPartNo).ToList();
}

ELSE
{


var List = from l in colorTableAdapter.GetData
              where l.ColorPartNumber == ComboBoxB.Text
              select l,



ComboBoxA.Datasource = List.Select( t => t.ColorSerialNo).ToList();


}

Hi Darnell,

Try this...

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
namespace Comboboxs
{
    public partial class Form1 : Form
    {
        string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"];
        OleDbCommand com;
        OleDbDataAdapter oda;
        DataSet ds;
        string str;

        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            comboBox1.Items.Add("Choose Color serial No");
            OleDbConnection con = new OleDbConnection(ConnectionString);
            con.Open();
            str = "select * from Color";
            com = new OleDbCommand(str, con);
            OleDbDataReader reader = com.ExecuteReader();
            while (reader.Read())
            {
                comboBox1.Items.Add(reader["ColorserialNo"]);
            }
          
        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            comboBox2.Items.Clear();
            OleDbConnection con = new OleDbConnection(ConnectionString);
            con.Open();
            str = "select * from Color where ColorserialNo='" + comboBox1.Text.Trim() + "'";
            com = new OleDbCommand(str, con);
            OleDbDataReader reader = com.ExecuteReader();
            while (reader.Read())
            {
                comboBox2.Items.Add(reader["ColorpartNo"].ToString());
            }
            con.Close();
            reader.Close();
        }
    }
}



Thanks