By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,491 Members | 1,191 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,491 IT Pros & Developers. It's quick & easy.

System.Data.DataTable

P: n/a
hey

asp.net 2.0

Is it possible to send a System.Data.DataTable as a input parameter to a
stored procedure (MS Sql Server)?

Jeff
Aug 6 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Jeff,
No, not directly. However if you look at the SqlDataAdapter class, it sports
an Update method that will accept your datatable, and provided that there are
correct select, update, insert and delete commands (can be stored procedures)
for it, you have accomplishes essentially what you describe.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Jeff" wrote:
hey

asp.net 2.0

Is it possible to send a System.Data.DataTable as a input parameter to a
stored procedure (MS Sql Server)?

Jeff
Aug 6 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.