what type of variable for a UniqueIdentifier field?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bart - 17 Feb 2008 16:54 GMT

Hi,

i made a select which fetches the value of a UniqueIdentifier field
(aspnet_Roles.RoleId )
my questions are:
1) variable 'myrole' must be defined as what?
2) myrole=dtreader.Get??

Thanks
Bart

dim myrole as ???
comd.CommandText = "select aspnet_Roles.RoleId from aspnet_roles"
connection.Open()
dtreader = comd.ExecuteReader
dtreader.Read()
myrole = dtreader.Get???

Reply to this Message

Bart - 17 Feb 2008 17:52 GMT

i found it:

Dim rid As System.Guid
dtreader.GetGuid(0)

Reply to this Message

Mark Fitzpatrick - 17 Feb 2008 17:55 GMT

A uniqueidentifier is a Globally Unique Identifier, which is a System.Guid
data structure. I think you would use GetGuid() with the sql data reader.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - Expression

> Hi,
>
[quoted text clipped - 13 lines]
> dtreader.Read()
> myrole = dtreader.Get???

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...