private void suppliercombo_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
Driver.Clear();
Conductor.Clear();
Vehicle.Clear();
Connection cn = new Connection();
cn.connect();
cn.cmd.Connection = cn.cnn;
cn.cmd.Connection.Open();
cn.cmd.CommandText = "Select Misc3,Misc2,Misc1 From Supplier Where SupplierActive='True' and SupplierName='" + suppliercombo.SelectedItem.ToString() + "'";
try
{
cn.dr = cn.cmd.ExecuteReader();
while (cn.dr.Read())
{
Driver.Text = (cn.dr.GetString(1));
Conductor.Text = (cn.dr.GetString(0));
Vehicle.Text = (cn.dr.GetString(2));
// MessageBox.Show(cn.dr.GetString(0) + cn.dr.GetString(1) + cn.dr.GetString(2));
}
}
catch (Exception ex)
{
displayMetroError(ex);
}
}
