Re: SqlCommandBuilder.DeriveParameters not working for CLR Stored Procedure.
- From: "William \(Bill\) Vaughn" <billvaRemoveThis@xxxxxxxxx>
- Date: Tue, 10 Apr 2007 08:22:27 -0700
Ah, I'm not surprised that the CB can't interface with a CLR executable.
It's really designed to build the CRUD for specific data tables, not rowsets
returning from SPs.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
"Vimal" <mailtovimal@xxxxxxxxx> wrote in message
news:1176197632.136938.58410@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,
I have created a CLR stored procedure and want to call it using Data
Access Application block provided by Microsoft. But in this
application block when method tried to derive SP's paramter using
SqlCommandBuilder.DeriveParameters, it throws
InvalidOperationException and give error message "The stored procedure
<SPName> does'nt exist".
Please provide me insight to solve this problem.
Thanks in advance.
Vimal
.
- Follow-Ups:
- References:
- Prev by Date: Re: DateTime column.
- Next by Date: Re: OrderID or DataTable
- Previous by thread: SqlCommandBuilder.DeriveParameters not working for CLR Stored Procedure.
- Next by thread: Re: SqlCommandBuilder.DeriveParameters not working for CLR Stored Procedure.
- Index(es):
Relevant Pages
|
