protected void BindRepeaterData() { con.Open(); SqlCommand cmd = new SqlCommand("sps_searchresult", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@country", 1); cmd.Parameters.AddWithValue("@state", state); cmd.Parameters.AddWithValue("@pincode", pincode); cmd.Parameters.AddWithValue("@category", category); cmd.Parameters.AddWithValue("@subcategory", subcategory); con.Close(); //save the result in data table DataTable dt = new DataTable(); SqlDataAdapter adp = new SqlDataAdapter(cmd); adp.Fill(dt); PagedDataSource pgitems = new PagedDataSource(); DataView dv = new DataView(dt); pgitems.DataSource = dv; pgitems.AllowPaging = true; pgitems.PageSize = 5; pgitems.CurrentPageIndex = PageNumber; if (pgitems.PageCount > 1) { rptPaging.Visible = true; ArrayList pages = new ArrayList(); for (int i = 0; i < pgitems.PageCount; i++) pages.Add((i + 1).ToString()); rptPaging.DataSource = pages; rptPaging.DataBind(); } else { rptPaging.Visible = false; } rep_results.DataSource = pgitems; rep_results.DataBind(); //Change the text Now viewing text lblCurrentPage.Text = "Page : " + (PageNumber + 1).ToString() + " of " + pgitems.PageCount.ToString(); }
DataTable
int noOfRows = dt.Rows.Count;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)