Paging in DataList in Asp.net

<asp:DataList ID="DataList1" runat="server" RepeatDirection="Horizontal" RepeatColumns="5" EnableViewState="true" Width="88%">

  <itemtemplate>Xyz </itemtemplate>

   

 <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString='<%$ ConnectionStrings:ConnString %>'SelectCommand="SELECT x,y,z ...">

        

                    <tr>

                        <td>

                              <asp:Label ID="lblCurrentPage" runat="server" Visible="true">

                        </td>

                    </tr>

                    <tr>

                        <td align="center">

                              <asp:Button ID="cmdPrev" runat="server" Text=" << " OnClick="cmdPrev_Click">

                           

                             <asp:Button ID="cmdNext" runat="server" Text=" >> " OnClick="cmdNext_Click">

                           

                        </td>

                    </tr>

The code behind:

    protected void items()

    {

        PagedDataSource objDs = new PagedDataSource();

        DataView dv = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);

        objDs.DataSource = dv;

        objDs.AllowPaging = true;

        objDs.PageSize = 20;

        objDs.CurrentPageIndex = CurrentPage;

        lblCurrentPage.Text = "Page:" + (CurrentPage + 1).ToString() + " Of " +    objDs.PageCount.ToString();

        cmdPrev.Enabled = !objDs.IsFirstPage;

        cmdNext.Enabled = !objDs.IsLastPage;

        DataList1.DataSource = objDs;

       DataList1.DataBind();

    }

protected void cmdPrev_Click(object sender, EventArgs e)

    {

        try

        {

            CurrentPage -= 1;

            items();

        }

        catch (Exception ex)

        {

            Logger.LogException(ex);

        }

    }

    protected void cmdNext_Click(object sender, EventArgs e)

    {

        try

        {

            CurrentPage += 1;

            items();

        }

        catch (Exception ex)

        {

            Logger.LogException(ex);

        }

    }

Exporting DataGrid to Text file in asp.net

Database db = DatabaseFactory.CreateDatabase();

DBCommandWrapper selectCommandWrapper =

db.GetStoredProcCommandWrapper("sp_GetLatestArticles");

DataSet ds = db.ExecuteDataSet(selectCommandWrapper);

StringBuilder str = new StringBuilder();

for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)

{

for (int j = 0; j <= ds.Tables[0].Columns.Count - 1; j++)

{

str.Append(ds.Tables[0].Rows[i][j].ToString());

}

str.Append("<BR>");

}

Response.Clear();

Response.AddHeader("content-disposition",

"attachment;filename=FileName.txt");

Response.Charset = "";

Response.Cache.SetCacheability(HttpCacheability.NoCache);

Response.ContentType = "application/vnd.text";

System.IO.StringWriter stringWrite = new System.IO.StringWriter();

System.Web.UI.HtmlTextWriter htmlWrite =

new HtmlTextWriter(stringWrite);

Response.Write(str.ToString());

Response.End();

Exporting DataGrid to Word in asp.net

Response.Clear();

Response.AddHeader("content-disposition", "attachment;filename=FileName.doc");

Response.Charset = "";

Response.Cache.SetCacheability(HttpCacheability.NoCache);

Response.ContentType = "application/vnd.word";

System.IO.StringWriter stringWrite = new System.IO.StringWriter();

System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

myDataGrid.RenderControl(htmlWrite);

Response.Write(stringWrite.ToString());

Response.End();