GUID and data controls

[TdarTdar]

Hello,
I have a table with two GUID fields and one check box field
simple enough..
(vs 2005, asp.net 2)

I drag the table in from the connected database turn on the edit feature

I run the page and edit the record and get

"Disallowed implicit conversion from data type sql_variant to data type
uniqueidentifier, table 'SilverQueen_Main_System.dbo.TEST', column 'userif'.
Use the CONVERT function to run this query. "

I guess the wizards dont account for guid's in records, how do I fix this
and I hope microsoft fixes this part of the program soon.

Tdar

 

[Steven Cheng[MSFT]]

Hi Tdar,

Welcome. I've justed posted my further research result to your another
thread in the newsgroup:

Subject: detailsview,
Newsgroups: microsoft.public.dotnet.framework.aspnet.webcontrols

Is this problem here also associated with that problem? If it's another
separate issue, would you provide some further detailed info so that we can
have a look into it?

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)



--------------------
| Thread-Topic: GUID and data controls
| thread-index: AcYdWVpPdJguwG/vR9eNvPLB9N9cng==
| X-WBNR-Posting-Host: 65.35.95.187
| From: "=?Utf-8?B?VGRhclRkYXI=?=" <[email protected]>
| Subject: GUID and data controls
| Date: Thu, 19 Jan 2006 16:35:03 -0800
| Lines: 18
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.dotnet.framework.aspnet.webcontrols
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.dotnet.framework.aspnet.webcontrols:32653
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webcontrols
|
| Hello,
| I have a table with two GUID fields and one check box field
| simple enough..
| (vs 2005, asp.net 2)
|
| I drag the table in from the connected database turn on the edit feature
|
| I run the page and edit the record and get
|
| "Disallowed implicit conversion from data type sql_variant to data type
| uniqueidentifier, table 'SilverQueen_Main_System.dbo.TEST', column
'userif'.
| Use the CONVERT function to run this query. "
|
| I guess the wizards dont account for guid's in records, how do I fix this
| and I hope microsoft fixes this part of the program soon.
|
| Tdar
|
|

 

[TdarTdar]

I posted this in case this was found out after, The guid works fine on
the other post, so I guess this would make this post null and void.