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(); }
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(); } }