Microsoft solutions using System; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Windows.Forms; public class PagingSample: Form {// Form controls Button prevBtn = new Button ();. Button nextBtn = new Button (); static DataGrid myGrid = new DataGrid (); static Label pageLbl = new Label ();. // Paging variables static int pageSize = 10;. // Size of viewed page static int totalPages = 0; // Total pages static int currentPage = 0;. // Current page static string firstVisibleCustomer = "."; // First customer on page to determine location for move previous static string lastVisibleCustomer =. ""; // Last customer on page to . determine location for move next // DataSet to bind to DataGrid static DataTable custTable;. // Initialize connection to database and DataAdapter static SqlConnection nwindConn = new SqlConnection ( "Data Source = localhost; Integrated Security = SSPI; Initial Catalog = northwind". ); static sqldataadapter custom = new sqldataadapter ("", nwindconn); static SQLCO mmand selCmd = custDA.SelectCommand; public static void GetData (string direction) {// Create SQL statement to return a page of records selCmd.Parameters.Clear (); switch (direction) {case "Next":. selCmd.CommandText = "SELECT TOP" pageSize "CustomerID, CompanyName FROM Customers" "WHERE CustomerID> @CustomerId ORDER BY CustomerID"; selCmd.Parameters.Add ( "@ CustomerId", SqlDbType.VarChar, 5) .Value = lastVisibleCustomer; break; Case "previous": SELCMD.COMMANDTEXT = "SELECT TOP" Pagesize "Customerid, CompanyName from Customers"
"WHERE CustomerID <@CustomerId ORDER BY CustomerID DESC"; selCmd.Parameters.Add ( "@ CustomerId", SqlDbType.VarChar, 5) .Value = firstVisibleCustomer; break; default: selCmd.CommandText = "SELECT TOP" pageSize "CustomerID, CompanyName FROM Customers ORDER BY CustomerID";. // Determine total pages SqlCommand totCMD = new SqlCommand ( "SELECT Count (*) FROM Customers", nwindConn); nwindConn.Open (); int totalRecords = (int) totCMD. ExecuteScalar (); nwindConn.Close (); totalPages = (int) Math.Ceiling ((double) totalRecords / pageSize); break;.} // Fill a temporary table with query results DataTable tmpTable = new DataTable ( "Customers") ; int recordsAffected = custDA.Fill (tmpTable); // If table does not exist, create it if (custTable == null) custTable = tmpTable.Clone ();.. // Refresh table if at least one record returned if ( Recordsaffected> 0) {Switch (Direction) {CASE "Next": CurrentPage ; Break; Case "Previous": currentpage--; break; default: currentpage = 1; Break;} Pagelbl.text = "PA ge " currentPage " of " totalPages;. // Clear rows and add new results custTable.Rows.Clear (); foreach (DataRow myRow in tmpTable.Rows) custTable.ImportRow (myRow); // Preserve first and last primary key values DataRow [] ordRows = custTable.Select ( "", "CustomerID ASC"); firstVisibleCustomer = ordRows [0] [0] .ToString ();. lastVisibleCustomer = ordRows [custTable.Rows.Count - 1] [0 ] .Tostring ();}} public paningsample ()} public paningsample () {// Initialize controls and add to form. This.clientsize = new size (360, 274); this.text = "northwind data";
