protected void cmbBrand_SelectedIndexChanged(object sender, EventArgs e)
{
SqlDataSourceProduct.SelectCommand = "select ProdCode as VehicleCode,VersionCode as[Version],ProdDesc as [Description],ColorCode,Color from vehicle where DealerCode IN ('AAAAA','" + Session["DealerCode"].ToString() + "') and BrandCode='" + cmbBrand.Value + "'";
SqlDataSourceProduct.Select(DataSourceSelectArguments.Empty);
SqlDataSourceProduct.DataBind();
cmbProdCode.DataBind();
cmbProdCode.Text = "";
// txtProdDesc.Text = myFunc.getProductDesc(cmbBrand.Text);
//loading prod combo
//if (cmbBrand.Value == "0")
//{
// cmbProdCode.Items.Clear();
// cmbProdCode.Text = "";
// txtProdDesc.Text = "";
// return;
//}
//string sql = "select ProdCode as VehicleCode,VersionCode as[Version],ProdDesc as [Description],ColorCode,Color from vehicle where DealerCode IN ('AAAAA','"+Session["DealerCode"].ToString()+"') and BrandCode='"+cmbBrand.Value+"'";
//DataTable dt = myFunc.GetData(sql);
//cmbProdCode.Items.Clear();
//if (dt.Rows.Count == 0)
//{
// return;
//}
////Adding top item
//ListEditItem itm = new ListEditItem();
//itm.Value = "0";
//itm.Text = "--Select--";
//cmbProdCode.Items.Add(itm);
//cmbProdCode.SelectedIndex = 0;
//// Add ItemsItems
//for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
//{
// ListEditItem itms = new ListEditItem();
// itms.Value = dt.Rows[i]["VehicleCode"].ToString();
// itm.Text = dt.Rows[i]["Description"].ToString();
// cmbProdCode.Items.Add(itm);
//}
}
protected void items()
{
PagedDataSource objDs = new PagedDataSource();
DataView dv = (DataView)SqlDataSourceProduct.Select(DataSourceSelectArguments.Empty);
objDs.DataSource = dv;
objDs.AllowPaging = true;
objDs.PageSize = 5;
objDs.CurrentPageIndex = CurrentPage;
lblCurrentPage.Text = "Page : " + (CurrentPage + 1).ToString() + "of" + objDs.PageCount.ToString();
ButtonPrev.Enabled = !objDs.IsFirstPage;
ButtonNext.Enabled = !objDs.IsLastPage;
DataListProduct.DataSourceID = null; //Disabled because error happens when loading pages
DataListProduct.DataSource = objDs;
DataListProduct.DataBind();
}
