Venkat

 Profile Answers by Venkat 

• Feb 12th, 2008

 

by using dataset

ds = new dataset()
sqlDbAdapter ad = new sqlDbAdapter(sqlquery,connobject)
ad.fill(ds,tablename)

DataReader

dr = new sqlDataReader()
sqlCommand sqlcmd = new sqlcommand(sqlqry,conObject)
dr = sqlcmd.executeReader();

The datareader can be used to forwared only. compare to datasete it is faster.