Пример #1
0
        private void button2_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(CString);

            con.Open();

            SqlCommand exe = new SqlCommand("INSERT INTO Rubric(Details,CloId) values('" + Details.Text + "','" + comboBox1.SelectedValue + "')", con);

            exe.ExecuteNonQuery();
            MessageBox.Show("Added!");
            this.Hide();
            Form7 frm = new Form7();

            frm.Show();
        }
Пример #2
0
        private void button2_Click(object sender, EventArgs e)
        {
            SqlConnection c = new SqlConnection(string_con);

            c.Open();


            string     QUERY = "INSERT INTO Rubric(Details,CloId) values('" + Details.Text + "','" + comboBox1.SelectedValue + "')";
            SqlCommand cm    = new SqlCommand(QUERY, c);

            cm.ExecuteNonQuery();
            MessageBox.Show("Added!");

            Form7 frm = new Form7();

            frm.Show();
        }
Пример #3
0
        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            SqlConnection con = new SqlConnection(CString);

            con.Open();

            if (e.ColumnIndex == dataGridView1.Columns["del"].Index)
            {
                int        row = e.RowIndex;
                int        sel = Convert.ToInt32(dataGridView1.Rows[row].Cells["Id"].Value);
                SqlCommand exe = new SqlCommand("DELETE FROM Rubric WHERE Id = '" + sel + "'", con);
                exe.ExecuteNonQuery();
                MessageBox.Show("Deleted!");
                this.Hide();
                Form7 form = new Form7();
                form.Show();
            }
        }
Пример #4
0
        private void button2_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(ConnectionString);

            con.Open();


            SqlCommand exe = new SqlCommand("UPDATE dbo.Rubric SET Details = '" + CloDetails.Text + "' WHERE Id = '" + ID + "' ", con);

            exe.ExecuteNonQuery();

            MessageBox.Show("Edit Successfully!");

            Form7 frm = new Form7();

            this.Hide();
            frm.Show();
        }
Пример #5
0
        private void button6_Click_1(object sender, EventArgs e)
        {
            Form7 newFORM = new Form7();

            newFORM.Show();
        }