Failed to convert parameter value from string to guid

asp.net n-tier-architecture tableadapter
user1404780 picture user1404780 · Oct 10, 2012 · Viewed 11.6k times · Source

I have a tiered application. The datalayer makes a call to the database by using a dataset which contains a tableadapter. In the database table there is a field called ID of type UniqueIdentifier. I then create the following query:

select * from tbl where ID=@ID

When i try to preview the results in the dataset designer i receive the error "Failed to convert parameter value from string to guid".

I tried adding single quotes around the value passed in but didnt work.

Where am i going wrong?

Answer

Aghilas Yakoub picture Aghilas Yakoub · Oct 10, 2012

Your column ID is Guid type in your database, but your parameter is a string.

You can convert your parameter to a SqlGuid:

command.Parameters.Add("@GuidParameter", SqlDbType.UniqueIdentifier).Value = new System.Data.SqlTypes.SqlGuid(YourGuid); //The value of @ID

Link : https://msdn.microsoft.com/library/system.data.sqltypes.sqlguid.aspx?f=255&MSPPError=-2147217396

Related questions

populate dropdown list from a list of objects

In an attempt of building a 3-tier architecture c# asp.net application, I've started building a class that is database which is used for the connecting to the database, another class that is City which has a method for each …

Read More
Change the selected value of a drop-down list with jQuery

I have a drop-down list with known values. What I'm trying to do is set the drop down list to a particular value that I know exists using jQuery. Using regular JavaScript, I would do something like: ddl = document.getElementById("…

Read More
How to get the URL of the current page in C#

Can anyone help out me in getting the URL of the current working page of ASP.NET in C#?

Read More