protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//CsProvince ProvinceList = new CsProvincelist(ProvinceTable);
CsItemCat ItemCat = new CsItemCat(CategoryTable);
try
{
ConnectionClass.GetItemCat(ItemCat);
CategoryList.DataSource = ItemCat.itemCategory;
CategoryList.DataTextField = ItemCat.itemCategory.Columns["categoryName"].ToString();
CategoryList.DataValueField = ItemCat.itemCategory.Columns["categoryCode"].ToString();
CategoryList.DataBind();
}
finally
{
}
for (int i = 0; i <= 100; i++)
{
qtyList.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
}
}
// Press UpdateButton
protected void btnUpdate_Click(object sender, EventArgs e)
{
//Enable to use textbox, dropdownlist, enable to see upload control
AbleTextBoxes(Page);
//Enable to see upload button
btnUpload.Visible = true;
// Input qty list numbers
qtyList.SelectedItem.Text = "Please Select";
for (int i = 1; i <= 100; i++)
{
qtyList.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
// Input category list items
CategoryList.SelectedItem.Text = "Please Select";
CsItemCat Itemcats = new CsItemCat(CategoryTable);
ConnectionClass.GetItemCat(Itemcats);
CategoryList.DataSource = Itemcats.itemCategory;
CategoryList.DataTextField = Itemcats.itemCategory.Columns["categoryName"].ToString();
CategoryList.DataValueField = Itemcats.itemCategory.Columns["categoryName"].ToString();
CategoryList.DataBind();
btnUpdate.Visible = false;
btnSave.Visible = true;
}
public static void GetItemCat(CsItemCat itemcat)
{
string bQuery = string.Format(@"SELECT * FROM tblCategory;");
cmdString = new SqlCommand(bQuery, cntString);
try
{
cntString.Open();
SqlDataAdapter da = new SqlDataAdapter(cmdString);
//DataTable dt = new DataTable();
DataSet ds = new DataSet();
da.Fill(ds);
itemcat.itemCategory = ds.Tables[0];
}
finally
{
cntString.Close();
}
}