예제 #1
0
        private void button7_Click(object sender, EventArgs e)
        {
            RubricLevelGV h = new RubricLevelGV();

            this.Hide();
            h.Show();
        }
예제 #2
0
 private void button1_Click(object sender, EventArgs e)
 {
     if (richTextBox1.Text != "" && comboBox1.Text != "")
     {
         string RubricId = (comboBox1.SelectedItem as ComboboxItem).Value.ToString();
         if (button1.Text == "Add RubricLevel")
         {
             SqlConnection conn = new SqlConnection("Data Source=DESKTOP-OQV6IBM;Initial Catalog=ProjectB;Integrated Security=True");
             conn.Open();
             string     Query = "insert into RubricLevel(Details,RubricId,MeasurementLevel) values('" + this.richTextBox1.Text + "','" + RubricId + "','" + this.textBox1.Text + "')";
             SqlCommand cmd   = new SqlCommand(Query, conn);
             cmd.ExecuteNonQuery();
             MessageBox.Show("RubricLevel Successfully Added");
         }
         else
         {
             SqlConnection conn = new SqlConnection("Data Source=DESKTOP-OQV6IBM;Initial Catalog=ProjectB;Integrated Security=True");
             conn.Open();
             string     Query = "update RubricLevel set Details='" + this.richTextBox1.Text + "',RubricId='" + RubricId + "',MeasurementLevel = '" + this.textBox1.Text + "'  where Id = '" + StdId + "'";
             SqlCommand cmd   = new SqlCommand(Query, conn);
             cmd.ExecuteNonQuery();
             MessageBox.Show("RubricLevel Updated Successfuly");
         }
         RubricLevelGV h = new RubricLevelGV();
         this.Hide();
         h.Show();
     }
     else
     {
         MessageBox.Show("Please fill all the required fields");
     }
 }