how to insert data from datatable to database with single insert statement

Posted by Mrutyunjay51 under ASP.NET on 5/22/2011 | Points: 10 | Views : 10456 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

how to insert data from datatable to database with single insert statement

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Raja on: 5/22/2011 [Member] Starter | Points: 25

0	Hi Mrutyunjay51, Read this article http://www.itfunda.com/how-to-insert-records-into-the-database/Free/126. Thanks Regards, Raja, USA Mrutyunjay51, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Mcadeepuraj on: 5/23/2011 [Member] Starter | Points: 25

0	you can use bulkcopy insert e.g Dim sqlbulkSubt As New SqlBulkCopy(con) sqlbulkSubt.DestinationTableName = "your Database table name" sqlbulkSubt.ColumnMappings.Add("Column_Source", "Column_destination") sqlbulkSubt.ColumnMappings.Add("Column_Source", "Column_destination") sqlbulkCert.WriteToServer(Your Source table name) Deepak Kumar Mrutyunjay51, if this helps please login to Mark As Answer. \| Alert Moderator

you can use bulkcopy insert

e.g
Dim sqlbulkSubt As New SqlBulkCopy(con)
sqlbulkSubt.DestinationTableName = "your Database table name"
sqlbulkSubt.ColumnMappings.Add("Column_Source", "Column_destination")
sqlbulkSubt.ColumnMappings.Add("Column_Source", "Column_destination")
sqlbulkCert.WriteToServer(Your Source table name)

Deepak Kumar

Mrutyunjay51, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Lakhwinder.ghuman on: 5/23/2011 [Member] Starter | Points: 25

0	Hi You can use SqlBulkCopy ti insert data from datatable to database. Best Regards Lakhwinder Ghuman Mrutyunjay51, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts