private void bunifuThinButton21_Click(object sender, EventArgs e) { SqlDataAdapter adapter = new SqlDataAdapter("select count(class_id) from classrooms where class_name= '" + ClassNameBox.Text + "' ", con); DataTable dat = new DataTable(); adapter.Fill(dat); int Count = int.Parse(dat.Rows[0][0].ToString()); if (string.IsNullOrWhiteSpace(ClassNameBox.Text) && ClassNameBox.Text.Length > 0 || ClassNameBox.Text == "") { Dialogue.Show("Invalid Input or Empty", "", "Ok", "Cancel"); }//If End else if (Count != 0) { Dialogue.Show("Classroom Already Exist! Please use Other Name", "", "Ok", "Cancel"); } else { DialogResult result = Dialogue1.Show("Are You Sure?", "", "Ok", "Cancel"); if (result == DialogResult.Yes) { SqlDataAdapter adapt = new SqlDataAdapter("select class_id from classrooms where class_name= '" + Cname + "'", con); DataTable dt = new DataTable(); adapt.Fill(dt); int ID = int.Parse(dt.Rows[0][0].ToString());//Getting the ID of The Classroom con.Open(); String query = "UPDATE classrooms SET class_name= '" + ClassNameBox.Text + " ' WHERE facilitator_id= '" + Program.user_id + "' AND class_id= '" + ID + "' "; SqlDataAdapter sda = new SqlDataAdapter(query, con); int n = sda.SelectCommand.ExecuteNonQuery(); con.Close(); CreateMyClassroom CC = (CreateMyClassroom)Application.OpenForms["CreateMyClassroom"]; CC.Load_Class(); CC.Load_Participant(); this.Close(); } else { Dialogue.Show("Fail to Update", "", "Ok", "Cancel"); } } }
////EXPORT TO EXCEL //private void ToExcel(DataGridView dGV, string filename) //{ // string stOutput = ""; // string sHeaders = ""; // for(int j = 0; j < dGV.Columns.Count; j++) // sHeaders = sHeaders.ToString() + Convert.ToString(dGV.Columns[j].HeaderText) + "\t"; // stOutput += sHeaders + "\r\n"; // for(int i = 0; i < dGV.RowCount-1; i++) // { // string stline = ""; // for (int j = 0; j < dGV.Rows[i].Cells.Count; j++) // stline = stline.ToString() + Convert.ToString(dGV.Rows[i].Cells[j].Value) + "\t"; // stOutput += stline + "\r\n"; // } // Encoding utf16 = Encoding.GetEncoding(1254); // byte[] output = utf16.GetBytes(stOutput); // FileStream fs = new FileStream(filename, FileMode.Create); // BinaryWriter bw = new BinaryWriter(fs); // bw.Write(output, 0, output.Length); // bw.Flush(); // bw.Close(); // fs.Close(); //} private void buttonCreateClassroom_Click(object sender, EventArgs e) { CreateMyClassroom Create = new CreateMyClassroom(); Create.ShowDialog(); }