public List <BusinessObjects.Category_BS> GetCategory(string connString)
{
try
{
List <BusinessObjects.Category_BS> CatetList = new List <BusinessObjects.Category_BS>();
string query = "select ID,name from _Category";
SqlConnection conn = DBHelper.GetConnection(connString);
conn.Open();
SqlDataReader reader = DBHelper.ReadData(query, conn);
while (reader.Read())
{
BusinessObjects.Category_BS pObj = new BusinessObjects.Category_BS();
pObj.ID = Convert.ToInt32(reader[0].ToString());
pObj.name = reader[1].ToString();
CatetList.Add(pObj);
}
conn.Close();
return(CatetList);
}
catch (Exception ex)
{
throw ex;
}
}
private void loadCombo()
{
try
{
cmbCategory.DataSource = null;
BusinessObjects.Category_BS CBS = new BusinessObjects.Category_BS();
List <BusinessObjects.Category_BS> CList = new List <BusinessObjects.Category_BS>();
CList = CBS.GetCategory(con);
cmbCategory.DataSource = CList;
cmbCategory.DisplayMember = "name";
cmbCategory.ValueMember = "ID";
}
catch (Exception ex)
{
MetroMessageBox.Show(this, "! System Error. " + ex.Message, "System Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
