Bronco Solutions

Knowledge Management and Collaboration Platform
Welcome to Bronco Solutions Sign in | Join | Help
in Search

Andrew Renner

SqlDataSource uniqueidentifier Parameter

UniqueIdentifier parameters by default are coded like this

<asp:Parameter Name="Original_EventID" Type="Object" />

The problem is that this cause the following error:

Implicit conversion from data type sql_variant to uniqueidentifier is not allowed. Use the CONVERT function to run this query.

To correct this simply remove the Type so it looks like this:

<asp:Parameter Name="Original_EventID" />

Published Sunday, July 09, 2006 1:53 PM by rennera
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Alexandros Ilatzis said:

the error stopped from showing but the update doesn't work properly it returns the record uncontacted

September 18, 2009 2:02 AM
 

Alexandros Ilatzis said:

it works if a disable the use of optimistic concurrency strange things

September 18, 2009 2:13 AM

Leave a Comment

(required) 
(optional)
(required) 
Submit