ASP.NET

insert into database table from datatable RSS

5 replies

Last post May 18, 2012 08:30 AM by Abhay Shah

‹ Previous Thread|Next Thread ›

- Reply
santosh.megh...

Member

1 Points

4 Posts

insert into database table from datatable

May 18, 2012 06:06 AM|LINK

hi all,

I have a data table in c# which i want to insert into the table in database.

is there any way to do this?
- Reply
Abhay Shah

Member

214 Points

47 Posts

Re: insert into database table from datatable

May 18, 2012 06:11 AM|LINK

Following link may be useful to you.

http://www.codeproject.com/Articles/30722/How-to-save-data-from-a-DataSet-into-a-T-SQL-table

http://blogs.msdn.com/b/nikhilsi/archive/2008/06/11/bulk-insert-into-sql-from-c-app.aspx

Regards,
Abhay

Please mark this reply as 'Answer', if my reply has assisted you.
- Marked as answer by santosh.meghana on May 18, 2012 12:05 PM
- Reply
me_ritz

Star

9339 Points

1448 Posts

Re: insert into database table from datatable

May 18, 2012 06:13 AM|LINK

If you are using SQL 2008

http://www.microsoftdevelopersolutions.blogspot.in/2012/01/insert-multiple-rows-into-table.html

If you are using SQL 2000

http://www.microsoftdevelopersolutions.blogspot.in/2012/01/insert-multiple-rows-into-table-in-sql.html

Thanks

Please mark the post as "Answer" that helps you.
- Reply
santosh.megh...

Member

1 Points

4 Posts

Re: insert into database table from datatable

May 18, 2012 07:12 AM|LINK

hey Abhay,

thanks a lot!! The Code project link was useful but i cannot create any stored Procedures. is tehr a way to do this from the .net side itself?
- Reply
me_ritz

Star

9339 Points

1448 Posts

Re: insert into database table from datatable

May 18, 2012 08:22 AM|LINK

Already solved thread:

http://forums.asp.net/t/1278427.aspx/1

Thanks

Please mark the post as "Answer" that helps you.
- Reply
Abhay Shah

Member

214 Points

47 Posts

Re: insert into database table from datatable

May 18, 2012 08:30 AM|LINK

You can use inline query also like : INSERT INTO ..........

Regards,
Abhay

Please mark this reply as 'Answer', if my reply has assisted you.