Working with UniqueIdentifier field (UserID)

[Andel]

I ceated a table with a UserID field. This is a uniqueidentifier type field. (I would use this as foreign key of the UserID from aspnetdb..aspnet_users table.)

The problem is that I can't figure out how to insert data in it. Here's my current code.

     Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click

        'get user id
        'if user is not logged in then exit sub

        Dim CurrentUser As Guid
        Dim theUser As MembershipUser = Membership.GetUser()
        If theUser Is Nothing Then
            lblMessage.Text = "You need to log in first."
            Exit Sub
        Else
            CurrentUser = theUser.ProviderUserKey
        End If

        'insert data
        SqlDataSource1.InsertParameters("UserID").DefaultValue = CurrentUser [b]'(THIS WON'T WORK)[/b]
        SqlDataSource1.InsertParameters("CategoryID").DefaultValue = drpCategoryID.DataValueField
        SqlDataSource1.InsertParameters("Title").DefaultValue = txtTopicTitle.Text
        SqlDataSource1.InsertParameters("Details").DefaultValue = txtTopicDetails.Text

    End Sub

The first line under 'insert data' gives me this error: Value of type 'System.Guid' cannot be converted to 'String'.

I would appreciate any help.

Thanks.

 

[Warlocks]

Hi,

GUIDs are quite a unique datatype (if you pardon the pun!).
Although they are Unique Identifiers, they are also represented as a string. This is why you are getting the error that you are.

Convert the GUID to a string and insert that instead. This should work.
Are you using Stored Procedures to insert your data and if so, have you tested the SP from within SQLServer (assuming you are using SQLServer)? If you have, you will have probably tested by enclosing the GUID in single quotes hence making it a string that you are passing in.

 

[Andel]

I'm using the above code to insert my data.

I tried converting it to a string but it gave me different error.

Can you please give me an example?

 

[jbenson001]

Is UserID a GUID in your sql table? if so, maybe the value you are trying to assing to the variable is a string and not a guid.. I suggest stepping through your code.