Problem with sqldatasource when passing parameters

Question

Part of the sqldatasource parameters:

            <asp:SqlDataSource ID="AllQuestionAskedDataSource" runat="server" 
                ConnectionString="<%$ ConnectionStrings:CP_AllQuestionsAnswered %>" SelectCommand="SELECT ThreadTitle
FROM Threads
WHERE UsersID=@UserID">
                <SelectParameters>
                    <asp:Parameter Name="UserID" />
                </SelectParameters>
            </asp:SqlDataSource>

The code behind:

 Guid userid = UsefulStaticMethods.GetUserNameFromUserGuid(name);
 AllQuestionAskedDataSource.SelectParameters["UserID"].DefaultValue = userid;

It tells me that it cant convert userid from Guid to string. But the parameter must be a Guid for the select statement of the sqldatasource to work

What do your parameters in the <asp:SqlDataSource> look like?? — marc_s
– marc_s, Commented Jul 11, 2011 at 7:57
Yeah I see that - but inside your <asp:SqlDataSource> you should have more content - a <SelectParameters> section etc. - that's where it would be defined what data type a parameter is.... most likely, this is set to "string" while you want to pass a "guid" — marc_s
– marc_s, Commented Jul 11, 2011 at 7:58

Saanch · Accepted Answer · 2011-07-11 08:17:12Z

3

<SelectParameters>
                <asp:Parameter Name="UserID" Type="Guid"  />
     </SelectParameters>

Updated Code

<asp:Parameter Name="UserID" Type="Object" />
<asp:Parameter Name="MemberID" DbType="Guid" />

edited Jul 11, 2011 at 8:17

answered Jul 11, 2011 at 8:04

Saanch

1,8541 gold badge24 silver badges38 bronze badges

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

7 Comments

WithFlyingColors Over a year ago

Error 3 Cannot create an object of type 'System.TypeCode' from its string representation 'Guid' for the 'Type' property. D:\Documents and Settings\Dima\My Documents\Visual Studio 2010\WebSites\WebSite10\Statistics.aspx 19

WithFlyingColors Over a year ago

Type doesnt have such a property such as a Guid

Saanch Over a year ago

Can you specify the type with the corresponding namespace?

WithFlyingColors Over a year ago

Error 3 Cannot create an object of type 'System.TypeCode' from its string representation 'Guid' for the 'Type' property. D:\Documents and Settings\Dima\My Documents\Visual Studio 2010\WebSites\WebSite10\Statistics.aspx 19

WithFlyingColors Over a year ago

No!! I cant it wont let me write ..Type="System.Guid"

|

Islam Yahiatene · Accepted Answer · 2011-07-11 08:21:13Z

1

You could simply write your custom parameter:

public class UserIdParameter : Parameter
{
    protected override object Evaluate(HttpContext context, 
        System.Web.UI.Control control)
    {
        var name = GetName();
        return UsefulStaticMethods.GetUserNameFromUserGuid(name);

    }
}

<SelectParameters>
        <custom:UserIdParameter Name="UserID" />
</SelectParameters>

answered Jul 11, 2011 at 8:21

Islam Yahiatene

1,47914 silver badges27 bronze badges

Collectives™ on Stack Overflow

Problem with sqldatasource when passing parameters

2 Answers 2

7 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related