private void cbCategory_SelectedIndexChanged(object sender, EventArgs e)
 {
     try
     {
         SubCategoryRepository r1 = new SubCategoryRepository();
         DataSet result           = r1.ListForCategory((int)cbCategory.SelectedValue);
         cbSubCategory.DataSource    = result.Tables[0];
         cbSubCategory.DisplayMember = "SubCategoryName";
         cbSubCategory.ValueMember   = "Id";
     }
     catch (Exception)
     {
     }
 }