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