HEXAQ : A friendly question - answer site for IT professionals

asp.net - How to pass .net Dataset as an parameter in SQL stored procedure?


0

I have a dataset with many columns (68) and rows (1534) that I have to pass to my stored procedure so I can insert those all records in my database.

I dont want to loop each row in .net coz it will reduce the site speed.

Is there any hack I can easily insert these all rows with faster performance?

Â
asked
 


≡ Total 1 Answer

0

You can pass it as XML string.

Google something about passing XML string as parameter in SQL Stored Procedure.

Â
replied


Enter your reply here
Answer Preview: