Beispiel #1
0
        private void button4_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection("Data Source=DESKTOP-6FG9FQD;Initial Catalog=StudentDMC;Integrated Security=True");

            con.Open();

            string query = "INSERT INTO COURSE_DETAILS(COURSE_ID, COURSE_NAME, CRDHRS, SEMESTER, MARKS, FK_REG_NUM)" +
                           "VALUES(@course_id, @course_name, @crdh, @sem, @marks, @regnum)";

            SqlCommand cmd = new SqlCommand(query, con);

            cmd.Parameters.AddWithValue("@course_id", idtxt.Text);
            cmd.Parameters.AddWithValue("@course_name", coursenametxt.Text);
            cmd.Parameters.AddWithValue("@crdh", crdhrstxt.Text);
            cmd.Parameters.AddWithValue("@sem", semestertxt.Text);
            cmd.Parameters.AddWithValue("@marks", markstxt.Text);
            cmd.Parameters.AddWithValue("@regnum", regnumtxt.Text);


            cmd.ExecuteNonQuery();
            MessageBox.Show("Record added!");

            idtxt.Text         = "";
            coursenametxt.Text = "";
            crdhrstxt.Text     = "";
            semestertxt.Text   = "";
            regnumtxt.Text     = "";

            con.Close();

            this.Hide();
            AddStudent s1 = new AddStudent();

            s1.Show();
        }
        private void button2_Click(object sender, EventArgs e)
        {
            showData();
            this.Hide();
            AddStudent s1 = new AddStudent();

            s1.Show();
        }