public void FillCategoryCombo()
{
try
{
con.Open();
cmd.CommandText = "select * from tblCategory";
cmd.Connection = con;
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
// catid = Convert.ToInt32(dr["CatID"].ToString());
cmbFoodCategory.Items.Add(dr["CatName"]);
}
con.Close();
dr.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}Following Method Shows how to Load Items in ComboBox using DataReader Class.
