ASP.NET

public static SqlDataAdapter dataAdapter(SqlCommand cmd, string connectionString) {
	SqlDataAdapter da;

	using (SqlConnection con = new SqlConnection(connectionString)) {
		cmd.Connection = con;
		con.Open();
		da = new SqlDataAdapter(cmd)
	}
	return da;
}

// After you get your data by using a DataAdapter fill a Dataset<br />
   DataSet ds = new DataSet();<br />
   da.Fill(ds);<br />
<br />
// create an instance of PagedDataSource and give ds as datasource to it.<br />
   PagedDataSource pds = new PagedDataSource();           <br />
   pds.DataSource = ds;<br />
   pds.AllowPaging = true;<br />
   pds.PageSize = 10;     <br />
<br />
// take curent page from QueryString and set CurrentPageIndex <br />
   int CurPage; <br />
   if (Request.QueryString["p"] != null) CurPage = Convert.ToInt32(Request.QueryString["p"]); <br />
   else CurPage = 1;<br />
   <br />
   pds.CurrentPageIndex = CurPage-1;<br />
<br />
// bind pds to repeater and set link for next and prev links or you can simple make a loop and <br />
// write all page links down with using another repeater<br />
   myRepeater.DataSource = pds;<br />
   if (pds.Count > 0)<br />
   {<br />
      myRepeater.Visible = true;<br />
      myRepeater.DataBind();<br />
   }<br />
<br />
   if (!pds.IsFirstPage) lnkPrev.HRef = "news.aspx?p=" + Convert.ToString(CurPage - 1);<br />
   if (!pds.IsLastPage)  lnkNext.HRef = "news.aspx?p=" + Convert.ToString(CurPage + 1);     

Guffa wrote:

Doesn't anybody ever have a look at how their posting ended up?