What is the datatype of PostedBy in the database?

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Hello,

The Datatype is nvarchar MAX

Doesn't this give you a clue?

The dat type in the database doesn't match the one in the ASPX page. ProviderUserKey is a Guid so you should store it as a Guid (a Uniqueidentifier) in the database.

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Hello Imar,

I have another question. I've edited all the necessary things in the database and page. but i'm having trouble with this line in the Edit Command:

 Dim postedBy As Guid = Convert.(e.CommandArgument)

I can't figure out how to convert the Guid. Its undet the BlogEntyries.vb

You can't "convert" a string to a Guid, you'll need to create a new one based on the string. E.g.:

Dim myGuid As Guid = New Guid(SomeString)

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Hello,

What do I put in the place of (SomeString)

Hmmm, isn't that obvious from the previous discussion?

What does Visual Web Developer's IntelliSense tell you when you press the ( for New Guid( ??

The constructor for the Guid expects a string that *looks like* a Guid, so it can create a new one based on that.

In your case, isn't it obvious what you need to pass and isn't it what you almost posted in your previous message? What is it that you're trying to *convert* to a Guid? I'd say it's e.CommandArgument which should hold the Guid from the database, converted as a string....

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.