private void LoadCategory()
{
string conStr = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
SqlConnection conn = new SqlConnection(conStr);
string query = "select Category_ID, Category_Name from ProductCategory";
SqlCommand cmd = new SqlCommand(query, conn);
try
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
DropDownListProductCategory.DataTextField = "Category_Name";
DropDownListProductCategory.DataValueField = "Category_ID";
DropDownListProductCategory.DataSource = reader;
DropDownListProductCategory.DataBind();
}
catch (Exception exc)
{
Response.Write(exc.ToString());
}
finally
{
conn.Close();
}
}
public void LoadProductCategory()
{
List <ProductCategory> aProductCategories = aProductCategoryManager.LoadProductCategories();
DropDownListProductCategory.DataSource = aProductCategories;
DropDownListProductCategory.DataValueField = "ProductCategoryName";
DropDownListProductCategory.DataTextField = "ProductCategoryName";
DropDownListProductCategory.DataBind();
}