private void button5_Click(object sender, EventArgs e)
        {
            var RoomsTableAdapter = new Learning_databasesDataSetTableAdapters.RoomsTableAdapter();
            var courseId          = (int)RoomsTableAdapter.InsertRoom(RoomName.Text, int.Parse(NumberOfStudentstxt.Text));

            MessageBox.Show(courseId.ToString());
        }
 private void btnDeleteRow_Click(object sender, EventArgs e)
 {
     var RoomTableAdapter = new Learning_databasesDataSetTableAdapters.RoomsTableAdapter();
     var RoomId           = RoomTableAdapter.DeleteRoom(int.Parse(DeleteRoomtxt.Text));
 }