Re: Query-designer question

Ofer wrote:
Hi,

We use a SQL-server stored-procedure to update a table, we generate
the SP automatically in Visual-Studio 2005's query designer.

The UI grid can return a typed data-row on user updates.

How to send the SP a typed data row instead of the many single
parameters? Can the query designer automatically create such a
function ?

You can't, and no. Stored procedure parameters are limited to the datatypes
intrinsic to Transact-SQL.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.