private void LoadDepartment()
{
var dt = new DataTable();
var conn = new SqlConnection(connectionString);
var cmd = new SqlCommand("SELECT deptcode FROM tbldepartment",conn);
var da = new SqlDataAdapter(cmd);
dt.Clear();
da.fill(dt);
for(DataRow item in dt.Rows)
{
cbodept.Items.Add(item[0].ToString());
}
}
private void LoadCourse()
{
var dt = new DataTable();
var conn = new SqlConnection(connectionString);
var cmd = new SqlCommand("SELECT coursecode FROM tblcourse WHERE department='"+cbodept.Text+"'",conn);
var da = new SqlDataAdapter(cmd);
dt.Clear();
da.fill(dt);
for(DataRow item in dt.Rows)
{
cbocourse.Items.Add(item[0].ToString());
}
}
private void cbodept_SelectedIndexChanged(object sender, EventArgs e)
{
loadCourse();
}