private async Task XfillComboboxes()
{
Sqlcmd.Parameters.Clear();
await Conopen();
Strsql = "Select * from tbl_course";
Sqlcmd.CommandText = Strsql;
Sqlcmd.Connection = Cnn;
Sqladapter.SelectCommand = Sqlcmd;
Sqlreader = await Sqlcmd.ExecuteReaderAsync();
course.Items.Clear();
while (Sqlreader.Read())
{
course.Items.Add(Sqlreader.GetValue(1));
}
Sqlcmd.Dispose();
Sqlreader.Close();
Cnn.Close();
Strsql = "";
//retrieve year level
Sqlcmd.Parameters.Clear();
await Conopen();
Strsql = "Select * from tbl_yearLevel";
Sqlcmd.CommandText = Strsql;
Sqlcmd.Connection = Cnn;
Sqladapter.SelectCommand = Sqlcmd;
Sqlreader = await Sqlcmd.ExecuteReaderAsync();
yrlevel.Items.Clear();
while (Sqlreader.Read())
{
yrlevel.Items.Add(Sqlreader.GetValue(0));
}
Sqlcmd.Dispose();
Sqlreader.Close();
Cnn.Close();
Strsql = "";
//retrieve voter's category
Sqlcmd.Parameters.Clear();
await Conopen();
Strsql = "Select * from tbl_Vtrs_Category";
Sqlcmd.CommandText = Strsql;
Sqlcmd.Connection = Cnn;
Sqladapter.SelectCommand = Sqlcmd;
Sqlreader = await Sqlcmd.ExecuteReaderAsync();
vtCategory.Items.Clear();
while (Sqlreader.Read())
{
vtCategory.Items.Add(Sqlreader.GetValue(1));
}
Sqlcmd.Dispose();
Sqlreader.Close();
Cnn.Close();
Strsql = "";
}