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"); }