private void btn_std_reg_Click(object sender, EventArgs e) { this.Hide(); registered_students student = new registered_students(); student.Show(); }
private void button1_Click(object sender, EventArgs e) { this.Close(); registered_students stu = new registered_students(); stu.Show(); }
//Method to insert data public void save() { adpt = new SqlDataAdapter("Select username from LoginTable", con.openconn()); adpt.Fill(dt); con.connclose(); int username = 0; for (int i = 0; i < dt.Rows.Count - 1; i++) { if (dt.Rows[i]["username"].ToString() == username_textbox.Text) { username = 1; } } if ((text_stdname.Text == "") || (text_lastname.Text == "") || (text_fathername.Text == "") || (text_fatherid.Text == "") || (text_email.Text == "") || (text_mobile.Text == "") || (combo_class.Text == "") || (dobpicker.Text == "") || (text_address.Text == "") || (combo_province.Text == "") || (combo_city.Text == "") || (combo_country.Text == "") || (StdpictureBox.Image == null) || (rdn_male.Checked == false) && (rdn_female.Checked == false)) { MessageBox.Show("One or more Fields are Empty..!"); } else if (username == 1) { MessageBox.Show("Username Already Exits"); } else { if (flag == 0) { con.openconn(); if (rdn_male.Checked) { gender = "Male"; } else { gender = "Female"; } SqlCommand cmd = new SqlCommand("INSERT INTO Student(Firstname,Lastname,Fathername,Fatherid,email,mobileno,Class,Datefbirth,Address,Gender,Countryid,Cityid,Provinceid,studentimage) VALUES ('" + text_stdname.Text + "','" + text_lastname.Text + "','" + text_fathername.Text + "','" + text_fatherid.Text + "','" + text_email.Text + "','" + text_mobile.Text + "','" + Convert.ToInt32(combo_class.SelectedValue) + "','" + Convert.ToDateTime(dobpicker.Text) + "','" + text_address.Text + "','" + gender + "','" + Convert.ToInt32(combo_country.SelectedValue) + "','" + Convert.ToInt32(combo_city.SelectedValue) + "','" + Convert.ToInt32(combo_province.SelectedValue) + "',@studentimage)", con.openconn()); MemoryStream stream = new MemoryStream(); StdpictureBox.Image.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg); String user = "******"; SqlCommand login_table = new SqlCommand("Insert into LoginTable(username,password,role) values ('" + username_textbox.Text + "','" + pass_textBox.Text + "','" + user + "')", con.openconn()); byte[] pic = stream.ToArray(); cmd.Parameters.AddWithValue("@studentimage", pic); j = cmd.ExecuteNonQuery(); login_table.ExecuteNonQuery(); if (j > 0) { MessageBox.Show("Record Save Successfully!" + j + "Row"); } } else { SqlCommand cmd = new SqlCommand("update Student set Firstname='" + text_stdname.Text + "', Lastname='" + text_lastname.Text + "',Fathername='" + text_fathername.Text + "',Fatherid='" + text_fatherid.Text + "',Email='" + text_email.Text + "',Mobileno='" + text_mobile.Text + "',studentimage='" + StdpictureBox.Image + "',Class='" + combo_class.SelectedValue.ToString() + "',Datefbirth='" + Convert.ToDateTime(dobpicker.Text) + "',Address='" + text_address.Text + "',Gender='" + gender + "',CountryID='" + combo_country.SelectedValue.ToString() + "',ProvinceID='" + combo_province.SelectedValue.ToString() + "',CityID='" + combo_city.SelectedValue.ToString() + "' Where Studentid = '" + id + "'", con.openconn()); cmd.ExecuteNonQuery(); } con.connclose(); registered_students r = new registered_students(); r.Show(); this.Dispose(); } }