Inserting a dataset into an sql table

  • Just a general question to start with...I've generated a dataset from a (messy) delimited file and I'd like to insert it into an sql table...is there a way to do that?  I'm using C#.  Since the file is read via webresponse I'd prefer to keep it as a stream and not write it to disk, if that's possible.

     

    I have the C# code if anyone wants to see it.

     

    Thanks,

     

    Paul

  • you can prbly create a connected dataset with a table and do the update all at once and commit the changes using the dataset.acceptchanges() method. check this article from MSDN

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply