private void resetFormToolStripMenuItem_Click(object sender, EventArgs e)
 {
     StudentId.Clear();
     StudentName.Clear();
     Std.Clear();
     Div.Clear();
     RollNo.Clear();
     Gender.Clear();
     Category.Clear();
     dob.Clear();
     StudentId.Focus();
 }
Пример #2
0
 private void Remove_From_Cyber_Click_1(object sender, EventArgs e)
 {
     try
     {
         SqlConnection con = new SqlConnection(@"Data Source=mahdias.database.windows.net;Initial Catalog=ProjectSCE;User ID=Mahdias;Password=Aa123123");
         SqlCommand    cmd = new SqlCommand("update Project_Sce.CodeLayer.Student set Cyber='false' where StudID= @ID", con);
         cmd.Parameters.Add("@ID", SqlDbType.NVarChar).Value = StudentId.Text;
         if (con.State == ConnectionState.Closed)
         {
             con.Open();
         }
         cmd.ExecuteNonQuery();
         StudentId.Clear();
         MessageBox.Show("The student was successfully removed from the cyber section!", "Remove From Cyber", MessageBoxButtons.OK, MessageBoxIcon.Information);
         dataGridView1.DataSource = std.get_All_Students();
     }
     catch (Exception ex) { string x = ex.ToString(); }
 }