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