private void metroTile7_Click(object sender, EventArgs e)
{
//opening penalty module
string id = txt_id.Text;
Penaltymod frm2 = new Penaltymod();
frm2.MyProperty = id;
frm2.Show();
this.Hide();
}
private void button2_Click(object sender, EventArgs e)
{
String sqlconstring = "Data Source = LOCALHOST; Initial Catalog = it_2d; username = root; password = ''";
MySqlConnection sqlconnect = new MySqlConnection(sqlconstring);
MySqlDataAdapter sqlDataAdapter = new MySqlDataAdapter();
DataSet DS = new DataSet();
sqlconnect.Open();
MySqlCommand sqlcommand = new MySqlCommand();
sqlcommand.CommandText = "DELETE FROM `tbl_itemlist` WHERE `b_no` = ('" + textBox1.Text + "') ";
sqlcommand.CommandType = CommandType.Text;
sqlcommand.Connection = sqlconnect;
sqlcommand.ExecuteNonQuery();
sqlDataAdapter.SelectCommand = sqlcommand;
string id = textBox2.Text;
Penaltymod frm2 = new Penaltymod();
frm2.MyProperty = id;
frm2.Show();
this.Hide();
sqlconnect.Close();
}
