private void cmbClass_SelectedIndexChanged(object sender, EventArgs e) { CmbSection.Items.Clear(); CmbSection.Text = ""; CmbSection.Enabled = true; CmbSection.Focus(); try { con = new SqlConnection(cs.DBcon); con.Open(); string ct = "select distinct RTRIM(Section) from class where ClassName = '" + cmbClass.Text + "'"; cmd = new SqlCommand(ct); cmd.Connection = con; rdr = cmd.ExecuteReader(); while (rdr.Read()) { CmbSection.Items.Add(rdr[0]); } con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnSave_Click(object sender, EventArgs e) { try { if (txtGender.Text == "") { MessageBox.Show("Please select gender", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtGender.Focus(); return; } if (cmbCategory.Text == "") { MessageBox.Show("Please select Category", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cmbCategory.Focus(); return; } if (txtFathername.Text == "") { MessageBox.Show("Please enter father's name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtFathername.Focus(); return; } if (txtSession.Text == "") { MessageBox.Show("Please enter session", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtSession.Focus(); return; } if (dtpDOB.Text == "") { MessageBox.Show("Please enter dob", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); dtpDOB.Focus(); return; } if (txtMotherName.Text == "") { MessageBox.Show("Please enter mother's name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtMotherName.Focus(); return; } if (cmbReligion.Text == "") { MessageBox.Show("Please select religion", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cmbReligion.Focus(); return; } if (txtPermanentAddress.Text == "") { MessageBox.Show("Please select address", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtPermanentAddress.Focus(); return; } if (txtContactNo.Text == "") { MessageBox.Show("Please enter contact no.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtContactNo.Focus(); return; } if (txtEmailID.Text == "") { MessageBox.Show("Please enter email", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtEmailID.Focus(); return; } if (cmbClass.Text == "") { MessageBox.Show("Please select class", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cmbClass.Focus(); return; } if (CmbSection.Text == "") { MessageBox.Show("Please select Section", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); CmbSection.Focus(); return; } if (cmbSchoolName.Text == "") { MessageBox.Show("Please select SchoolName", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cmbSchoolName.Focus(); return; } if (txtNationality.Text == "") { MessageBox.Show("Please enter nationality", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtNationality.Focus(); return; } auto(); con = new SqlConnection(cs.DBcon); con.Open(); string cb = "insert into Student(AdmissionNo, EnrollmentNo, StudentName, FatherName, MotherName, FatherCN, PermanentAddress, TemporaryAddress, ContactNo, EmailID, DOB, Gender, AdmissionDate, Session, Caste, Religion, Class,Photo, Status,Nationality,Section,SchoolID) VALUES (@d1,@d2,@d3,@d4,@d5,@d6,@d7,@d8,@d9,@d10,@d11,@d12,@d13,@d14,@d15,@d16,@d17,@d18,@d19,@d20,@d21,@d22)"; //id li cmd = new SqlCommand(cb); cmd.Connection = con; cmd.Parameters.AddWithValue("@d1", txtAdmissionNo.Text); cmd.Parameters.AddWithValue("@d2", txtEnrollmentNo.Text); cmd.Parameters.AddWithValue("@d3", txtStudentName.Text); cmd.Parameters.AddWithValue("@d4", txtFathername.Text); cmd.Parameters.AddWithValue("@d5", txtMotherName.Text); cmd.Parameters.AddWithValue("@d6", txtFatherContactNo.Text); cmd.Parameters.AddWithValue("@d7", txtPermanentAddress.Text); cmd.Parameters.AddWithValue("@d8", txtTemrorayAddress.Text); cmd.Parameters.AddWithValue("@d9", txtContactNo.Text); cmd.Parameters.AddWithValue("@d10", txtEmailID.Text); cmd.Parameters.AddWithValue("@d11", dtpDOB.Text); cmd.Parameters.AddWithValue("@d12", txtGender.Text); cmd.Parameters.AddWithValue("@d13", dtpAdmissionDate.Text); cmd.Parameters.AddWithValue("@d14", txtSession.Text); cmd.Parameters.AddWithValue("@d15", cmbCategory.Text); cmd.Parameters.AddWithValue("@d16", cmbReligion.Text); cmd.Parameters.AddWithValue("@d17", cmbClass.Text); cmd.Parameters.AddWithValue("@d19", cmbStatus.Text); cmd.Parameters.AddWithValue("@d20", txtNationality.Text); cmd.Parameters.AddWithValue("@d21", CmbSection.Text); cmd.Parameters.AddWithValue("@d22", txtSchoolID.Text); MemoryStream ms = new MemoryStream(); Bitmap bmpImage = new Bitmap(Picture.Image); bmpImage.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); byte[] data = ms.GetBuffer(); SqlParameter p = new SqlParameter("@d18", SqlDbType.Image); p.Value = data; cmd.Parameters.Add(p); cmd.ExecuteReader(); con.Close(); st1 = lblUser.Text; st2 = "added the new student '" + txtStudentName.Text + "'"; cf.LogFunc(st1, System.DateTime.Now, st2); MessageBox.Show("Successfully saved", "Student Details", MessageBoxButtons.OK, MessageBoxIcon.Information); btnSave.Enabled = false; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }