Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-07 : 07:47:13
|
| jay writes "Can a dataset (ado.net type) be passed as an input parameter to a stored procedure (sql2k)? if not, is there another way to pass an 'array of data' to a stored procedure as an input parameter from an ado.net object? thanks, jay schumacher" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-07 : 07:49:39
|
| Yes, you can pass multiple data items as a CSV to a stored procedure and parse them out. See these articles:http://www.sqlteam.com/SearchResults.asp?SearchTerms=csvI have done this in regular ASP, where I had data in an array. I converted it to a CSV using the Join method, and then passed it to a SQL Server procedure. I don't know if the .Net languages have a similar Join method but it should be very easy to convert a data set into a CSV. |
 |
|
|
|
|
|
stored proc input parameter