private void Special_Stud_Button_Click(object sender, EventArgs e) { Modifay_2_classes form2 = new Modifay_2_classes(); form2.TopLevel = false; form2.FormBorderStyle = FormBorderStyle.None; form2.WindowState = FormWindowState.Maximized; panel5.Controls.Add(form2); panel5.Visible = true; form2.Show(); }
private void button1_Click(object sender, EventArgs e) { try { this.connetionString = "Data Source = whitesnow.database.windows.net; Initial Catalog = Mazal; Integrated Security = False; User ID = Grimm; Password = #!7Dwarfs; Connect Timeout = 15; Encrypt = False; TrustServerCertificate = True; ApplicationIntent = ReadWrite; MultiSubnetFailover = False"; this.sqlcon = new SqlConnection(connetionString); if (dateSem1.Text.Equals("") && !dateSem2.Text.Equals("")) { try { SqlCommand cmd = new SqlCommand("UPDATE Classes_SM2 SET Class_Id =REPLACE(Class_Id, '" + class2.Text + "', 'tmp') WHERE date='" + dateSem2.Text + "'", sqlcon); SqlDataAdapter sda = new SqlDataAdapter(); sda.SelectCommand = cmd; DataTable dbdataset = new DataTable(); sda.Fill(dbdataset); BindingSource bsource = new BindingSource(); bsource.DataSource = dbdataset; sda.Update(dbdataset); SqlCommand cmd2 = new SqlCommand("UPDATE Classes_SM2 SET Class_Id =REPLACE(Class_Id, '" + class1.Text + "','" + class2.Text + "') WHERE date='" + dateSem2.Text + "'", sqlcon); SqlDataAdapter sda2 = new SqlDataAdapter(); sda2.SelectCommand = cmd2; DataTable dbdataset2 = new DataTable(); sda2.Fill(dbdataset2); BindingSource bsource2 = new BindingSource(); bsource2.DataSource = dbdataset2; sda2.Update(dbdataset2); SqlCommand cmd3 = new SqlCommand("UPDATE Classes_SM2 SET Class_Id =REPLACE(Class_Id, 'tmp','" + class1.Text + "') WHERE date='" + dateSem2.Text + "'", sqlcon); SqlDataAdapter sda3 = new SqlDataAdapter(); sda3.SelectCommand = cmd3; DataTable dbdataset3 = new DataTable(); sda3.Fill(dbdataset3); BindingSource bsource3 = new BindingSource(); bsource3.DataSource = dbdataset3; sda3.Update(dbdataset3); } catch (Exception ex) { MessageBox.Show(ex.Message); } MessageBox.Show("Change completed."); } else if (dateSem2.Text.Equals("") && !dateSem1.Text.Equals("")) { try { SqlCommand cmd = new SqlCommand("UPDATE Classes_SM1 SET Class_Id =REPLACE(Class_Id, '" + class2.Text + "', 'tmp') WHERE date='" + dateSem1.Text + "'", sqlcon); SqlDataAdapter sda = new SqlDataAdapter(); sda.SelectCommand = cmd; DataTable dbdataset = new DataTable(); sda.Fill(dbdataset); BindingSource bsource = new BindingSource(); bsource.DataSource = dbdataset; sda.Update(dbdataset); SqlCommand cmd2 = new SqlCommand("UPDATE Classes_SM1 SET Class_Id =REPLACE(Class_Id, '" + class1.Text + "','" + class2.Text + "') WHERE date='" + dateSem1.Text + "'", sqlcon); SqlDataAdapter sda2 = new SqlDataAdapter(); sda2.SelectCommand = cmd2; DataTable dbdataset2 = new DataTable(); sda2.Fill(dbdataset2); BindingSource bsource2 = new BindingSource(); bsource2.DataSource = dbdataset2; sda2.Update(dbdataset2); SqlCommand cmd3 = new SqlCommand("UPDATE Classes_SM1 SET Class_Id =REPLACE(Class_Id, 'tmp','" + class1.Text + "') WHERE date='" + dateSem1.Text + "'", sqlcon); SqlDataAdapter sda3 = new SqlDataAdapter(); sda3.SelectCommand = cmd3; DataTable dbdataset3 = new DataTable(); sda3.Fill(dbdataset3); BindingSource bsource3 = new BindingSource(); bsource3.DataSource = dbdataset3; sda3.Update(dbdataset3); } catch (SqlException ex) { this.Close(); MessageBox.Show("Error selecting class id, try again!\n" + ex.ToString()); } catch (Exception ex) { MessageBox.Show(ex.Message); } MessageBox.Show("Change completed."); } else { this.Close(); MessageBox.Show("Error selecting dates, try again!"); Modifay_2_classes form2 = new Modifay_2_classes(); form2.Show(); } this.sqlcon.Close(); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }