public void display()
{
SqlConnection con = Database_Connection.OpenCon();
string query = "select * from operator_info";
SqlCommand cmd = new SqlCommand(query, con);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
dataGridView1.DataSource = dt;
cmd.ExecuteNonQuery();
Database_Connection.CloseCon();
}
private void buttonsearch_Click(object sender, EventArgs e)
{
SqlConnection con = Database_Connection.OpenCon();
string query = "select * from operator_info where id='" + bunifuMaterialTextboxid.Text + "'";
SqlCommand cmd = new SqlCommand(query, con);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
dataGridView1.DataSource = dt;
cmd.ExecuteNonQuery();
Database_Connection.CloseCon();
}
private void Buttondelete_Click(object sender, EventArgs e)
{
SqlConnection con = Database_Connection.OpenCon();
string query = "delete from operator_info where id='" + bunifuMaterialTextboxid.Text + "'";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.Add("@id", bunifuMaterialTextboxid.Text);
cmd.Parameters.Add("@name", bunifuMaterialTextboxname.Text);
cmd.Parameters.Add("@fare", bunifuMaterialTextboxfare.Text);
cmd.ExecuteNonQuery();
MessageBox.Show("delete successfully");
display();
Database_Connection.CloseCon();
}
private void Buttoninsert_Click(object sender, EventArgs e)
{
SqlConnection con = Database_Connection.OpenCon();
string query = "insert into operator_info(id,name,fare) values (@id,@name,@fare)";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.Add("@id", bunifuMaterialTextboxid.Text);
cmd.Parameters.Add("@name", bunifuMaterialTextboxname.Text);
cmd.Parameters.Add("@fare", bunifuMaterialTextboxfare.Text);
cmd.ExecuteNonQuery();
MessageBox.Show("insert successfully");
display();
Database_Connection.CloseCon();
}
private void ButtonSearch_Click(object sender, EventArgs e)
{
string fare = textBoxFare.Text;
string id = TextBoxId.Text;
string name = TextBoxOperatorName.Text;
SqlConnection con = Database_Connection.OpenCon();
string query = @"INSERT INTO operator_info(name, id, fare) VALUES(@nm , @id , @fr)";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@nm", name);
cmd.Parameters.AddWithValue("@id", id);
cmd.Parameters.AddWithValue("@fare", fare);
cmd.ExecuteNonQuery();
cmd.ExecuteScalar();
}