Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Cached Dataview insert into MS-SQL2000

Reply
Thread Tools

Cached Dataview insert into MS-SQL2000

 
 
A.S.V. Rosales
Guest
Posts: n/a
 
      06-26-2003
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
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorted DataView, but unsorted datalist when bound to the dataview CodeMonkey ASP .Net 1 02-04-2011 10:55 AM
Insert values into DataSource.DataView programmatically?? TenDot ASP .Net Web Controls 3 07-11-2006 09:14 PM
How To Insert Code With Javascript, How to insert into a div an amountof code Sergio del Amo Javascript 4 05-29-2005 02:45 AM
my cached dataset just wont stay cached!! Craig G ASP .Net 0 03-07-2005 10:02 AM
Dataview into new table ??? Sjaakie Helderhorst ASP .Net 3 04-16-2004 01:37 PM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57