private void bunifuThinButton1_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); dbconnect db = new dbconnect(); dt = db.ReadValue("Select * From route"); dataGridView1.DataSource = dt; }
private void bunifuThinButton4_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); dbconnect db = new dbconnect(); String id; id = bunifuTextbox1.text; dt = db.ReadValue("Select * From route where '" + id + "' = RouteID"); dataGridView1.DataSource = dt; }
private void bunifuThinButton11_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); dbconnect db = new dbconnect(); dt = db.ReadValue("Select * From route"); dataGridView1.DataSource = dt; bunifuCustomTextbox4.Clear(); bunifuCustomTextbox2.Clear(); bunifuCustomTextbox3.Clear(); bunifuCustomTextbox1.Clear(); label4.Text = ""; label5.Text = ""; label3.Text = ""; }
private void bunifuThinButton9_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); dbconnect db = new dbconnect(); try { dt = db.ReadValue("Select * From vehicles"); dataGridView1.DataSource = dt; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error"); } }
private void button2_Click(object sender, EventArgs e) { try { DataTable dt = new DataTable(); dbconnect db = new dbconnect(); dt = db.ReadValue("Select DriverID,DriverName,ContactNo From driverdetails"); dataGridView1.DataSource = dt; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error"); } }
private void button1_Click(object sender, EventArgs e) { try { DataTable dt = new DataTable(); dbconnect db = new dbconnect(); dt = db.ReadValue("Select employee_id,fname,mobile_no From employee"); dataGridView1.DataSource = dt; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error"); } }
private void bunifuThinButton1_Click(object sender, EventArgs e) { try { DataTable dt = new DataTable(); dbconnect db = new dbconnect(); String id; //String text; id = bunifuTextbox1.text; dt = db.ReadValue("Select * From vehicles where '" + id + "' = VehicleID"); dataGridView1.DataSource = dt; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error"); } }