/// <summary>
/// Get all products from database
/// </summary>
/// <returns>ArrayList of all products from database</returns>
public ArrayList GetAllProducts()
{
string query = "SELECT * FROM PRODUCT";
SQLConnect sql = new SQLConnect();
System.Data.SqlClient.SqlConnection sqlconn = sql.SQLconnect();
ArrayList queryresult = this.ProductQueryDatabase(sqlconn, query);
return(queryresult);
}
private void querybutton_Click(object sender, EventArgs e)
{
SQLConnect sql = new SQLConnect();
string query = querybox.Text;
System.Data.SqlClient.SqlConnection sqlconn = sql.SQLconnect();
string queryresult = sql.QueryDatabase(sqlconn, query);
resultbox.Text = queryresult;
}
/// <summary>
/// Button that gets all the products from the database
/// </summary>
/// <param name="sender">Sender of event</param>
/// <param name="e">Event Arguments</param>
private void GetAllProducts_Click(object sender, EventArgs e)
{
Product product = new Product();
SQLConnect sql = new SQLConnect();
ArrayList result = product.GetAllProducts();
product.InsertDatabase(result);
product.UpdateProductList(product.QueryStr, this.dataGridView1);
}
