Cached Dataview insert into MS-SQL2000

Discussion in 'ASP .Net' started by A.S.V. Rosales, Jun 26, 2003.

  1. 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
     
    A.S.V. Rosales, Jun 26, 2003
    #1
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. David Waz...
    Replies:
    5
    Views:
    430
    Yan-Hong Huang[MSFT]
    Jul 14, 2003
  2. Craig G
    Replies:
    0
    Views:
    399
    Craig G
    Mar 7, 2005
  3. PointMan

    migration sql2005 into sql2000

    PointMan, May 16, 2006, in forum: ASP .Net
    Replies:
    2
    Views:
    1,519
    Juan T. Llibre
    May 16, 2006
  4. CodeMonkey
    Replies:
    1
    Views:
    738
    joyal jhaveri
    Feb 4, 2011
  5. TenDot
    Replies:
    3
    Views:
    291
    TenDot
    Jul 11, 2006
Loading...

Share This Page