private void button1_Click(object sender, EventArgs e) { if (txtName.Text == "" || txtFathers_Name.Text == "" || txtReg_no.Text == "" || txtCourse.Text == "" || txtDoj.Text == "" || txtDoj.Text == "" || txtCompletionDate.Text == "" || txtGrade.Text == "" || txtMarks.Text == "") { MessageBox.Show("all fields are required"); } else { con = new SqlConnection(connstr); con.Open(); cmd = new SqlCommand("insert into student values(@n,@f,@r,@c,@dj,@dc,@g,@m)", con); cmd.Parameters.Add(new SqlParameter("@n", txtName.Text)); cmd.Parameters.Add(new SqlParameter("@f", txtFathers_Name.Text)); cmd.Parameters.Add(new SqlParameter("@r", Convert.ToInt32(txtReg_no.Text))); cmd.Parameters.Add(new SqlParameter("@c", txtCourse.Text)); cmd.Parameters.Add(new SqlParameter("@dj", txtDoj.Text)); cmd.Parameters.Add(new SqlParameter("@dc", txtCompletionDate.Text)); cmd.Parameters.Add(new SqlParameter("@g", txtGrade.Text)); cmd.Parameters.Add(new SqlParameter("@m", Convert.ToDecimal(txtMarks.Text))); dr = cmd.ExecuteReader(); MessageBox.Show("student details saved"); this.Hide(); menu m = new menu(); m.Show(); } }
private void button2_Click(object sender, EventArgs e) { this.Hide(); menu m = new menu(); m.Show(); }
private void button1_Click(object sender, EventArgs e) { if (txtUser_Name.Text == "user366pi" && txtPassword.Text == "366pi") { this.Hide(); menu m = new menu(); m.Show(); } else if (txtUser_Name.Text == "" || txtPassword.Text == "") { MessageBox.Show("Please fill the user name and password"); } else { MessageBox.Show("Not a valid user.", "Login", MessageBoxButtons.OK); txtUser_Name.Text = ""; txtPassword.Text = ""; } }