Click here to Skip to main content
       

Database

 
AnswerRe: Cassandra or MySQL? PinmemberMycroft Holmes7-Jan-13 12:01 
AnswerRe: Cassandra or MySQL? PinmemberPIEBALDconsult7-Jan-13 12:53 
QuestionOracle Application expres PinmemberFred Andres6-Jan-13 11:52 
AnswerRe: Oracle Application expres PinmemberChris Meech6-Jan-13 13:57 
GeneralRe: Oracle Application expres PinmemberFred Andres7-Jan-13 8:32 
AnswerRe: Oracle Application expres PinmemberShameel7-Jan-13 3:45 
GeneralRe: Oracle Application expres PinmemberFred Andres7-Jan-13 8:32 
QuestionSQL paging with search PinmemberLance Parker6-Jan-13 2:11 
I would like to thank everyone in advance for their answers as I am extremely stuck. Also apologies if I put this question on wrong as it is my first attempt at this.

I am currently developing a C# application for a project at work, which uses a SQL 2008 server as a back end database. I know it’s an older way but I have been using windows forms and ADO.Net and have managed through this site and various books to get quit far but now have hit a problem that I cannot find answered on here. Some tables are going to be very large and hence I want to implement paging and have done this through a stored procedure. The application works out what page it requires and passes the start row index and number of rows to return to the procedure. This works perfectly (though I have read various posts to do with performance, and different ways of achieving paging in SQL).
My problem has arisen now that I won’t to introduce searching into the mix. Most posts/articles are geared towards ASP.net application which a user specifies the search criteria and the results for that search are returned in a page form. But I want to copy the functionality of a system we currently run at work called Syspro. Syspro will return you to the page relevant to the data you have just edited, added, or searched for. For example it opens the form with a data grid view on page one, I add new data which will be 100 pages in, after adding the data and closing the add form it finds the page that result is on and shoots the data grid view page to that page and high lights the new row. This works in the same way when you search and edit as you can skip through data on the add/mod form as well.
 
Is there a way of replicating this behavior in SQL or is this something that is handled in the C# application. I need a way of determining what page the data I require is on, but I understand that SQL only assigns row numbers after a query is run against that table. I have thought of using the primary key to save me the trouble, but some tables will allow deletes.
AnswerRe: SQL paging with search Pinmemberjschell6-Jan-13 5:19 
GeneralRe: SQL paging with search PinmemberLance Parker7-Jan-13 8:23 
GeneralRe: SQL paging with search Pinmemberjschell7-Jan-13 9:12 
QuestionI want to ask query related to mysql Pinmembermanisharathore5-Jan-13 7:32 
AnswerRe: I want to ask query related to mysql PinmemberMycroft Holmes5-Jan-13 11:03 
Questionproblem in ado.net with access 2010 PinmemberAchilles843-Jan-13 23:20 
AnswerRe: problem in ado.net with access 2010 PinmemberMycroft Holmes4-Jan-13 13:55 
Questionhow to cast real data type in sql server 2005 PinmemberAuf Klarung2-Jan-13 22:55 
QuestionRe: how to cast real data type in sql server 2005 PinmemberEddy Vluggen4-Jan-13 22:52 
QuestionSql server like clause Pinmemberrubonkumar28-Dec-12 4:44 
AnswerRe: Sql server like clause PinmvpRichard MacCutchan28-Dec-12 6:05 
AnswerRe: Sql server like clause [modified] PinmemberPIEBALDconsult28-Dec-12 6:38 
GeneralRe: Sql server like clause PinmemberMike Meinz28-Dec-12 6:49 
GeneralRe: Sql server like clause Pinmemberrubonkumar28-Dec-12 19:08 
AnswerRe: Sql server like clause Pinmemberrajarao3044-Jan-13 0:50 
QuestionDatabase design question PinmemberDavidCrow27-Dec-12 15:22 
AnswerRe: Database design question PinmemberPIEBALDconsult27-Dec-12 15:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web01 | 2.8.140721.1 | Last Updated 29 Jul 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid