how to insert data from a data table into sqlserver table

[indona]

hi, i have to enter data from a delimited file into sqlserver database table.
i have been able to delimit the file and read the data into a data table, now i want enter the data table contents to sqlserver. some help in this matter...if possible code for moving data from data table to the database....wou ld be really helpful. thanks in advance.

[ThatThatGuy]

@indona
http://www.jonasjohn.de/snippets/csh...on-example.htm

I think you should follow this tutorial

[maddyromeo]

if you already have data in your DataTable it just takes
4 steps to update into database

1)create a connection to database:

con = new SqlConnection(c onString);
// for conString see
http://www.csharp-station.com/Tutori.../Lesson02.aspx


2)Open connection :

con.Open();


3)Enter into DataBase with a loop like :

for(int i=0;i<dt.Rows.C ount;i++)
{
command = new SqlCommand("INS ERT INTO tables (value,val) VALUES('"+dt.Ro ws[i][0].ToString()+"', '"+dt.Rows[i][1].ToString()+"') ",con);
command.Execute NonQuery();
}

here i assume two columns so

dt.Rows[i][0].ToString() is the string from row i and column 0
dt.Rows[i][1].ToString() is the string from row i and column 1

u have to pass values to your own need

4)Close Connection :
con.Close();

[indona]

thanks a lot....the tutorial and the code you provided really helped..n wid that have been able to do my work..
thanks a lot all..

[samundersingh19]

Try this:

private void BulkUpload(DataTable dt)
{
    dt.TableName="YourDataTable";
    string constr="your connection string";
    using(SqlConnection connection=new SqlConnection(constr))
    {
      connection.Open();
      //CreatingTranscationsothatitcanrollbackifgotanyerrorwhileuploading
      SqlTransaction trans=connection.BeginTransaction();
     //Start bulkCopy
     using(SqlBulkCopy bulkCopy=new SqlBulkCopy(connection,
     SqlBulkCopyOptions.TableLock|
     SqlBulkCopyOptions.FireTriggers,
     trans))
     {
       //Setting timeout to 0 means no time out for this command will not timeout until upload complete.
     //Change as per you
     bulkCopy.BulkCopyTimeout=0;
     bulkCopy.DestinationTableName=dt.TableName;
     //write the data in the "dataTable"
     bulkCopy.WriteToServer(dt);
    }
   }
}
 

From:

Bulk insert or upload records into SQL Server with DataTable in c sharp using SqlBulkCopy