Cached Dataview insert into MS-SQL2000

A

A.S.V. Rosales

I've a cached dataview that i want to insert into a MS-
SQL2000 table. I've tried iterating the dataview values on
key and setting the parameters for the SQL-Querry INSERT,
but i only get the first row of the dataview inserted into
my SQL table while there's more than one row present.
I also tried the SqlAdapter, but could not accomplish.
My scenario :
I must put a datatable -> dataview into a cache for
retreival on another occasion (only when the submited
webpage is validated). When the page pass validation, I
retreive the cached dataview and want to put it's data
into a SQL table.
Do you have a written example in VB-script for
VisualStudio.Net 2002 ? I hope you guys can help me out,
i'm trying to solve this now for over 2 weeks with no
results until now....

Regards ..
Ashmir Rosales
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,482
Members
44,901
Latest member
Noble71S45

Latest Threads

Top