ASP.NET

//For paging a Gridview manually we have to handle the Gridview’s PageIndexChanged Event.  
//In the event we need to change the PageIndex of Gridview to the page that user has clicked and again bind the Gridview.

protected void gvPaging_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
   gvPaging.PageIndex = e.NewPageIndex;
   gvPaging.DataBind();
}

//This is all you need to do to make manual paging in the Gridview.
//For manually sorting in Gridview we need to handle the Sorting event of Gridview. Here is the code to do it.

protected void gvSorting_Sorting(object sender, GridViewSortEventArgs e)
{
   DataTable dtSortTable = gvSorting.DataSource as DataTable;

   if (dtSortTable != null)
   {
      DataView dvSortedView = new DataView(dtSortTable);
      dvSortedView.Sort = e.SortExpression + " " + getSortDirectionString(e.SortDirection);

      gvSorting.DataSource = dvSortedView;
      gvSorting.DataBind();
   }
}

private string getSortDirectionString(SortDirection sortDireciton)
{
   string newSortDirection = String.Empty;
   if(sortDirection== SortDirection.Ascending)
   {
       newSortDirection = "ASC";
   }
   else
   {
      newSortDirection = "DESC";
   }
   return newSortDirection
}

Mark Nischalke wrote:

Books are not always correct or give you all of the information.

Abhijit Jana wrote:

Here is my two article which will help you for both of these cases.

PDTUM wrote:

Unfortunately, it does not provide me with a workable solution for this problem

.invisibility
{
    display:none;
}

Excel.Application oXL = new Excel.Application();

//Get a new workbook.
Excel._Workbook oWB = (Excel._Workbook)(oXL.Workbooks.Add( Type.Missing ));

	// Load Client Task Timer Sheet
Excel._Worksheet oSheet = (Excel._Worksheet)oWB.Sheets["Sheet1"];
oSheet = (Excel._Worksheet)oWB.ActiveSheet;
oSheet.Name = "Tasks";
	
//Add table headers going cell by cell.
oSheet.Cells[1, 1] = "CLIENTS";
oSheet.Cells[1, 2] = "ASSIGNMENTS";
oSheet.Cells[1, 3] = "STATUS";
oSheet.get_Range("A1", "C1").Font.Bold = true;
oSheet.get_Range("A1", "C1").VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;

	// Load Clients Sheet
oSheet = (Excel._Worksheet)oWB.Sheets["Sheet2"];
oSheet = (Excel._Worksheet)oWB.ActiveSheet;
oSheet.Name = "Clients";
	
//Add table headers going cell by cell.
oSheet.Cells[1, 1] = "CLIENTS";
oSheet.get_Range("A1", "A1").Font.Bold = true;
oSheet.get_Range("A1", "A1").VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;

oSheet = (Excel._Worksheet)oWB.Sheets["Sheet3"];
oSheet.Delete();

oWB.SaveAs("F:\\Test.xls", Excel.XlFileFormat.xlWorkbookNormal, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
oXL.Quit();