void LoadCategoryGroup(DropDownList ddl) { Category cat = new Category(); ddl.Items.Clear(); DataTable dt1 = cat.SelectCategoryGroup(); ListItem listItem = new ListItem(); listItem.Text = "<Select Category Group>"; listItem.Value = "0"; //listItem.Attributes.Add("style", "background-Black:white;color:White"); ddl.Items.Add(listItem); for (int i = 0; i < dt1.Rows.Count; i++) { listItem = new ListItem(); listItem.Text = dt1.Rows[i]["CategoryGroupName"].ToString(); listItem.Value = dt1.Rows[i]["CategoryGroupId"].ToString(); //listItem.Attributes.Add("style", "background-color:Black;color:white"); ddl.Items.Add(listItem); } }
void LoadCategory() { objCategory = new Category(); dt = objCategory.SelectCategoryGroup(); if (dt.Rows.Count > PageSize) tblPaging.Visible = true; else tblPaging.Visible = false; if (dt.Rows.Count > 0) { if (tblPaging.Visible == true) { // Setting viewstate for TotalRecords LabelTotalRecords.Text = dt.Rows.Count.ToString(); // Setting viewstate for TotalPages if (int.Parse(LabelTotalRecords.Text) % PageSize > 0) // If page size is not exactly divisible by total records ViewState["TotalPages"] = int.Parse(LabelTotalRecords.Text) / PageSize; else // If page is exactly divisible by total records ViewState["TotalPages"] = int.Parse(LabelTotalRecords.Text) / PageSize - 1; ViewState["dataTable"] = dt; if (!object.Equals(dt, null)) { BindList(ManagePaging(dt)); } } else { DataList1.DataSource = dt; DataList1.DataBind(); } } else PagingRow.Visible = false; }