System.Data.DataTable

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need again help with DataTable Merge 5
Winforms and SQL Threading Problem 2
Adding parameters to stored procedures 3
DatTables 4
Looping through a Datatable. 3
newbie: Need feedback about this! 3
Stored Procedures 6
unique string column on DataTable ? 6

Back
Top