sqlconnection connection with vb.net

[pankajgarg12]

Hi, I am using datareader to simulate the records.(First , Previous , Last , Next)Buttons . I had not used sqldataadapter for add , delete , update buttons.I want to continue with the sqldatareader for first , previous , last , next buttons.Can somebody send me any code or link. Thanks :)

[Dave Kreskowiak]

You can't use a DataReader for Forward/Backward navigation. It's a forward-only reader. You'll have to use a DataAdapter and DataSet for this. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

[pankajgarg12]

Ok, Can you send me any link for that? Thanks :)

[HL_SUB]

Hi. You can not use DataReader for backward reading. You can use disconnected DB. To use that you can use DataSets and DataAdapters. Here is a quick and simple tutorial: http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson05.aspx The tutorial is in C# but the syntax is similar to VB.NET. Have fun. HL

[Dave Kreskowiak]

All you have to do is search the articles... Here[^], this article explains the concepts quite well, though the code is in C#, it's easily convertible to VB.NET. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome