Click here to Skip to main content
13,091,300 members (50,816 online)
   

Database

 
AnswerRe: Cassandra or MySQL? Pin
Mycroft Holmes7-Jan-13 12:01
memberMycroft Holmes7-Jan-13 12:01 
AnswerRe: Cassandra or MySQL? Pin
PIEBALDconsult7-Jan-13 12:53
memberPIEBALDconsult7-Jan-13 12:53 
QuestionOracle Application expres Pin
Fred Andres6-Jan-13 11:52
memberFred Andres6-Jan-13 11:52 
AnswerRe: Oracle Application expres Pin
Chris Meech6-Jan-13 13:57
memberChris Meech6-Jan-13 13:57 
GeneralRe: Oracle Application expres Pin
Fred Andres7-Jan-13 8:32
memberFred Andres7-Jan-13 8:32 
AnswerRe: Oracle Application expres Pin
Shameel7-Jan-13 3:45
memberShameel7-Jan-13 3:45 
GeneralRe: Oracle Application expres Pin
Fred Andres7-Jan-13 8:32
memberFred Andres7-Jan-13 8:32 
QuestionSQL paging with search Pin
Lance Parker6-Jan-13 2:11
memberLance 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 Pin
jschell6-Jan-13 5:19
memberjschell6-Jan-13 5:19 
GeneralRe: SQL paging with search Pin
Lance Parker7-Jan-13 8:23
memberLance Parker7-Jan-13 8:23 
GeneralRe: SQL paging with search Pin
jschell7-Jan-13 9:12
memberjschell7-Jan-13 9:12 
QuestionI want to ask query related to mysql Pin
manisharathore5-Jan-13 7:32
membermanisharathore5-Jan-13 7:32 
AnswerRe: I want to ask query related to mysql Pin
Mycroft Holmes5-Jan-13 11:03
memberMycroft Holmes5-Jan-13 11:03 
Questionproblem in ado.net with access 2010 Pin
Achilles843-Jan-13 23:20
memberAchilles843-Jan-13 23:20 
AnswerRe: problem in ado.net with access 2010 Pin
Mycroft Holmes4-Jan-13 13:55
memberMycroft Holmes4-Jan-13 13:55 
Questionhow to cast real data type in sql server 2005 Pin
Auf Klarung2-Jan-13 22:55
memberAuf Klarung2-Jan-13 22:55 
QuestionRe: how to cast real data type in sql server 2005 Pin
Eddy Vluggen4-Jan-13 22:52
memberEddy Vluggen4-Jan-13 22:52 
QuestionSql server like clause Pin
rubonkumar28-Dec-12 4:44
memberrubonkumar28-Dec-12 4:44 
AnswerRe: Sql server like clause Pin
Richard MacCutchan28-Dec-12 6:05
mvpRichard MacCutchan28-Dec-12 6:05 
AnswerRe: Sql server like clause Pin
PIEBALDconsult28-Dec-12 6:38
memberPIEBALDconsult28-Dec-12 6:38 
GeneralRe: Sql server like clause Pin
Mike Meinz28-Dec-12 6:49
memberMike Meinz28-Dec-12 6:49 
GeneralRe: Sql server like clause Pin
rubonkumar28-Dec-12 19:08
memberrubonkumar28-Dec-12 19:08 
AnswerRe: Sql server like clause Pin
rajarao3044-Jan-13 0:50
memberrajarao3044-Jan-13 0:50 
QuestionDatabase design question Pin
DavidCrow27-Dec-12 15:22
memberDavidCrow27-Dec-12 15:22 
AnswerRe: Database design question Pin
PIEBALDconsult27-Dec-12 15:52
memberPIEBALDconsult27-Dec-12 15:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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 |
Web04 | 2.8.170813.1 | Last Updated 15 Aug 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid