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();
}
