コード例 #1
0
        private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            Manage_Rubric f = new Manage_Rubric();

            this.Hide();
            f.Show();
        }
コード例 #2
0
        private void button3_Click(object sender, EventArgs e)
        {
            Manage_Rubric f = new Manage_Rubric();

            this.Hide();
            f.Show();
        }
コード例 #3
0
        private void button1_Click(object sender, EventArgs e)
        {
            string        constr = "Data Source=DESKTOP-GP94IEM\\SQLEXPRESS;Initial Catalog=Projectb;Integrated Security=True";
            SqlConnection c      = new SqlConnection(constr);

            c.Open();
            try
            {
                if ((comboBox1.Text == "") || (comboBox2.Text == "") || (textBox3.Text == ""))
                {
                    MessageBox.Show("Submssion is not allowed with null values");
                }
                else
                {
                    int        f   = dataGridView1.CurrentCell.RowIndex;
                    int        id4 = (int)(dataGridView1.Rows[f].Cells["Id"].Value);
                    string     sg  = string.Format("SELECT Id From Rubric where  Details=@Details");
                    SqlCommand db  = new SqlCommand(sg, c);
                    string     d   = "";
                    d = comboBox1.Text;
                    db.Parameters.Add(new SqlParameter("@Details", d));
                    int g = (int)db.ExecuteScalar();
                    //comboBox1.Text = g;


                    string s1 = string.Format("UPDATE RubricLevel SET Details=@Details, MeasurementLevel=@MeasurementLevel, RubricId=@RubricId where Id=@Id");



                    SqlCommand a2 = new SqlCommand(s1, c);

                    a2.Parameters.Add(new SqlParameter("@Id", id4));

                    a2.Parameters.Add(new SqlParameter("@Details", SqlDbType.VarChar));
                    a2.Parameters["@Details"].Value = textBox3.Text;
                    a2.Parameters.Add(new SqlParameter("@MeasurementLevel", SqlDbType.Int));
                    a2.Parameters["@MeasurementLevel"].Value = Convert.ToInt16(comboBox2.Text);
                    a2.Parameters.Add(new SqlParameter("@RubricId", SqlDbType.Int));
                    a2.Parameters["@RubricId"].Value = g;

                    int rows = a2.ExecuteNonQuery();
                    if (rows != 0)
                    {
                        MessageBox.Show("RubricsLevel Updated");
                        c.Close();
                        panel4.Hide();
                        this.Close();
                        Manage_Rubric j = new Manage_Rubric();
                        j.Show();
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
コード例 #4
0
ファイル: Form1.cs プロジェクト: AqsaZahid256/DBMS_Project
        private void linkLabel10_LinkClicked_1(object sender, LinkLabelLinkClickedEventArgs e)
        {
            Manage_Rubric i = new Manage_Rubric();

            i.Show();
        }
コード例 #5
0
        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            string        constr = "Data Source=DESKTOP-GP94IEM\\SQLEXPRESS;Initial Catalog=Projectb;Integrated Security=True";
            SqlConnection conn   = new SqlConnection(constr);

            conn.Open();
            if (dataGridView1.Columns[e.ColumnIndex].Name == "Delete" && (e.RowIndex >= 0))
            {
                try
                {
                    MessageBox.Show("you are going to delete this row");



                    int Reg = (int)(dataGridView1.Rows[e.RowIndex].Cells["Id"].Value);

                    string     Id = string.Format("DELETE FROM RubricLevel WHERE Id=@Id");
                    SqlCommand p  = new SqlCommand(Id, conn);
                    p.Parameters.AddWithValue("@Id", Reg);
                    int i = p.ExecuteNonQuery();
                    if (i != 0)
                    {
                        MessageBox.Show("Data deleted");
                        this.Hide();
                        Manage_Rubric d1 = new Manage_Rubric();
                        d1.Show();
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
                conn.Close();
            }
            else if (dataGridView1.Columns[e.ColumnIndex].Name == "Edit" && (e.RowIndex >= 0))
            {
                //int f = dataGridView1.CurrentCell.RowIndex;
                int id4 = (int)(dataGridView1.Rows[e.RowIndex].Cells["Id"].Value);
                //MessageBox.Show("Updating this entry");

                /**SqlDataAdapter da = new SqlDataAdapter("select Id FROM Clo", conn);
                 * DataTable t = new DataTable();
                 * da.Fill(t);
                 * comboBox1.DisplayMember = "id";
                 * comboBox1.DataSource = t;
                 * //SqlDataReader dr = com.ExecuteReader();**/

                string s2 = string.Format("SELECT Details, MeasurementLevel, RubricId from RubricLevel where Id=@Id");
                //string s2 = string.Format("SELECT Details,MeasurementLevel FROM RubricLevel Where Id=@Id");
                SqlCommand d = new SqlCommand(s2, conn);
                d.Parameters.Add(new SqlParameter("@Id", id4));
                SqlDataReader dr = d.ExecuteReader();
                comboBox2.Items.Clear();

                try
                {
                    int h = 0;
                    while (dr.Read())
                    {
                        //comboBox1.Text = dr.GetString(0);
                        comboBox2.Text = Convert.ToString(dr.GetValue(1));
                        textBox3.Text  = dr.GetString(0);
                        h = (int)dr.GetValue(2);
                    }
                    dr.Close();

                    comboBox1.Items.Clear();
                    string     sg = string.Format("SELECT Details From Rubric");
                    SqlCommand db = new SqlCommand(sg, conn);
                    //db.Parameters.Add(new SqlParameter("@id", h));
                    //SqlDataReader dr = d.ExecuteReader();
                    dr = db.ExecuteReader();
                    while (dr.Read())
                    {
                        comboBox1.Items.Add(dr.GetString(0));
                    }

                    panel4.Show();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
            else
            {
                MessageBox.Show("No Rows Availiable");
            }
        }
コード例 #6
0
        private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            Manage_Rubric c = new Manage_Rubric();

            c.Show();
        }