public Products() { InitializeComponent(); DbHelper.EstablishConnection(); MySqlConnection connection = new MySqlConnection(connec); connection.Open(); string queryProducts = "SELECT * FROM btm495.Products"; MySqlCommand comm = connection.CreateCommand(); comm.CommandText = queryProducts; DataTable table = new DataTable(); MySqlDataAdapter adapt = new MySqlDataAdapter(queryProducts, connection); adapt.Fill(table); while (row < table.Rows.Count) { ProductsDA product = new ProductsDA(); product.Product_id = Convert.ToInt32(table.Rows[row]["Product_ID"]); product.Product_name = (string)table.Rows[row]["Product_name"]; product.Product_type = (string)table.Rows[row]["Product_type"]; comboBox1.Items.Add(product.Show_product()); row += 1; } row = 0; }
public Add_Products() { InitializeComponent(); DbHelper.EstablishConnection(); }
public Modify_Sub() { InitializeComponent(); DbHelper.EstablishConnection(); }
public Create_Sub() { InitializeComponent(); DbHelper.EstablishConnection(); }
public Subscription() { InitializeComponent(); DbHelper.EstablishConnection(); }
public Customers() { InitializeComponent(); DbHelper.EstablishConnection(); }
public Create_Customer() { InitializeComponent(); DbHelper.EstablishConnection(); txtAutoCustID.Text = custId.ToString(); }