07-05-2011, 02:50 PM
AddSubjectForm.cs
[code]using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
namespace SchoolManagementSystem
{
public partial class AddSubjectForm : Form
{
OleDbConnection cn = new OleDbConnection(ConnectionStringForSMS.MyConnectionString());
int count;
string[] val = new string[15];
public AddSubjectForm()
{
InitializeComponent();
}
private void AddSubjectForm_Load(object sender, EventArgs e)
{
OleDbDataAdapter da23 = new OleDbDataAdapter("select schooltitle,Address from schooltitle", cn);
DataSet ds23 = new DataSet();
da23.Fill(ds23);
string schooltitle = ds23.Tables[0].Rows[0].ItemArray[0].ToString();
string address = ds23.Tables[0].Rows[0].ItemArray[1].ToString();
this.Text = schooltitle + "- Add Subjects";
lbltitle.Text = "";
lbltitle.Text = schooltitle;
cbxclass.Text = "--Select--";
cbxExam.Text = "--Select--";
cbxmedium.SelectedIndex = 0;
lblsubj.Visible = false;
lblMinMarks.Visible = false;
lblMaxMarks.Visible = false;
}
private void btnsave_Click(object sender, EventArgs e)
{
try
{
data();
checkedListBox1.Visible = false;
btndel.Visible = false;
btnupdate.Visible = false;
btndelete.Enabled = true;
btnmodify.Enabled = true;
if (cbxmedium.SelectedIndex == -1||cbxmedium.SelectedIndex ==0)
{
MessageBox.Show("Select Medium", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
cbxmedium.Focus();
}
else if (cbxclass.SelectedIndex == 0)
{
MessageBox.Show("Select Class", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
cbxclass.Focus();
}
else if (cbxExam.SelectedIndex == -1 || cbxExam.SelectedIndex==0)
{
MessageBox.Show("Select Exam", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
cbxExam.Focus();
}
else if (txtsubject.Text.Trim() == "")
{
MessageBox.Show("Enter Subject", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtsubject.Focus();
}
else if (txtminmarks.Text.Trim() == "")
{
MessageBox.Show("Enter Subject Minimum Marks", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtminmarks.Focus();
}
else if (txtmaxmarks.Text.Trim() == "")
{
MessageBox.Show("Enter Subject Maximum Marks", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtmaxmarks.Focus();
}
else
{
int min = Convert.ToInt32(txtminmarks.Text);
int max = Convert.ToInt32(txtmaxmarks.Text);
if (max <= min)
{
MessageBox.Show("Minimum Marks should not be greater than Maximum Marks");
txtmaxmarks.Focus();
}
else
{
txtsubject.Text = ConnectionStringForSMS.Capitalize(txtsubject.Text);
cn.Open();
string medium = cbxmedium.SelectedItem.ToString();
OleDbDataAdapter daclass = new OleDbDataAdapter("select ClassID from Class where ClassName='" + cbxclass.SelectedItem.ToString() + "'and Medium='" + cbxmedium.SelectedItem.ToString() + "'", cn);
DataSet dsclass = new DataSet();
daclass.Fill(dsclass);
int classid = Convert.ToInt32(dsclass.Tables[0].Rows[0].ItemArray[0]);
OleDbDataAdapter daexam = new OleDbDataAdapter("select ExamID from Exam where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamName='" + cbxExam.SelectedItem.ToString() + "' ", cn);
DataSet dsexam = new DataSet();
daexam.Fill(dsexam);
int examid = Convert.ToInt32(dsexam.Tables[0].Rows[0].ItemArray[0]);
OleDbDataAdapter dasub1 = new OleDbDataAdapter("select SubjectName,MinMarks,MaxMarks from Subject where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamID=" + examid + " ", cn);
DataSet dssub1 = new DataSet();
dasub1.Fill(dssub1);
int c = dssub1.Tables[0].Rows.Count;
if (c < 15)
{
if (c == 0)
{
OleDbCommand cmd = new OleDbCommand("insert into Subject(ClassID,SubjectName,Medium,ExamID,MinMarks,MaxMarks) values(" + classid + ",'" + txtsubject.Text + "','" + medium + "'," + examid + ",'" + txtminmarks.Text + "','" + txtmaxmarks.Text + "')", cn);
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully Inserted", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
OleDbDataAdapter dasub = new OleDbDataAdapter("select SubjectName,MinMarks,MaxMarks from Subject where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamID=" + examid + " ", cn);
DataSet dssub = new DataSet();
dasub.Fill(dssub);
pnlsubject.Visible = true;
checkedListBox1.Visible = false;
lblsubj.Visible = true;
lblMinMarks.Visible = true;
lblMaxMarks.Visible = true;
label3.Visible = true;
label3.Text = "";
label3.Text = "Subjects in " + cbxclass.SelectedItem.ToString();
lblsubj.Text = "";
lblMinMarks.Text = "";
lblMaxMarks.Text = "";
for (int s = 0; s < dssub.Tables[0].Rows.Count; s++)
{
lblsubj.Text += dssub.Tables[0].Rows[s].ItemArray[0].ToString() + "\n";
lblMinMarks.Text += dssub.Tables[0].Rows[s].ItemArray[1].ToString() + "\n";
lblMaxMarks.Text += dssub.Tables[0].Rows[s].ItemArray[2].ToString() + "\n";
}
}
if (c == 1)
{
if (txtsubject.Text != dssub1.Tables[0].Rows[0].ItemArray[0].ToString())
{
OleDbCommand cmd = new OleDbCommand("insert into Subject(ClassID,SubjectName,Medium,ExamID,MinMarks,MaxMarks) values(" + classid + ",'" + txtsubject.Text + "','" + medium + "'," + examid + ",'" + txtminmarks.Text + "','" + txtmaxmarks.Text + "')", cn);
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully Inserted", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
OleDbDataAdapter dasub = new OleDbDataAdapter("select SubjectName,MinMarks,MaxMarks from Subject where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamID=" + examid + " ", cn);
DataSet dssub = new DataSet();
dasub.Fill(dssub);
pnlsubject.Visible = true;
checkedListBox1.Visible = false;
lblsubj.Visible = true;
label3.Visible = true;
label3.Text = "";
label3.Text = "Subjects in " + cbxclass.SelectedItem.ToString();
lblsubj.Text = "";
lblMinMarks.Text = "";
lblMaxMarks.Text = "";
for (int s = 0; s < dssub.Tables[0].Rows.Count; s++)
{
lblsubj.Text += dssub.Tables[0].Rows[s].ItemArray[0].ToString() + "\n";
lblMinMarks.Text += dssub.Tables[0].Rows[s].ItemArray[1].ToString() + "\n";
lblMaxMarks.Text += dssub.Tables[0].Rows[s].ItemArray[2].ToString() + "\n";
}
}
else
{
MessageBox.Show("Already Exists", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (c == 2)
{
if (txtsubject.Text != dssub1.Tables[0].Rows[0].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[1].ItemArray[0].ToString())
{
OleDbCommand cmd = new OleDbCommand("insert into Subject(ClassID,SubjectName,Medium,ExamID,MinMarks,MaxMarks) values(" + classid + ",'" + txtsubject.Text + "','" + medium + "'," + examid + ",'" + txtminmarks.Text + "','" + txtmaxmarks.Text + "')", cn);
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully Inserted", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
OleDbDataAdapter dasub = new OleDbDataAdapter("select SubjectName,MinMarks,MaxMarks from Subject where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamID=" + examid + " ", cn);
DataSet dssub = new DataSet();
dasub.Fill(dssub);
pnlsubject.Visible = true;
checkedListBox1.Visible = false;
lblsubj.Visible = true;
lblMinMarks.Visible = true;
lblMaxMarks.Visible = true;
label3.Visible = true;
label3.Text = "";
label3.Text = "Subjects in " + cbxclass.SelectedItem.ToString();
lblsubj.Text = "";
lblMinMarks.Text = "";
lblMaxMarks.Text = "";
for (int s = 0; s < dssub.Tables[0].Rows.Count; s++)
{
lblsubj.Text += dssub.Tables[0].Rows[s].ItemArray[0].ToString() + "\n";
lblMinMarks.Text += dssub.Tables[0].Rows[s].ItemArray[1].ToString() + "\n";
lblMaxMarks.Text += dssub.Tables[0].Rows[s].ItemArray[2].ToString() + "\n";
}
}
else
{
MessageBox.Show("Already Exists", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (c == 3)
{
if (txtsubject.Text != dssub1.Tables[0].Rows[0].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[1].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[2].ItemArray[0].ToString())
{
OleDbCommand cmd = new OleDbCommand("insert into Subject(ClassID,SubjectName,Medium,ExamID,MinMarks,MaxMarks) values(" + classid + ",'" + txtsubject.Text + "','" + medium + "'," + examid + ",'" + txtminmarks.Text + "','" + txtmaxmarks.Text + "')", cn);
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully Inserted", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
OleDbDataAdapter dasub = new OleDbDataAdapter("select SubjectName,MinMarks,MaxMarks from Subject where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamID=" + examid + " ", cn);
DataSet dssub = new DataSet();
dasub.Fill(dssub);
pnlsubject.Visible = true;
checkedListBox1.Visible = false;
lblsubj.Visible = true;
lblMinMarks.Visible = true;
lblMaxMarks.Visible = true;
label3.Visible = true;
label3.Text = "";
label3.Text = "Subjects in " + cbxclass.SelectedItem.ToString();
lblsubj.Text = "";
lblMinMarks.Text = "";
lblMaxMarks.Text = "";
for (int s = 0; s < dssub.Tables[0].Rows.Count; s++)
{
lblsubj.Text += dssub.Tables[0].Rows[s].ItemArray[0].ToString() + "\n";
lblMinMarks.Text += dssub.Tables[0].Rows[s].ItemArray[1].ToString() + "\n";
lblMaxMarks.Text += dssub.Tables[0].Rows[s].ItemArray[2].ToString() + "\n";
}
}
else
{
MessageBox.Show("Already Exists", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (c == 4)
{
if (txtsubject.Text != dssub1.Tables[0].Rows[0].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[1].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[2].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[3].ItemArray[0].ToString())
{
OleDbCommand cmd = new OleDbCommand("insert into Subject(ClassID,SubjectName,Medium,ExamID,MinMarks,MaxMarks) values(" + classid + ",'" + txtsubject.Text + "','" + medium + "'," + examid + ",'" + txtminmarks.Text + "','" + txtmaxmarks.Text + "')", cn);
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully Inserted", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
OleDbDataAdapter dasub = new OleDbDataAdapter("select SubjectName,MinMarks,MaxMarks from Subject where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamID=" + examid + " ", cn);
DataSet dssub = new DataSet();
dasub.Fill(dssub);
pnlsubject.Visible = true;
checkedListBox1.Visible = false;
lblsubj.Visible = true;
lblMinMarks.Visible = true;
lblMaxMarks.Visible = true;
label3.Visible = true;
label3.Text = "";
label3.Text = "Subjects in " + cbxclass.SelectedItem.ToString();
lblsubj.Text = "";
lblMinMarks.Text = "";
lblMaxMarks.Text = "";
for (int s = 0; s < dssub.Tables[0].Rows.Count; s++)
{
lblsubj.Text += dssub.Tables[0].Rows[s].ItemArray[0].ToString() + "\n";
lblMinMarks.Text += dssub.Tables[0].Rows[s].ItemArray[1].ToString() + "\n";
lblMaxMarks.Text += dssub.Tables[0].Rows[s].ItemArray[2].ToString() + "\n";
}
}
else
{
MessageBox.Show("Already Exists", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (c == 5)
{
if (txtsubject.Text != dssub1.Tables[0].Rows[0].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[1].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[2].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[3].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[4].ItemArray[0].ToString())
{
OleDbCommand cmd = new OleDbCommand("insert into Subject(ClassID,SubjectName,Medium,ExamID,MinMarks,MaxMarks) values(" + classid + ",'" + txtsubject.Text + "','" + medium + "'," + examid + ",'" + txtminmarks.Text + "','" + txtmaxmarks.Text + "')", cn);
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully Inserted", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
OleDbDataAdapter dasub = new OleDbDataAdapter("select SubjectName,MinMarks,MaxMarks from Subject where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamID=" + examid + " ", cn);
DataSet dssub = new DataSet();
dasub.Fill(dssub);
pnlsubject.Visible = true;
checkedListBox1.Visible = false;
lblsubj.Visible = true;
lblMinMarks.Visible = true;
lblMaxMarks.Visible = true;
label3.Visible = true;
label3.Text = "";
label3.Text = "Subjects in " + cbxclass.SelectedItem.ToString();
lblsubj.Text = "";
lblMinMarks.Text = "";
lblMaxMarks.Text = "";
for (int s = 0; s < dssub.Tables[0].Rows.Count; s++)
{
lblsubj.Text += dssub.Tables[0].Rows[s].ItemArray[0].ToString() + "\n";
lblMinMarks.Text += dssub.Tables[0].Rows[s].ItemArray[1].ToString() + "\n";
lblMaxMarks.Text += dssub.Tables[0].Rows[s].ItemArray[2].ToString() + "\n";
}
}
else
{
MessageBox.Show("Already Exists", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (c == 6)
{
if (txtsubject.Text != dssub1.Tables[0].Rows[0].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[1].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[2].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[3].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[4].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[5].ItemArray[0].ToString())
{
OleDbCommand cmd = new OleDbCommand("insert into Subject(ClassID,SubjectName,Medium,ExamID,MinMarks,MaxMarks) values(" + classid + ",'" + txtsubject.Text + "','" + medium + "'," + examid + ",'" + txtminmarks.Text + "','" + txtmaxmarks.Text + "')", cn);
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully Inserted", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
OleDbDataAdapter dasub = new OleDbDataAdapter("select SubjectName,MinMarks,MaxMarks from Subject where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamID=" + examid + " ", cn);
DataSet dssub = new DataSet();
dasub.Fill(dssub);
pnlsubject.Visible = true;
checkedListBox1.Visible = false;
lblsubj.Visible = true;
lblMinMarks.Visible = true;
lblMaxMarks.Visible = true;
label3.Visible = true;
label3.Text = "";
label3.Text = "Subjects in " + cbxclass.SelectedItem.ToString();
lblsubj.Text = "";
lblMinMarks.Text = "";
lblMaxMarks.Text = "";
for (int s = 0; s < dssub.Tables[0].Rows.Count; s++)
{
lblsubj.Text += dssub.Tables[0].Rows[s].ItemArray[0].ToString() + "\n";
lblMinMarks.Text += dssub.Tables[0].Rows[s].ItemArray[1].ToString() + "\n";
lblMaxMarks.Text += dssub.Tables[0].Rows[s].ItemArray[2].ToString() + "\n";
}
}
else
{
MessageBox.Show("Already Exists", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (c == 7)
{
if (txtsubject.Text != dssub1.Tables[0].Rows[0].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[1].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[2].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[3].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[4].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[5].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[6].ItemArray[0].ToString())
{
OleDbCommand cmd = new OleDbCommand("insert into Subject(ClassID,SubjectName,Medium,ExamID,MinMarks,MaxMarks) values(" + classid + ",'" + txtsubject.Text + "','" + medium + "'," + examid + ",'" + txtminmarks.Text + "','" + txtmaxmarks.Text + "')", cn);
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully Inserted", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
OleDbDataAdapter dasub = new OleDbDataAdapter("select SubjectName,MinMarks,MaxMarks from Subject where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamID=" + examid + " ", cn);
DataSet dssub = new DataSet();
dasub.Fill(dssub);
pnlsubject.Visible = true;
checkedListBox1.Visible = false;
lblsubj.Visible = true;
lblMinMarks.Visible = true;
lblMaxMarks.Visible = true;
label3.Visible = true;
label3.Text = "";
label3.Text = "Subjects in " + cbxclass.SelectedItem.ToString();
lblsubj.Text = "";
lblMinMarks.Text = "";
lblMaxMarks.Text = "";
lblMinMarks.Text = "";
lblMaxMarks.Text = "";
for (int s = 0; s < dssub.Tables[0].Rows.Count; s++)
{
lblsubj.Text += dssub.Tables[0].Rows[s].ItemArray[0].ToString() + "\n";
lblMinMarks.Text += dssub.Tables[0].Rows[s].ItemArray[1].ToString() + "\n";
lblMaxMarks.Text += dssub.Tables[0].Rows[s].ItemArray[2].ToString() + "\n";
}
}
else
{
MessageBox.Show("Already Exists", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (c == 8)
{
if (txtsubject.Text != dssub1.Tables[0].Rows[0].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[1].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[2].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[3].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[4].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[5].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[6].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[7].ItemArray[0].ToString())
{
OleDbCommand cmd = new OleDbCommand("insert into Subject(ClassID,SubjectName,Medium,ExamID,MinMarks,MaxMarks) values(" + classid + ",'" + txtsubject.Text + "','" + medium + "'," + examid + ",'" + txtminmarks.Text + "','" + txtmaxmarks.Text + "')", cn);
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully Inserted", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
OleDbDataAdapter dasub = new OleDbDataAdapter("select SubjectName,MinMarks,MaxMarks from Subject where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamID=" + examid + " ", cn);
DataSet dssub = new DataSet();
dasub.Fill(dssub);
pnlsubject.Visible = true;
checkedListBox1.Visible = false;
lblsubj.Visible = true;
lblMinMarks.Visible = true;
lblMaxMarks.Visible = true;
label3.Visible = true;
label3.Text = "";
label3.Text = "Subjects in " + cbxclass.SelectedItem.ToString();
lblsubj.Text = "";
lblMinMarks.Text = "";
lblMaxMarks.Text = "";
for (int s = 0; s < dssub.Tables[0].Rows.Count; s++)
{
lblsubj.Text += dssub.Tables[0].Rows[s].ItemArray[0].ToString() + "\n";
lblMinMarks.Text += dssub.Tables[0].Rows[s].ItemArray[1].ToString() + "\n";
lblMaxMarks.Text += dssub.Tables[0].Rows[s].ItemArray[2].ToString() + "\n";
}
}
else
{
MessageBox.Show("Already Exists", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (c == 9)
{
if (txtsubject.Text != dssub1.Tables[0].Rows[0].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[1].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[2].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[3].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[4].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[5].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[6].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[7].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[8].ItemArray[0].ToString())
{
OleDbCommand cmd = new OleDbCommand("insert into Subject(ClassID,SubjectName,Medium,ExamID,MinMarks,MaxMarks) values(" + classid + ",'" + txtsubject.Text + "','" + medium + "'," + examid + ",'" + txtminmarks.Text + "','" + txtmaxmarks.Text + "')", cn);
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully Inserted", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
OleDbDataAdapter dasub = new OleDbDataAdapter("select SubjectName,MinMarks,MaxMarks from Subject where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamID=" + examid + " ", cn);
DataSet dssub = new DataSet();
dasub.Fill(dssub);
pnlsubject.Visible = true;
checkedListBox1.Visible = false;
lblsubj.Visible = true;
lblMinMarks.Visible = true;
lblMaxMarks.Visible = true;
label3.Visible = true;
label3.Text = "";
label3.Text = "Subjects in " + cbxclass.SelectedItem.ToString();
lblsubj.Text = "";
lblMinMarks.Text = "";
lblMaxMarks.Text = "";
for (int s = 0; s < dssub.Tables[0].Rows.Count; s++)
{
lblsubj.Text += dssub.Tables[0].Rows[s].ItemArray[0].ToString() + "\n";
lblMinMarks.Text += dssub.Tables[0].Rows[s].ItemArray[1].ToString() + "\n";
lblMaxMarks.Text += dssub.Tables[0].Rows[s].ItemArray[2].ToString() + "\n";
}
}
else
{
MessageBox.Show("Already Exists", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (c == 10)
{
if (txtsubject.Text != dssub1.Tables[0].Rows[0].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[1].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[2].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[3].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[4].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[5].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[6].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[7].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[8].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[9].ItemArray[0].ToString())
{
OleDbCommand cmd = new OleDbCommand("insert into Subject(ClassID,SubjectName,Medium,ExamID,MinMarks,MaxMarks) values(" + classid + ",'" + txtsubject.Text + "','" + medium + "'," + examid + ",'" + txtminmarks.Text + "','" + txtmaxmarks.Text + "')", cn);
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully Inserted", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
OleDbDataAdapter dasub = new OleDbDataAdapter("select SubjectName,MinMarks,MaxMarks from Subject where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamID=" + examid + " ", cn);
DataSet dssub = new DataSet();
dasub.Fill(dssub);
pnlsubject.Visible = true;
checkedListBox1.Visible = false;
lblsubj.Visible = true;
lblMinMarks.Visible = true;
lblMaxMarks.Visible = true;
label3.Visible = true;
label3.Text = "";
label3.Text = "Subjects in " + cbxclass.SelectedItem.ToString();
lblsubj.Text = "";
lblMinMarks.Text = "";
lblMaxMarks.Text = "";
for (int s = 0; s < dssub.Tables[0].Rows.Count; s++)
{
lblsubj.Text += dssub.Tables[0].Rows[s].ItemArray[0].ToString() + "\n";
lblMinMarks.Text += dssub.Tables[0].Rows[s].ItemArray[1].ToString() + "\n";
lblMaxMarks.Text += dssub.Tables[0].Rows[s].ItemArray[2].ToString() + "\n";
}
}
else
{
MessageBox.Show("Already Exists", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (c == 11)
{
if (txtsubject.Text != dssub1.Tables[0].Rows[0].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[1].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[2].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[3].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[4].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[5].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[6].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[7].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[8].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[9].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[10].ItemArray[0].ToString())
{
OleDbCommand cmd = new OleDbCommand("insert into Subject(ClassID,SubjectName,Medium,ExamID,MinMarks,MaxMarks) values(" + classid + ",'" + txtsubject.Text + "','" + medium + "'," + examid + ",'" + txtminmarks.Text + "','" + txtmaxmarks.Text + "')", cn);
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully Inserted", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
OleDbDataAdapter dasub = new OleDbDataAdapter("select SubjectName,MinMarks,MaxMarks from Subject where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamID=" + examid + " ", cn);
DataSet dssub = new DataSet();
dasub.Fill(dssub);
pnlsubject.Visible = true;
checkedListBox1.Visible = false;
lblsubj.Visible = true;
lblMinMarks.Visible = true;
lblMaxMarks.Visible = true;
label3.Visible = true;
label3.Text = "";
label3.Text = "Subjects in " + cbxclass.SelectedItem.ToString();
lblsubj.Text = "";
lblMinMarks.Text = "";
lblMaxMarks.Text = "";
for (int s = 0; s < dssub.Tables[0].Rows.Count; s++)
{
lblsubj.Text += dssub.Tables[0].Rows[s].ItemArray[0].ToString() + "\n";
lblMinMarks.Text += dssub.Tables[0].Rows[s].ItemArray[1].ToString() + "\n";
lblMaxMarks.Text += dssub.Tables[0].Rows[s].ItemArray[2].ToString() + "\n";
}
}
else
{
MessageBox.Show("Already Exists", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (c == 12)
{
if (txtsubject.Text != dssub1.Tables[0].Rows[0].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[1].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[2].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[3].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[4].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[5].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[6].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[7].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[8].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[9].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[10].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[11].ItemArray[0].ToString())
{
OleDbCommand cmd = new OleDbCommand("insert into Subject(ClassID,SubjectName,Medium,ExamID,MinMarks,MaxMarks) values(" + classid + ",'" + txtsubject.Text + "','" + medium + "'," + examid + ",'" + txtminmarks.Text + "','" + txtmaxmarks.Text + "')", cn);
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully Inserted", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
OleDbDataAdapter dasub = new OleDbDataAdapter("select SubjectName,MinMarks,MaxMarks from Subject where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamID=" + examid + " ", cn);
DataSet dssub = new DataSet();
dasub.Fill(dssub);
pnlsubject.Visible = true;
checkedListBox1.Visible = false;
lblsubj.Visible = true;
lblMinMarks.Visible = true;
lblMaxMarks.Visible = true;
label3.Visible = true;
label3.Text = "";
label3.Text = "Subjects in " + cbxclass.SelectedItem.ToString();
lblsubj.Text = "";
lblMinMarks.Text = "";
lblMaxMarks.Text = "";
for (int s = 0; s < dssub.Tables[0].Rows.Count; s++)
{
lblsubj.Text += dssub.Tables[0].Rows[s].ItemArray[0].ToString() + "\n";
lblMinMarks.Text += dssub.Tables[0].Rows[s].ItemArray[1].ToString() + "\n";
lblMaxMarks.Text += dssub.Tables[0].Rows[s].ItemArray[2].ToString() + "\n";
}
}
else
{
MessageBox.Show("Already Exists", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (c == 13)
{
if (txtsubject.Text != dssub1.Tables[0].Rows[0].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[1].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[2].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[3].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[4].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[5].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[6].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[7].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[8].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[9].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[10].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[11].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[12].ItemArray[0].ToString())
{
OleDbCommand cmd = new OleDbCommand("insert into Subject(ClassID,SubjectName,Medium,ExamID,MinMarks,MaxMarks) values(" + classid + ",'" + txtsubject.Text + "','" + medium + "'," + examid + ",'" + txtminmarks.Text + "','" + txtmaxmarks.Text + "')", cn);
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully Inserted", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
OleDbDataAdapter dasub = new OleDbDataAdapter("select SubjectName,MinMarks,MaxMarks from Subject where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamID=" + examid + " ", cn);
DataSet dssub = new DataSet();
dasub.Fill(dssub);
pnlsubject.Visible = true;
checkedListBox1.Visible = false;
lblsubj.Visible = true;
lblMinMarks.Visible = true;
lblMaxMarks.Visible = true;
label3.Visible = true;
label3.Text = "";
label3.Text = "Subjects in " + cbxclass.SelectedItem.ToString();
lblsubj.Text = "";
lblMinMarks.Text = "";
lblMaxMarks.Text = "";
for (int s = 0; s < dssub.Tables[0].Rows.Count; s++)
{
lblsubj.Text += dssub.Tables[0].Rows[s].ItemArray[0].ToString() + "\n";
lblMinMarks.Text += dssub.Tables[0].Rows[s].ItemArray[1].ToString() + "\n";
lblMaxMarks.Text += dssub.Tables[0].Rows[s].ItemArray[2].ToString() + "\n";
}
}
else
{
MessageBox.Show("Already Exists", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (c == 14)
{
if (txtsubject.Text != dssub1.Tables[0].Rows[0].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[1].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[2].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[3].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[4].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[5].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[6].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[7].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[8].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[9].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[10].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[11].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[12].ItemArray[0].ToString() && txtsubject.Text != dssub1.Tables[0].Rows[13].ItemArray[0].ToString())
{
OleDbCommand cmd = new OleDbCommand("insert into Subject(ClassID,SubjectName,Medium,ExamID,MinMarks,MaxMarks) values(" + classid + ",'" + txtsubject.Text + "','" + medium + "'," + examid + ",'" + txtminmarks.Text + "','" + txtmaxmarks.Text + "')", cn);
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully Inserted", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
OleDbDataAdapter dasub = new OleDbDataAdapter("select SubjectName,MinMarks,MaxMarks from Subject where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamID=" + examid + " ", cn);
DataSet dssub = new DataSet();
dasub.Fill(dssub);
pnlsubject.Visible = true;
checkedListBox1.Visible = false;
lblsubj.Visible = true;
lblMinMarks.Visible = true;
lblMaxMarks.Visible = true;
label3.Visible = true;
label3.Text = "";
label3.Text = "Subjects in " + cbxclass.SelectedItem.ToString();
lblsubj.Text = "";
lblMinMarks.Text = "";
lblMaxMarks.Text = "";
for (int s = 0; s < dssub.Tables[0].Rows.Count; s++)
{
lblsubj.Text += dssub.Tables[0].Rows[s].ItemArray[0].ToString() + "\n";
lblMinMarks.Text += dssub.Tables[0].Rows[s].ItemArray[1].ToString() + "\n";
lblMaxMarks.Text += dssub.Tables[0].Rows[s].ItemArray[2].ToString() + "\n";
}
}
else
{
MessageBox.Show("Already Exists", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
else
{
MessageBox.Show("15 Subjects Only");
txtsubject.Enabled = false;
}
}
txtsubject.Text = "";
txtminmarks.Text = "";
txtmaxmarks.Text = "";
txtsubject.Focus();
cn.Close();
}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message, "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnclose_Click(object sender, EventArgs e)
{
this.Close();
}
private void cbxclass_SelectedIndexChanged(object sender, EventArgs e)
{
data();
checkedListBox1.Visible = false;
btndel.Visible = false;
btnupdate.Visible = false;
btnmodify.Enabled = true;
btndelete.Enabled = true;
txtsubject.Enabled = true;
if (cbxmedium.SelectedIndex != -1 && cbxclass.SelectedIndex != 0 && cbxclass.SelectedIndex != -1)
{
OleDbDataAdapter daclass = new OleDbDataAdapter("select ClassID from Class where ClassName='" + cbxclass.SelectedItem.ToString() + "'and Medium='" + cbxmedium.SelectedItem.ToString() + "'", cn);
DataSet dsclass = new DataSet();
daclass.Fill(dsclass);
int classid = Convert.ToInt32(dsclass.Tables[0].Rows[0].ItemArray[0]);
cbxExam.Items.Clear();
OleDbDataAdapter dasub = new OleDbDataAdapter("select ExamName from Exam where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "'", cn);
DataSet dssub = new DataSet();
dasub.Fill(dssub);
cbxExam.Items.Add("--Select--");
for (int i = 0; i < dssub.Tables[0].Rows.Count; i++)
{
cbxExam.Items.Add(dssub.Tables[0].Rows[i].ItemArray[0].ToString());
}
cbxExam.SelectedIndex = 0;
}
}
private void cbxExam_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbxmedium.SelectedIndex != -1 && cbxclass.SelectedIndex != 0 && cbxclass.SelectedIndex != -1 && cbxExam.SelectedIndex != -1&& cbxExam.SelectedIndex!=0)
{
OleDbDataAdapter daclass = new OleDbDataAdapter("select ClassID from Class where ClassName='" + cbxclass.SelectedItem.ToString() + "'and Medium='" + cbxmedium.SelectedItem.ToString() + "'", cn);
DataSet dsclass = new DataSet();
daclass.Fill(dsclass);
int classid = Convert.ToInt32(dsclass.Tables[0].Rows[0].ItemArray[0]);
OleDbDataAdapter daexam = new OleDbDataAdapter("select ExamID from Exam where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamName='"+cbxExam.SelectedItem.ToString()+"' ", cn);
DataSet dsexam = new DataSet();
daexam.Fill(dsexam);
int examid = Convert.ToInt32(dsexam.Tables[0].Rows[0].ItemArray[0]);
OleDbDataAdapter dasub = new OleDbDataAdapter("select SubjectName,MinMarks,MaxMarks from Subject where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamID=" + examid + " ", cn);
DataSet dssub = new DataSet();
dasub.Fill(dssub);
if (dssub.Tables[0].Rows.Count != 0)
{
pnlsubject.Visible = true;
lblsubj.Visible = true;
lblMinMarks.Visible = true;
lblMaxMarks.Visible = true;
label3.Visible = true;
label3.Text = "";
label3.Text = "Subjects in " + cbxclass.SelectedItem.ToString();
lblsubj.Text = "";
lblMinMarks.Text = "";
lblMaxMarks.Text = "";
for (int s = 0; s < dssub.Tables[0].Rows.Count; s++)
{
lblsubj.Text += dssub.Tables[0].Rows[s].ItemArray[0].ToString() + "\n";
lblMinMarks.Text += dssub.Tables[0].Rows[s].ItemArray[1].ToString() + "\n";
lblMaxMarks.Text += dssub.Tables[0].Rows[s].ItemArray[2].ToString() + "\n";
}
}
else
{
pnlsubject.Visible = false;
label3.Visible = false;
}
}
}
private void cbxmedium_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbxmedium.SelectedIndex != -1)
{
cbxclass.Items.Clear();
label3.Visible = false;
lblsubj.Text = "";
lblMinMarks.Text = "";
lblMaxMarks.Text = "";
OleDbDataAdapter daclass = new OleDbDataAdapter("select ClassName from Class where Medium='" + cbxmedium.SelectedItem.ToString() + "'", cn);
DataSet dsclass = new DataSet();
daclass.Fill(dsclass);
cbxclass.Items.Add("--Select--");
for (int i = 0; i < dsclass.Tables[0].Rows.Count; i++)
{
cbxclass.Items.Add(dsclass.Tables[0].Rows[i].ItemArray[0].ToString());
}
cbxclass.SelectedIndex = 0;
data();
checkedListBox1.Visible = false;
btndel.Visible = false;
btnupdate.Visible = false;
btnmodify.Enabled = true;
btndelete.Enabled = true;
txtsubject.Enabled = true;
}
}
private void btndelete_Click(object sender, EventArgs e)
{
txtminmarks.Text = "";
txtmaxmarks.Text = "";
txtsubject.Text = "";
if (cbxmedium.SelectedIndex == -1||cbxmedium.SelectedIndex ==0)
{
MessageBox.Show("Select Medium", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
cbxmedium.Focus();
}
else if (cbxclass.SelectedIndex == 0)
{
MessageBox.Show("Select Class", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
cbxclass.Focus();
}
else if (cbxExam.SelectedIndex == 0)
{
MessageBox.Show("Select Exam", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
cbxExam.Focus();
}
else
{
label3.Text = "";
label3.Text = "Deletion of Subjects in " + cbxclass.SelectedItem.ToString();
lblsubj.Visible = false;
lblMinMarks.Visible = false;
lblMaxMarks.Visible = false;
data();
btnupdate.Visible = false;
btndelete.Enabled = false;
btnmodify.Enabled = false;
OleDbDataAdapter daclass = new OleDbDataAdapter("select ClassID from Class where ClassName='" + cbxclass.SelectedItem.ToString() + "'and Medium='" + cbxmedium.SelectedItem.ToString() + "'", cn);
DataSet dsclass = new DataSet();
daclass.Fill(dsclass);
int classid = Convert.ToInt32(dsclass.Tables[0].Rows[0].ItemArray[0]);
OleDbDataAdapter daexam = new OleDbDataAdapter("select ExamID from Exam where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamName='" + cbxExam.SelectedItem.ToString() + "' ", cn);
DataSet dsexam = new DataSet();
daexam.Fill(dsexam);
int examid = Convert.ToInt32(dsexam.Tables[0].Rows[0].ItemArray[0]);
OleDbDataAdapter dasub = new OleDbDataAdapter("select SubjectName from Subject where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamID=" + examid + " ", cn);
DataSet dssub = new DataSet();
dasub.Fill(dssub);
if (dssub.Tables[0].Rows.Count != 0)
{
checkedListBox1.Visible = true;
checkedListBox1.Items.Clear();
for (int s = 0; s < dssub.Tables[0].Rows.Count; s++)
{
checkedListBox1.Items.Add(dssub.Tables[0].Rows[s].ItemArray[0].ToString());
btndel.Visible = true;
}
}
else
{
MessageBox.Show("No Records", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtsubject.Focus();
}
}
}
private void btndel_Click(object sender, EventArgs e)
{
data();
cn.Open();
if (checkedListBox1.CheckedItems.Count != 0)
{
OleDbDataAdapter daclass = new OleDbDataAdapter("select ClassID from Class where ClassName='" + cbxclass.SelectedItem.ToString() + "'and Medium='" + cbxmedium.SelectedItem.ToString() + "'", cn);
DataSet dsclass = new DataSet();
daclass.Fill(dsclass);
int classid = Convert.ToInt32(dsclass.Tables[0].Rows[0].ItemArray[0]);
OleDbDataAdapter daexam = new OleDbDataAdapter("select ExamID from Exam where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamName='" + cbxExam.SelectedItem.ToString() + "' ", cn);
DataSet dsexam = new DataSet();
daexam.Fill(dsexam);
int examid = Convert.ToInt32(dsexam.Tables[0].Rows[0].ItemArray[0]);
for (int i = 0; i < checkedListBox1.CheckedItems.Count; i++)
{
OleDbCommand cmd = new OleDbCommand("Delete from Subject where SubjectName='" + checkedListBox1.CheckedItems[i].ToString() + "' and ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamID=" + examid + " ", cn);
cmd.ExecuteNonQuery();
}
checkedListBox1.Visible = false;
btndel.Visible = false;
btndelete.Enabled = true;
btnmodify.Enabled = true;
btnmodify.Visible = true;
txtsubject.Enabled = true;
MessageBox.Show("Sucessfully Deleted", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
OleDbDataAdapter dasub = new OleDbDataAdapter("select SubjectName,MinMarks,MaxMarks from Subject where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamID=" + examid + " ", cn);
DataSet dssub = new DataSet();
dasub.Fill(dssub);
if (dssub.Tables[0].Rows.Count != 0)
{
pnlsubject.Visible = true;
lblsubj.Visible = true;
lblMinMarks.Visible = true;
lblMaxMarks.Visible = true;
label3.Visible = true;
label3.Text = "";
label3.Text = "Subjects in " + cbxclass.SelectedItem.ToString();
lblsubj.Text = "";
lblMinMarks.Text = "";
lblMaxMarks.Text = "";
for (int s = 0; s < dssub.Tables[0].Rows.Count; s++)
{
lblsubj.Text += dssub.Tables[0].Rows[s].ItemArray[0].ToString() + "\n";
lblMinMarks.Text += dssub.Tables[0].Rows[s].ItemArray[1].ToString() + "\n";
lblMaxMarks.Text += dssub.Tables[0].Rows[s].ItemArray[2].ToString() + "\n";
}
}
else
{
pnlsubject.Visible = false;
label3.Visible = false;
}
}
else
{
MessageBox.Show("Select Any Subject", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
cn.Close();
}
private void txtsubject_Leave(object sender, EventArgs e)
{
txtsubject.Text = ConnectionStringForSMS.Capitalize(txtsubject.Text);
}
private void textBox1_Leave(object sender, EventArgs e)
{
textBox1.Text = ConnectionStringForSMS.Capitalize(textBox1.Text);
OleDbDataAdapter daclass = new OleDbDataAdapter("select ClassID from Class where ClassName='" + cbxclass.SelectedItem.ToString() + "'and Medium='" + cbxmedium.SelectedItem.ToString() + "'", cn);
DataSet dsclass = new DataSet();
daclass.Fill(dsclass);
int classid = Convert.ToInt32(dsclass.Tables[0].Rows[0].ItemArray[0]);
OleDbDataAdapter daexam = new OleDbDataAdapter("select ExamID from Exam where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and ExamName='" + cbxExam.SelectedItem.ToString() + "' ", cn);
DataSet dsexam = new DataSet();
daexam.Fill(dsexam);
int examid = Convert.ToInt32(dsexam.Tables[0].Rows[0].ItemArray[0]);
OleDbDataAdapter dasub = new OleDbDataAdapter("select SubjectName from Subject where ClassID=" + classid + " and Medium='" + cbxmedium.SelectedItem.ToString() + "' and SubjectName='"+textBox1.Text+"' and ExamID="+examid+" ", cn);
DataSet dssub = new DataSet();
dasub.Fill(dssub);
if (dssub.Tables[0].Rows.Count !=