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
            {
                Add_Rubrics s = new Add_Rubrics();
                s.set_CloId(comboBox1.Text);
                s.set_Details(Deta.Text);

                if ((s.get_CloId() == 0) || (s.get_Details() == null || s.get_Details() == ""))
                {
                    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     s1 = string.Format("UPDATE Rubric SET CloId=@CloId, Details=@Details where Id=@Id");
                    SqlCommand a2 = new SqlCommand(s1, c);

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

                    a2.Parameters.Add(new SqlParameter("@CloId", SqlDbType.Int));
                    a2.Parameters["@CloId"].Value = s.get_CloId();
                    a2.Parameters.Add(new SqlParameter("@Details", SqlDbType.VarChar));
                    a2.Parameters["@Details"].Value = s.get_Details();

                    int rows = a2.ExecuteNonQuery();
                    if (rows != 0)
                    {
                        MessageBox.Show("Rubrics Updated");
                        c.Close();
                        panel1.Hide();
                        this.Close();
                        Manage_Rubrics j = new Manage_Rubrics();
                        j.Show();
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Esempio n. 2
0
        private void linkLabel5_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            Manage_Rubrics r = new Manage_Rubrics();

            r.Show();
        }
        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 Rubric 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_Rubrics d1 = new Manage_Rubrics();
                        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 CloId,Details FROM Rubric Where Id=@Id");
                SqlCommand d  = new SqlCommand(s2, conn);
                d.Parameters.Add(new SqlParameter("@Id", id4));
                SqlDataReader dr = d.ExecuteReader();
                try
                {
                    while (dr.Read())
                    {
                        comboBox1.Text = (Convert.ToString(dr.GetValue(0)));
                        Deta.Text      = dr.GetString(1);
                    }
                    dr.Close();
                    panel1.Show();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
            else
            {
                MessageBox.Show("No Rows Availiable");
            }
        }