SqlDataSource with Guid Parameter

Question

I have this sqlDataSource
@userId is my parameter for Current user in a system .

<asp:SqlDataSource ID="dsProfit" runat="server" ConnectionString="<%$ ConnectionStrings:DefaultConnection %>" SelectCommand="select name, sum(value) as suma  from AllProfitView where IdUser=@userId group by name  order by sum(value) desc">

</asp:SqlDataSource>

In code Behind I have this in Page_Load :

 dsProfit.SelectParameters.Add("@userId", cui.getCurrentId());




 public Guid getCurrentId()
        {
            MembershipUser currentUser = Membership.GetUser();
            Guid currentUserId = (Guid)currentUser.ProviderUserKey;
            return currentUserId;
        }

when start the page it's blows with ERROR :Must declare the scalar variable "@userId".

zey · Accepted Answer · 2013-07-27 10:32:03Z

1

Add SelectParameter to your sqlDataSource

<asp:SqlDataSource ID="dsProfit" runat="server"  
ConnectionString="<%$ ConnectionStrings:DefaultConnection %>"  
SelectCommand="select name, sum(value) as suma  from AllProfitView  
where IdUser=@userId group by name  order by sum(value) desc">
    <SelectParameters>
        <asp:Parameter Name="userId" Type="String" />
    </SelectParameters>
</asp:SqlDataSource>

and assign likes this

  dsProfit.SelectParameters["userId"].DefaultValue =  
  cui.getCurrentId().ToString();

edited Jul 27, 2013 at 10:32

answered Jul 27, 2013 at 10:13

zey

6,14315 gold badges65 silver badges112 bronze badges

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

3 Comments

Tedi Hadjieva Over a year ago

dsProfit.SelectParameters["userId"].DefaultValue =cui.getCurrentId(); - Cannot convert guid to string

zey Over a year ago

add Type="Int32" and par your GUID to integer Tedi , I've edited my answer !

Tedi Hadjieva Over a year ago

still cannot implicityconvert int to string

Kemal Umut · Accepted Answer · 2013-07-27 10:25:38Z

0

try to define selectparameter inside of your SqlDatasource

<asp:SqlDataSource ID="dsProfit" runat="server" ConnectionString="<%$ ConnectionStrings:DefaultConnection %>" SelectCommand="select name, sum(value) as suma  from AllProfitView where IdUser=@userId group by name  order by sum(value) desc">
<SelectParameters>
            <asp:Parameter Name="userId" Type="int32" />
</SelectParameters>

</asp:SqlDataSource>

so your parameter is int so convert it to string

 dsProfit.SelectParameters["userId"].DefaultValue = cui.getCurrentId().toString();

edited Jul 27, 2013 at 10:25

answered Jul 27, 2013 at 10:13

Kemal Umut

231 silver badge9 bronze badges

1 Comment

zey Over a year ago

I think , not QueryStringParameter Kemal :) It just get value from query string . But OP want to assign it from code behind .

Collectives™ on Stack Overflow

SqlDataSource with Guid Parameter

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related