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