DataGrid Paging using DataReader – C# Windows Forms

create table tblEmp
    (
      E_ID int primary key ,
      E_Name varchar(60) ,
      E_Salary money ,
      E_DOJ datetime
    )
go

		/// <summary>
		/// Required designer variable.
		/// </summary>

		// Protected Connection.
		protected SqlConnection mcnSample;

		// Page
		private int mintTotalRecords = 0;
		private int mintPageSize = 0;
		private int mintPageCount = 0;
		private int mintCurrentPage = 1;

		// Connection String
		protected const string CONNECTION_STRING = "Server=localhost;UID=sa;PWD=;Database=Sample";

		private void fillGrid()
		{
			// For Page view.
			this.mintPageSize = int.Parse(this.tbPageSize.Text);
			this.mintTotalRecords = getCount();
			this.mintPageCount = this.mintTotalRecords / this.mintPageSize;

			// Adjust page count if the last page contains partial page.
			if (this.mintTotalRecords % this.mintPageSize > 0)
				this.mintPageCount++;

			this.mintCurrentPage = 0;

			loadPage();
		}

		private int getCount()
		{
			// This select statement is very fast compare to SELECT COUNT(*)
			string strSql = "SELECT Rows FROM SYSINDEXES WHERE Id = OBJECT_ID('tblEmp') AND IndId < 2";
			int intCount = 0;

			SqlCommand cmd = this.mcnSample.CreateCommand();
			cmd.CommandText = strSql;

			intCount = (int) cmd.ExecuteScalar();
			cmd.Dispose();

			return intCount;
		}

		private void loadPage()
		{
			string strSql = "";
			int intSkip = 0, i = 0;
			SqlDataReader dr;
			DataSet ds;
			DataTable dt;

			intSkip = (this.mintCurrentPage * this.mintPageSize);

			strSql = "SELECT * FROM tblEmp";

			SqlCommand cmd = this.mcnSample.CreateCommand();
			cmd.CommandText = strSql;

			dr = cmd.ExecuteReader();
			ds = new DataSet();

			dt = ds.Tables.Add("tblEmp");

			// Add the table columns.
			for (i = 0; i < dr.FieldCount; i++)
				dt.Columns.Add(dr.GetName(i), dr.GetFieldType(i)); 

			int intIdx = 0;
			while (dr.Read())
			{
				if (intIdx >= intSkip)
				{
					DataRow r = dt.NewRow();

					// Assign DataReader values to DataRow.
					for (i = 0; i < dr.FieldCount; i++)
						r[i] = dr[i];

					dt.Rows.Add(r);
				}

				if ((intIdx - intSkip) >= (this.mintPageSize - 1))
					break;

				intIdx++;
			}

			dr.Close();

			// Populate Data Grid
			this.dgEmp.DataSource = ds.Tables["tblEmp"].DefaultView;

			// Show Status
			this.lblStatus.Text = (this.mintCurrentPage + 1).ToString() + " / " + this.mintPageCount.ToString();

			cmd.Dispose();
			ds.Dispose();
		}

		private void goFirst()
		{
			this.mintCurrentPage = 0;

			loadPage();
		}

		private void goPrevious()
		{
			if (this.mintCurrentPage == this.mintPageCount)
				this.mintCurrentPage = this.mintPageCount - 1;

			this.mintCurrentPage--;

			if (this.mintCurrentPage < 1)
				this.mintCurrentPage = 0;

			loadPage();
		}

		private void goNext()
		{
			this.mintCurrentPage++;

			if (this.mintCurrentPage > (this.mintPageCount - 1))
				this.mintCurrentPage = this.mintPageCount - 1;

			loadPage();
		}

		private void goLast()
		{
			this.mintCurrentPage = this.mintPageCount - 1;

			loadPage();
		}