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