//Bind product
private void BindProduct(string search = "")
{
this.Form.DefaultButton = imgbtnSearch.UniqueID;
productManager objproduct = new productManager();
DataTable dtadmin = new DataTable();
try
{
if (txtsearch.Text != "")
{
objproduct.sku = txtsearch.Text.Trim();
}
else
{
objproduct.sku = txtsearch.Text.Trim();
}
if (pageNo == 0)
{
pageNo = 1;
}
objproduct.pageNo = pageNo;
objproduct.pageSize = pageSize;
objproduct.SortExpression = SortExpression;
querystring = "&pageSize=" + ddlpageSize.SelectedValue + "&key=" + txtsearch.Text;
dtadmin = objproduct.SearchProductImageItem();
totalrecs = objproduct.TotalRecord;
if (pageNo == 1)
{
objproduct.pageNo = 1;
pageNo = 1;
}
else if (pageNo == 0)
{
objproduct.pageNo = 1;
pageNo = 1;
}
else
{
objproduct.pageNo = (pageNo - 1) * pageSize;
}
objproduct.pageSize = pageSize;
totalpages = totalrecs / pageSize;
if ((totalrecs % pageSize) > 0 && (totalrecs > pageSize))
{
totalpages += 1;
}
gvAdmin.DataSource = dtadmin;
gvAdmin.DataBind();
if (dtadmin.Rows.Count > 0)
{
int startRowOnPage = (gvAdmin.PageIndex * gvAdmin.PageSize) + 1;
int lastRowOnPage = startRowOnPage + gvAdmin.Rows.Count - 1;
int totalRows = totalrecs;
ltrcountrecord.Text = "<div class=\"countdiv\">Showing " + startRowOnPage.ToString() + " to " + lastRowOnPage + " of " + totalRows + " entries</div>";
}
String strpaging = CommonFunctions.AdminPagingv2(totalpages, pageNo, querystring, "productImageUpload.aspx");
ltrpaggingbottom.Text = strpaging;
//Ltrup.Text = strpaging;
LoadDropDownList();
}
catch (Exception ex) { throw ex; }
finally { dtadmin.Dispose(); objproduct = null; }
}