private void addNewRoomToolStripMenuItem_Click(object sender, EventArgs e)
{
this.Close();
roomadd ra = new roomadd();
ra.Show();
}
private void savebtn_Click(object sender, EventArgs e)
{
try
{
//This is my connection string i have assigned the database file address path
string MyConnection2 = "datasource=localhost;port=3306;username=root";
//This is my insert query in which i am taking input from the user through windows forms
string Query = "insert into schoolfees.rooms(room_name,room_code,type_id) values('" + this.rmname.Text + "','" + this.rmcode.Text + "','" + this.rmtype.Text + "');";
//This is MySqlConnection here i have created the object and pass my connection string.
MySqlConnection MyConn2 = new MySqlConnection(MyConnection2);
//This is command class which will handle the query and connection object.
MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2);
MySqlDataReader MyReader2;
MyConn2.Open();
MyReader2 = MyCommand2.ExecuteReader(); // Here our query will be executed and data saved into the database.
MessageBox.Show("Save Data");
while (MyReader2.Read())
{
}
MyConn2.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
/* appoint_create form = new appoint_create();
* this.Close();
* form.Show();
*/
this.Close();
roomadd ra = new roomadd();
ra.Show();
}