private void button8_Click(object sender, EventArgs e) { // clear display result dataGridView1.Rows.Clear(); string word = ""; // check if string is empty UtilityClass.CheckIfEmpty(textBox2.Text); // radio button product name is checked if (radioButton1.Checked) { word = textBox2.Text.Trim(); var sqlquery = $"SELECT * FROM Product WHERE Product_Name = '{word}'"; QueryDataClass.QueryAllData(dataGridView1, sqlquery); } // if radio button price is checked if (radioButton2.Checked) { word = textBox2.Text; var price = Convert.ToDecimal(word); var sqlquery = $"SELECT * FROM Product WHERE Cost_Price = '{price}'"; QueryDataClass.QueryAllData(dataGridView1, sqlquery); } }
// form loader private void Form1_Load(object sender, EventArgs e) { // check start position if (Start == 0) { button3.Enabled = false; } // query string var sqlString = $"select* from Product order by Product_Name offset {Start} rows fetch next {Next} rows only;"; // reload result QueryDataClass.QueryAllData(dataGridView1, sqlString); }
// next button private void button4_Click(object sender, EventArgs e) { // set next button visible button3.Enabled = true; //clear disaplay dataGridView1.Rows.Clear(); // create pagination Start = Start + 5; // query string var sqlString = $"select* from Product order by Product_Name offset {Start} rows fetch next {Next} rows only;"; var count = QueryDataClass.QueryAllData(dataGridView1, sqlString); // enable prvious button if (count == 0) { button4.Enabled = false; } }
// previous button private void button3_Click(object sender, EventArgs e) { // clear display dataGridView1.Rows.Clear(); // check if sart is more than 0 if (Start > 0) { Start = Start - 5; var sqlString = $"select* from Product order by Product_Name offset {Start} rows fetch next {Next} rows only;"; var count = QueryDataClass.QueryAllData(dataGridView1, sqlString); } else if (Start == 0) { // disable previous button button3.Enabled = false; // Enable next button button4.Enabled = true; } }
// delete button private void button2_Click(object sender, EventArgs e) { // get id of selected item var id = dataGridView1.SelectedCells[0].Value.ToString(); int value = int.Parse(id); // database connection database.DataBaseConnection(); // query string var sqlString = $"DELETE FROM Product WHERE Id = {value}"; // query database var result = database.QueryDatabase(sqlString); result.ExecuteNonQuery(); // clear display result dataGridView1.Rows.Clear(); // display new result QueryDataClass.QueryAllData(dataGridView1, sqlString); }