asp.net core docker Implement custom paging in an asp.net gridview without using datasource controls - Part 54

Link for csharp, asp.net, ado.net, dotnet basics and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat...

Link for text version of this video
http://csharp-video-tutorials.blogspo...

Step 1: Create a stored procedure to retrieve employees by page index and page size. This procedure also has an output parameter to return the total

number of rows in the database table.
Create proc spGetEmployees_by_PageIndex_and_PageSize
@PageIndex int,
@PageSize int,
@TotalRows int output
as
Begin
Declare @StartRowIndex int
Declare @EndRowIndex int

Set @StartRowIndex = (@PageIndex * @PageSize) + 1; Set @EndRowIndex = (@PageIndex + 1) * @PageSize;

Select EmployeeId, Name, Gender, City from
(Select ROW_NUMBER() over (order by EmployeeId) as RowNumber, EmployeeId, Name, Gender, City
from Sample.dbo.tblEmployee) Employees
--Replace ] GREATERTHAN symbol and "[" with LESSTHAN symbol
Where RowNumber ]= @StartRowIndex and RowNumber [= @EndRowIndex

Select @TotalRows = COUNT(*) from tblEmployee
End

Step 2: Add a class file with name = "EmployeeDataAccessLayer.cs".
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace Demo
{ public class Employee { public int EmployeeId { get; set; } public string Name { get; set; } public string Gender { get; set; } public string City { get; set; } } public class EmployeeDataAccessLayer { // Replace square brackets with angular brackets public static List[Employee] GetEmployees(int pageIndex, int pageSize, out int totalRows) { // Replace square brackets with angular brackets List[Employee] listEmployees = new List[Employee](); string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { SqlCommand cmd = new SqlCommand("spGetEmployees_by_PageIndex_and_PageSize", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter paramStartIndex = new SqlParameter(); paramStartIndex.ParameterName = "@PageIndex"; paramStartIndex.Value = pageIndex; cmd.Parameters.Add(paramStartIndex); SqlParameter paramMaximumRows = new SqlParameter(); paramMaximumRows.ParameterName = "@PageSize"; paramMaximumRows.Value = pageSize; cmd.Parameters.Add(paramMaximumRows); SqlParameter paramOutputTotalRows = new SqlParameter(); paramOutputTotalRows.ParameterName = "@TotalRows"; paramOutputTotalRows.Direction = ParameterDirection.Output; paramOutputTotalRows.SqlDbType = SqlDbType.Int; cmd.Parameters.Add(paramOutputTotalRows); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Employee employee = new Employee(); employee.EmployeeId = Convert.ToInt32(rdr["EmployeeId"]); employee.Name = rdr["Name"].ToString(); employee.Gender = rdr["Gender"].ToString(); employee.City = rdr["City"].ToString(); listEmployees.Add(employee); } rdr.Close(); totalRows = (int)cmd.Parameters["@TotalRows"].Value; } return listEmployees; } }
}

Step 3: Drag and drop gridview and a repeater control and set the required properties accordingly.

Step 4: Copy and paste the following code in webform1.aspx.cs
protected void Page_Load(object sender, EventArgs e)
{ if (!IsPostBack) { int totalRows = 0; GridView1.DataSource = EmployeeDataAccessLayer. GetEmployees(0, GridView1.PageSize, out totalRows); GridView1.DataBind(); DatabindRepeater(0, GridView1.PageSize, totalRows); }
}
protected void linkButton_Click(object sender, EventArgs e)
{ int totalRows = 0; int pageIndex = int.Parse((sender as LinkButton).CommandArgument); pageIndex -= 1; GridView1.PageIndex = pageIndex; GridView1.DataSource = EmployeeDataAccessLayer. GetEmployees(pageIndex, GridView1.PageSize, out totalRows); GridView1.DataBind(); DatabindRepeater(pageIndex, GridView1.PageSize, totalRows);
}

Please refer to my blog for the complete code
http://csharp-video-tutorials.blogspo...

asp.net core docker Implement custom paging in an asp.net gridview without using datasource controls - Part 54
85 Likes	85 Dislikes
30,083 views views	524K followers
Education	Upload TimePublished on 11 Apr 2013

Related keywords

wcf vs web api,ado.net core,sql server management studio,webkinz,webadvisor,craigslist nj,gridview datasource,implementar,wcf one piece,asp.net core 3,ajax players,implementing domain-driven design pdf,weber grill parts,webtoon,tutorials by hugo,csharp corner,mvc design pattern,asp.net machine account,servers for minecraft,asp.net core dependency injection,ado.net tutorial,implementer un algorithme génétique en java,services angular,ajax ontario,asp.net mvc tutorial,implémentable,asp.net cos'è,csharp assembly,implementing microsoft azure infrastructure solutions,tutorialspoint python,sql join,services briefcase,asp.net core web api,ajax jquery,wccftech,craigslist ny,gridview flutter,asp.net zero,csharp foreach,server memes,sql date format,services online,chase,serverless architecture,implementing safe,server resume,wcf c#,server books,gridview rowcommand,tutorialspoint javascript,mvcc connect,ado.net mysql,services technologies gps,ajax deadpool,server jobs,cvs,website,mvc tutorial,costco hours,wcf service application,implementing the cycle of success a case study answers,tutorialspoint spring,serverless,paging system diagram,wcf soap,paging system supplier,wcf cat,cool math games,wcf test client,implementing domain-driven design,paging system supplier philippines,paging meaning tagalog,services & training hse colombia sas,servicestack,citibank,asp.net core identity,sql union,ajax parking,sql database,implementation science,asp.net core logging,gridview devexpress c#,mvconnect,cunyfirst,asp.net guida,wcf nba,csharp download,wcfi foundation,csharp online,wcf authentication,tutorials near me,http://asp.net,server 2019,chernobyl,ado.net descargar,web of dreams,paging paging,serverminer,gridview pagination,ajax cleaner,ado.net visual studio 2019,webassign,implementing คือ,ado.net vs entity framework,ado.net visual studio 2017,implementing act,gridview height,csharp list,sql like,asp.net mvc,asp.net core tutorial,sqlite,gridview c#,wcfm,implementing queue using stack,ajax roster,implementing synonyms,mvc architecture,http://ado.net,implementing the cycle of success a case study reading answer,implementation meaning,asp.net core mvc,ajax soccer,server hosting,wcfi,implement definition,implementing rules and regulations of ra 7610,ajax dish soap,capital one,server rack,tutorialspoint html,paging or calling,csharp interface,craigslist,webroot,tutorialspoint reactjs,ajax request,wcf dragon ball,implementation synonym,asp.net core 2.2,paging microphone,tutorialspoint python 3,paging the attention,sql developer,webster,services transmission company sas,sql group by,gridviewrow,asp.net core signalr,services manager,mvc framework,ajax paving,mvc near me,implements java,tutorialspoint spring boot,implementing แปลว่า,mvc map,csharp online compiler,asp.net download,implementing evidence based practice in nursing,sql between,ado.net c# pdf,services tag dell,wcf 2019 nba,csharp switch,ado.net ventajas y desventajas,paging file,csharpstar,implementing definition,wcf tutorial,tutorialspoint,ajax meaning,csharp-video-tutorials.blogspot,tutorials dojo,implement in arabic,central park 5,csharp string format,ado.net c#,asp.net core github,gridview android example,server status,ajax fc,server jobs nyc,asp.net core swagger,sql formatter,credit karma,services group,gridview css,gridview yii2,server error in '/' application,paging file size,services windows,asp.net core 3.0,sql injection,gridview asp.net,tutorialspoint c#,wcf ria services,calculator,ado.net entity data model,sql insert,tutorialspoint tableau,services google play apk,sqlyog,implements serializable,asp.net core 3 release date,sql server,server job description,tutorials by a,servicenow,webcam,mvc hours,webmd symptom,csharp array,csharp enum,ajax call,asp.net core 2. guida completa per lo sviluppatore,gridview c# asp.net,asp.net core,server pro,server status ffxiv,cheap flights,webcrims,asp.net core hosting,services sas,paging file windows 10,paging meaning in english,implementing change,tutorialspoint java,tutorialspoint java compiler,implementation of jaxb-api has not been found on module path or classpath,webmd,implemented synonym,implementing synonym,csharp to json,college football,ado.net dataset,csharp dictionary,implementation traduction,cnn,website builder,tutorialspoint sql,asp.net web api,implementing,server side rendering,weber grills,paging someone,sql server 2017,tutorialspoint spark,mvc nj,ado.net oracle,asp.net core download,csharp to vb.net,paging meaning,implementing meaning in hindi,gridview column width,webster bank,webstaurant,paging example,tutorialsystems,ajax post,services fms publish announcement,gridview devexpress,services.msc no abre,ajax jersey,csharp operator,asp.net core razor pages,paging system price,server duties,asp.net core environment variables,csharp random,century 21,implementing rules and regulations of the local government code of 1991,implemented,services consultores,services consulting,gridview hide column,mvcsd,services.msc,implémentation,mvcsc,ado.net pdf,asp.net core configuration,ajax marvel,sql update,asp.net tutorial,mvc medical,implementing the cycle of success a case study,implementing a sql data warehouse exam ref 70-767 pdf,ado.net entity data model visual studio 2019,wcfs international curriculum,mvc2,ado.net entity data model visual studio 2017,chase online,wcf api,costco,server jobs near me,webex,gridview bootstrap 4,sql meaning,sql tutorial,sql commands,implémenter,ado.net entity framework,ajax tavern,implementation in french,tutorialsteacher,ajax javascript,paging in mall,services desk,ajax greek,implementation plan,csharp tutorial,mvc pattern,ado.net sql server,ado.net connection,asp.net identity,gridview android,mvcu,paging system,gridview bootstrap,asp.net core middleware,paging ringtone,implements runnable,gridview xamarin forms,wcf web service,mvc webadvisor,web store,mvcc,webmail,mvci,paging sound,mvctc,