Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Stored Procedure and Dataform Webpart
2 views
Skip to first unread message
obiewon
Nov 12, 2009, 5:36:03 PM11/12/09
to
I am attempting to use an SQL 2005 stored procedure that accepts a number of
parameters. I want the parameters to be those that I have defined in the
Dataform webpart. Everytime I specify a parameter, however, the webpart is
unable to render the returned data. I have verified the operation of my
stored procedure and know it to work. The only time I can get the webpart to
work with the stored procedure is if I statically assign the parameters as in
below:
parameters. I want the parameters to be those that I have defined in the
Dataform webpart. Everytime I specify a parameter, however, the webpart is
unable to render the returned data. I have verified the operation of my
stored procedure and know it to work. The only time I can get the webpart to
work with the stored procedure is if I statically assign the parameters as in
below:
SelectCommand=dbo.sp_LOGONSTATDETAIL '-1','100','*','=','*','=','=',''
SelectCommandType=Text
Changing to
SelectCommand=dbo.sp_LOGONSTATDETAIL
@Param1,@Param2,@Param3,@Param4,@Param5,@Param6,@Param7,@Param8
SelectCommandType=Text
Fails. Changing SelectCommandType to StoredProcedure also fails
How the heck to you get StoredProcedures to work with the DataForm Webpart
in WSS 3.0?
0 new messages