database related question

umair mohsin

11y937.NET

hello to everyone

i want to design an application in which i want to fetch data from database.there would be text boxes as per database columns and 4 buttons

for first,last,next and previous record. i want to show data base data in these text boxes and loop through each database record using. i think now the scenerio is very clear.anybody help me in it

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Akash Varshney11y ago

As per my understanding you need two show database values to your UI . in your case those are text boxes .

Now suppose you have a table which have some columns like below.

DB table

Id	Col1	Col2	Col3	Col4
1	111	222	333	444
2	Aaa		Ccc	Ddd
3	Xxx	Yyy	Zzz	Ooo

UI text box

txtbox1 111

Txtbox2 222

Txtbox3 333

Txtbox4 444

< last>>

you want to see data in the textboxes on click of those buttons

OFFSET excludes the first set of records.
OFFSET can only be used with an ORDER BY clause.
OFFSET with FETCH NEXT returns a defined window of records.
OFFSET with FETCH NEXT is great for building pagination support.

FIRST CLICK----- Select * from Table Offset 0 Fetch Next 1 Row

Last click-------- Select * from Table Offset (n-1) Fetch Next 1 Row

in the same way you NEED KNOW maintain the OFFSET Value to get the Specific result

Priyaranjan K S11y ago
Hi,

You may check out this for more info :
http://www.functionx.com/vcsharp2003/databases/Lesson02.htm

Thanks,
Priyan

If you found this useful Please mark this as Answer
umair mohsin11y ago
no akash i really don't understand what you are saying can you please elaborate your answer by giving an example application
Akash Varshney11y ago
you dont need any other coloumns. you only should have a coloumn which will be having it the primaryId .
When you fetch the record you should know how many records are avaiable and what is the page size .. I think in your case page size is one.
Check more in SQL About FETCH, OFFSET .. You will get your answer with more clarity!! Hope i may answerd your question .