private void studentDetails_Load(object sender, EventArgs e)
{
//DataTable table = new DataTable();
comboBox1.DataSource = sd.tableData("select * from studentDetails");
comboBox1.DisplayMember = "registrationNo";
comboBox1.ValueMember = "registrationNo";
}
private void button2_Click(object sender, EventArgs e)
{
try
{
updatingClass cp = new updatingClass();
string query = "update employeeData set firstName='" + textBox1.Text + "', lastName = '" + textBox2.Text + "',phone = '" + textBox3.Text + "',email = '" + textBox4.Text + "',address = '" + richTextBox1.Text + "' where ID=" + textBox5.Text;
cp.update(query);
dataGridView1.DataSource = sd.tableData("select ID,firstName,lastName,phone,email,address from employeeData");
}
catch (FormatException)
{
MessageBox.Show("Insert All Values!!");
}
}
private void studentFeeCollection_Load(object sender, EventArgs e)
{
textBox1.Enabled = false;
dataGridView1.DataSource = sd.tableData("select * from studentFees");
rl = new radioLoad();
comboBox3.DataSource = rl.mydt("select * from monthNames");
comboBox3.DisplayMember = "title";
comboBox3.ValueMember = "ID";
comboBox1.DataSource = rl.mydt("select * from studentDetails");
comboBox1.DisplayMember = "registrationNo";
comboBox1.ValueMember = "registrationNo";
}
private void feesAmounts_Load(object sender, EventArgs e)
{
comboBox1.DataSource = sd.tableData("select * from monthNames");
comboBox1.DisplayMember = "title";
comboBox1.ValueMember = "ID";
label2.Text = "0";
label3.Text = "0";
label4.Text = "0";
label9.Text = "0";
label8.Text = "0";
label7.Text = "0";
}
private void salariesGiven_Load(object sender, EventArgs e)
{
comboBox1.DataSource = sd.tableData("select * from monthNames");
comboBox1.DisplayMember = "title";
comboBox1.ValueMember = "ID";
label14.Text = "0";
label2.Text = "0";
label5.Text = "0";
label4.Text = "0";
label3.Text = "0";
label6.Text = "0";
}
private void employeeInformation_Load(object sender, EventArgs e)
{
dataGridView1.DataSource = sd.tableData("select * from employeeData");
}
private void updateFaculty_Load(object sender, EventArgs e)
{
dataGridView1.DataSource = sd.tableData("select facultyID,fistName,lastName,phone,email,address from facultyData");
}
