Adding parameter to sqldatasource, How should i pass them to execute my stored procedure in asp.net

Question

I am using a gridview where i am calling a stored procedure which has 4 input parameters.

Out of these 4 parameters, values are to be given such that

DomainId = This has to be the row which is to be deleted. This is a primary key

Domain = This field has to be passed to SP as NULL.

Description= This field has to be passed as NULL.

OperationType= This field has to be passed by programmer as some static value say 4

How to i need to specify these here...

More details of the Question are here.

Please help me out.

<DeleteParameters>
                        <asp:ControlParameter ControlID="GridView1" Name="DomainId" 
                            PropertyName="SelectedValue" Size="4" Type="Int32" />  
                        <asp:Parameter DefaultValue="" Name="Domain"  Size="16" Type="String" />
                        <asp:Parameter DefaultValue="" Name="Description" Type="String" />
                        <asp:Parameter DefaultValue="4" Name="OperationType" Type="Byte" />
                    </DeleteParameters>

On running my code using this

I gets an error

Procedure or Function 'spOnlineTest_Domain' expects parameter '@Domain', which was not supplied

clyc · Accepted Answer · 2010-03-02 19:14:14Z

2

you would need to prefix your parameter name with a "@"

your parameters would look like this instead.

<asp:Parameter DefaultValue="" Name="@Domain"  Size="16" Type="String" />
<asp:Parameter DefaultValue="" Name="@Description" Type="String" />
<asp:Parameter DefaultValue="4" Name="@OperationType" Type="Byte" />

answered Mar 2, 2010 at 19:14

clyc

2,45014 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

clyc Over a year ago

If you are passing in null for those two parameters (@Domain, @Description), try removing the @Domain and @Description parameters.

Collectives™ on Stack Overflow

Adding parameter to sqldatasource, How should i pass them to execute my stored procedure in asp.net

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related