public Form2()
{
InitializeComponent();
//load the combobox
DBconnect DB = new DBconnect();
DB.LoadComboBox("SELECT * FROM users ", name);
}
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
DBconnect dBconnect = new DBconnect();
dBconnect.LoadTextBox("SELECT CustomerName FROM customers", textBox1);
DBconnect bconnect = new DBconnect();
bconnect.LoadComboBox("SELECT id FROM customers", comboBox1);
DBconnect dBcconnect = new DBconnect();
dBcconnect.Select("SELECT * FROM customers", dataGridView1);
dataGridView1.Sort(dataGridView1.Columns["Mobile"], ListSortDirection.Ascending);
}
private void name_TextChanged(object sender, EventArgs e)
{
DBconnect DB = new DBconnect();
DB.LoadComboBox("SELECT id FROM customers ", comboBox1);
}