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....would 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(conString);
// 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.Count;i++)
{
command = new SqlCommand("INSERT INTO tables (value,val) VALUES('"+dt.Rows[i][0].ToString()+"','"+dt.Rows[i][1].ToString()+"')",con);
command.ExecuteNonQuery();
}

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