Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
Why I cannot find SqlCommand.ExecutePageReader? What happen? If it function cut, how to make page
June 01, 2011
please tell me the answer with example
Posted Date: June 08, 2011 Points: 20
When did you find execution method like "SqlCommand.ExecutePageReader" ? I didn't see like this methods..
Posted Date: June 09, 2011 Points: 20
this method used for "data paging" concept that is introducing ADO.NET 2.0.
string connectionString = ..; //some connection string
SqlConnection sqlConnection = new SqlConnection(connectionString);
SqlCommand sqlCommand = new SqlCommand("Select * from Employee", sqlConnection);
SqlDataReader sqlDataReader = sqlCommand.ExecutePageReader(CommandBehavior.CloseConnection, 1, 25);
but here ExecutePageReader method not visible while typing this code.
i mean can i import any namespace in the code.
which version of the .net support this method.how can i achieve this task please help me.
here executePageReader method takes 3 arguments commandbehavior,startindex(1),endindex(25)
To post reply
Related Questions Related Questions
run particular function in a page automatically based on time
I want make image slide show from database as exactly like www.manoramaonline.com on home page.
The events that happen when a client requests an ASP.NET page from IIS server
How find IP address of the client in ASP.net
User can not select TEXT for copy paste from my .aspx page...
How to make thumbnail of one image in C# + windows aplication.....
watermark logo for web-page using ASP.Net
Latest Forum Questions From The Same Category
Sql Bulk Insert from multiple delimited Textfile using c#.net
Read *.ds file to Dataset Object
TNS:address already in use Exception
Accessing Virtual folder
Dynamically Insert single record into MS access from SQL server
Deleting records from database while deselecting checkbox in gridview
How to generate script to export Database programmatically
Abstact and Interface Class
How to ingnore by default value of comboboxes?
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend