An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
COURSE of the MONTH
9 days, 15 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Conversion failed when converting from a character string to uniqueidentifier.
Posted on 2009-05-07
I am trying to pass a parameter from ASP.NET to a SQL Server Stored procedure.
string strUserID = currentUser.ProviderUserKe
Returns "ba275a68-9e77-4301-9d97-7
SqlCommand cmd = new SqlCommand("usp_addWatchLi
cmd.Parameters.Add("@UserI
cmd.ExecuteNonQuery();
Conversion failed when converting from a character string to uniqueidentifier.
---------
Stored procedure executes successfully from SQL Server Manager
ALTER PROCEDURE [dbo].[usp_addWatchList]
@SymbolID int,
@UserID varchar(50)
/*
exec usp_addWatchList
@SymbolID =329,
@UserID = 'BA275A68-9E77-4301-9D97-7
*/
What am I missing?
Thanks,
string strUserID = currentUser.ProviderUserKe
Returns "ba275a68-9e77-4301-9d97-7
SqlCommand cmd = new SqlCommand("usp_addWatchLi
cmd.Parameters.Add("@UserI
cmd.ExecuteNonQuery();
Conversion failed when converting from a character string to uniqueidentifier.
---------
Stored procedure executes successfully from SQL Server Manager
ALTER PROCEDURE [dbo].[usp_addWatchList]
@SymbolID int,
@UserID varchar(50)
/*
exec usp_addWatchList
@SymbolID =329,
@UserID = 'BA275A68-9E77-4301-9D97-7
*/
What am I missing?
Thanks,
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
2
5 Comments
when adding the parameter it should be passed as SqlDbType.UniqueIdentifier
Like this:
cmd.Parameters.Add("@UserI
Like this:
cmd.Parameters.Add("@UserI
sorry - don't think I read it properly - the other problem you could be having is it not putting the value into the parameter right. I always add parameters like this:
cmd.Parameters.AddWithValu
I've had problems in the past the other way where the value was not actually stored in the parameter object properly.
cmd.Parameters.AddWithValu
I've had problems in the past the other way where the value was not actually stored in the parameter object properly.
one final thing - it could be in the stored proc when you compare the table field to @UserID - if the table field is a UniqueIdentifier that will fail. Change the parameter in the stored proc to a UniqueIdentifier and add the parameter as System.UniqueIdentifier
Theres a few things to look at anyway :)
Theres a few things to look at anyway :)
I set everything to uniqueidentifier.
Error: Failed to convert parameter value from a String to a Guid.
Also tried cmd.Parameters.AddWithValu
Error:Conversion failed when converting from a character string to uniqueidentifier.
Error: Failed to convert parameter value from a String to a Guid.
Also tried cmd.Parameters.AddWithValu
Error:Conversion failed when converting from a character string to uniqueidentifier.
I set everything to uniqueidentifier.
AND
Also tried cmd.Parameters.AddWithValu
AND changed the sp from this:
INSERT INTO WatchList
(UserID,SymbolID,PickDateP
VALUES('@UserID',@SymbolID
To this:
INSERT INTO WatchList
(UserID,SymbolID,PickDateP
VALUES(@UserID,@SymbolID,2
Now it works.
Thanks
AND
Also tried cmd.Parameters.AddWithValu
AND changed the sp from this:
INSERT INTO WatchList
(UserID,SymbolID,PickDateP
VALUES('@UserID',@SymbolID
To this:
INSERT INTO WatchList
(UserID,SymbolID,PickDateP
VALUES(@UserID,@SymbolID,2
Now it works.
Thanks
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Sometimes in DotNetNuke module development you want to swap controls within the same module definition. In doing this DNN (somewhat annoyingly) swaps the Skin and Container definitions to the default admin selections. To get around this you need t…
Today is the age of broadband. More and more people are going this route determined to experience the web and it’s multitude of services as quickly and painlessly as possible. Coupled with the move to broadband, people are experiencing the web via …
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…
Suggested Courses
Course of the Month9 days, 15 hours left to enroll
762 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.