示例#1
0
        /// <summary>
        /// function creates a new object of viewstudent form and close the current form
        /// </summary>
        /// <param name="sender">sender is the object sender that raised the event.</param>
        /// <param name="e"> e is the Event Argument of the object and basically contains the event data</param>
        private void button2_Click_1(object sender, EventArgs e)
        {
            ViewStudent stu = new ViewStudent();

            this.Hide();
            stu.Show();
        }
示例#2
0
        /// <summary>
        /// function creates a new object of viewstudent form and close the current form
        /// </summary>
        /// <param name="sender">sender is the object sender that raised the event.</param>
        /// <param name="e"> e is the Event Argument of the object and basically contains the event data</param>
        private void button2_Click_2(object sender, EventArgs e)
        {
            ViewStudent vs = new ViewStudent();

            this.Hide();
            vs.Show();
        }
示例#3
0
        /// <summary>
        /// Update the student
        /// </summary>
        /// <param name="sender">sender is the object sender that raised the event.</param>
        /// <param name="e"> e is the Event Argument of the object and basically contains the event data</param>
        private void button6_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(connection);

            con.Open();
            if (con.State == ConnectionState.Open)
            {
                string query = "UPDATE dbo.Student SET FirstName = '" + textBox1.Text + "', LastName = '" + textBox2.Text + "',Contact = '" + textBox3.Text + "', Email = '" + textBox4.Text + "', RegistrationNumber = '" + textBox5.Text + "', Status = '" + 5 + "' WHERE Id = '" + ID + "'";

                SqlCommand cmd = new SqlCommand(query, con);
                cmd.ExecuteNonQuery();
                MessageBox.Show("Updated");
                ViewStudent vs = new ViewStudent();
                this.Hide();
                vs.Show();
            }
        }
示例#4
0
        /// <summary>
        /// Edit and Delete Funcytionality Against each of the student in gridview
        /// </summary>
        /// <param name="sender">sender is the object sender that raised the event.</param>
        /// <param name="e"> e is the Event Argument of the object and basically contains the event data</param>
        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            //this code excuted when e.columnindex is equal to the edit column Index
            if (e.ColumnIndex == dataGridView1.Columns["Edit"].Index)
            {
                SqlConnection con = new SqlConnection(connection);
                con.Open();
                if (con.State == ConnectionState.Open)
                {
                    int         ID      = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells["Id"].Value);
                    string      fname   = (dataGridView1.Rows[e.RowIndex].Cells["FirstName"].Value).ToString();
                    string      lname   = (dataGridView1.Rows[e.RowIndex].Cells["LastName"].Value).ToString();
                    string      contact = (dataGridView1.Rows[e.RowIndex].Cells["Contact"].Value).ToString();
                    string      email   = (dataGridView1.Rows[e.RowIndex].Cells["Email"].Value).ToString();
                    string      rg      = (dataGridView1.Rows[e.RowIndex].Cells["RegistrationNumber"].Value).ToString();
                    int         status  = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells["Status"].Value);
                    StudentEdit frm     = new StudentEdit(ID, fname, lname, contact, email, rg, status);
                    this.Hide();
                    frm.Show();
                }
            }
            //this code excuted when e.columnindex is equal to the Delete column Index
            if (e.ColumnIndex == dataGridView1.Columns["Delete"].Index)
            {
                SqlConnection con = new SqlConnection(connection);
                con.Open();
                if (con.State == ConnectionState.Open)
                {
                    int    ID    = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells["Id"].Value);
                    string query = "UPDATE dbo.Student SET Status = '" + 6 + "'  WHERE Id = '" + ID + "'";

                    SqlCommand cmd = new SqlCommand(query, con);
                    cmd.ExecuteNonQuery();
                    MessageBox.Show("Updated");
                    ViewStudent vs = new ViewStudent();
                    this.Hide();
                    vs.Show();
                }
            }
        }