DataTables

Discussion in 'ASP .Net Web Controls' started by Brian Shannon, Jul 9, 2004.

  1. I create a datatable tostore information in as my program is running. When
    the program is finished I have about 20 records in the datatable.

    I know need to insert these records into an sql2000 DB. I loop through the
    table to insert 1 record at a time using the sqlcommand ExecuteNonQuery().

    Is there a way to insert all the records from the datatable in 1 statement
    to the DB? Here I am making 20 calls the my DB. Hopefully there is a more
    efficient way.

    If you need more info or more clarification please ask!

    Thanks
    Brian Shannon, Jul 9, 2004
    #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. Ravindra

    About datatables

    Ravindra, Dec 30, 2005, in forum: ASP .Net
    Replies:
    1
    Views:
    491
    Christopher Reed
    Dec 30, 2005
  2. Richard Loupatty
    Replies:
    2
    Views:
    371
    Richard Loupatty
    Jul 18, 2003
  3. Kevin Spencer

    Re: Combining DataTables

    Kevin Spencer, Jul 21, 2003, in forum: ASP .Net
    Replies:
    0
    Views:
    1,100
    Kevin Spencer
    Jul 21, 2003
  4. Gene Ariani
    Replies:
    0
    Views:
    2,801
    Gene Ariani
    Aug 21, 2003
  5. Simple Simon

    Compare Two DataTables

    Simple Simon, Dec 15, 2003, in forum: ASP .Net
    Replies:
    3
    Views:
    12,851
    Simple Simon
    Dec 15, 2003
Loading...

Share This Page