Sending variables to sqldatasource

Question

I have an sqldatasource that takes a stored procedure with a parameter..But that the stored procedure doesnt get executed...

Am I passing the parameter successfully?

SQLDataSource:

    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:CP_AllQuestionsAnswered %>" 
        SelectCommand="GetMessagesTitles" SelectCommandType="StoredProcedure">
        <SelectParameters>
            <asp:Parameter Name="Name" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>

The pageLoad code behind:

  string name = ModeratorUsefulFunctions.GetMessageUsersName(g);
    SqlDataSource1.SelectParameters.Add("@Name", name);

The stored procedure:

    ALTER PROCEDURE dbo.GetMessagesTitles

   @Name nvarchar(50)

AS
    SELECT MessageTitle, MessageID
    FROM Messages
    WHERE MessageTo=@Name

Off The Gold · Accepted Answer · 2016-02-11 16:15:46Z

1

You need to pass the parameters value instead of adding the parameter in the SQLDataSource. Since you have already added the parameter in the SelectParameters Collection, you only need to pass the value. The way you are doing, it adds another Select parameter, that's the problem.

It should be like..

string name = ModeratorUsefulFunctions.GetMessageUsersName(g);

SqlDataSource1.SelectParameters["name"].DefaultValue = name;

edited Feb 11, 2016 at 16:15

Off The Gold

1,23615 silver badges28 bronze badges

answered Jul 16, 2011 at 17:40

Muhammad Akhtar

52.2k37 gold badges142 silver badges191 bronze badges

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

1 Comment

Matrix001 Over a year ago

Thanks it worked... The 'n' should be 'N'..this corrects the situation..The answer was right..thanks

Collectives™ on Stack Overflow

Sending variables to sqldatasource

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related