how to select data from database one by one on button click

hello,
You can use session to store data.

fetch data from database and store it in a data table and save it using session, now also put a variable x initialize with 0, on each button click, add "1" to x and again store it into session and store data table from session and  using row property you can fetch next row on each click.


datatable dt=new datatable();
da.fill(dt);
session["data"]=dt;


and on each button click use like this..

dt.rows[x][columnfield].tostring();


thanx