private void Student_Details_Load(object sender, EventArgs e)
{
string cmd = "Select Person.Id, Student.RegistrationNo,Person.FirstName,Person.LastName,Person.Contact,Person.Email,Person.Gender as g,Person.DateOfBirth from Person join Student on Student.Id = Person.Id";
dbConnection.getInstance().fill(cmd, dataGridView1);
Advisor ad = new Advisor();
ad.fillgender(dataGridView1);
}
private void AllAdvisors_Load(object sender, EventArgs e)
{
tableLayoutPanel1.Visible = false;
panel2.Visible = false;
string s = "Select a.Id, p.Gender as g, p.FirstName,p.LastName,p.Contact,p.Email,a.Salary,a.Designation,p.DateOfBirth from Advisor as a join Person as p on p.Id = a.Id ";
dbConnection.getInstance().fill(s, dataGridView1);
Advisor ad = new Advisor();
ad.fillgender(dataGridView1);
string f = "Select Value from Lookup where Category = 'DESIGNATION'";
ad.load(f, comboBox1);
}