Home All Groups Group Topic Archive Search About
Author
20 Jan 2006 12:35 AM
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

Author
20 Jan 2006 9:10 AM
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.)



--------------------
Show quoteHide quote
| Thread-Topic: GUID and data controls
| thread-index: AcYdWVpPdJguwG/vR9eNvPLB9N9cng==
| X-WBNR-Posting-Host: 65.35.95.187
| From: "=?Utf-8?B?VGRhclRkYXI=?=" <Tdar@noemail.nospam>
| Subject: GUID and data controls
| Date: Thu, 19 Jan 2006 16:35:03 -0800
| Lines: 18
| Message-ID: <327FE30A-7986-4FEA-BD11-86E9095DE***@microsoft.com>
| 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
Show quoteHide quote
| 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
|
|
Author
20 Jan 2006 6:30 PM
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.


Show quoteHide quote
"Steven Cheng[MSFT]" wrote:

> 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=?=" <Tdar@noemail.nospam>
> | Subject: GUID and data controls
> | Date: Thu, 19 Jan 2006 16:35:03 -0800
> | Lines: 18
> | Message-ID: <327FE30A-7986-4FEA-BD11-86E9095DE***@microsoft.com>
> | 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
> |
> |
>
>