Download
100% FREE
Office Document APIs for .NET
Online: 967
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Bookmarks
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Forums
>
ASP.NET
>
Loading ...
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
|
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
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
Login to post response
Latest Posts
What to do when Adobe reader installation failed?
(0)
New
How to Find count Details Sql server
(0)
sharepoint installation system requirements
(0)
Web Api not working with mvc
(1)
How to get label text from table reference on database based on TableName and FieldName
(0)
How can i refresh Page after downloading a file in MVC ?
(1)
sql server dba interview questions
(1)
How to change json data while making click in AngularJs
(1)
More ...