Guid handling

[Igor]

Hi

I have a drop down list on my page that lists some items returned from a
database. Each item has its GUID (or uniqueidentifie r). I have to (in code
behind of the page) read this GUID, to hand it over to a query (stored
procedure) that takes the GUID and looks for some data in a specific table.
I don't know have to hand it to the query as GUID.

SqlCommand myCommand = new SqlCommand();
myCommand.Conne ction = myConnection;

myCommand.Comma ndText = "dbo.tbh_GetBou ndIdentifier";
myCommand.Comma ndType = CommandType.Sto redProcedure;

string BoundID =
DropDownList4.S electedItem.Val ue.ToString();

SqlParameter myParameter1 = new SqlParameter();
myParameter1.Pa rameterName = "@BoundID";
myParameter1.Sq lDbType = SqlDbType.Uniqu eIdentifier;
myParameter1.Va lue = BoundID;

SqlParameter myParameter2 = new SqlParameter();
myParameter2.Pa rameterName = "@BoundIdentifi er";
myParameter2.Sq lDbType = SqlDbType.Char;
myParameter2.Di rection = ParameterDirect ion.Output;

myCommand.Param eters.Add(myPar ameter1);
myCommand.Param eters.Add(myPar ameter2);

myConnection.Op en();

SqlDataReader myReader = myCommand.Execu teReader();
WIth the code above I get the following error: "Failed to convert parameter
value from a String to a Guid" when trying to execute the command
myCommand.Execu teReader();. How can I handle (or convert) the GUID so it is
handed as GUID and not as a string?

[Igor]

Found solution myself:

Guid BoundID = new Guid(DropDownLi st4.SelectedIte m.Value.ToStrin g());
Regards
"Igor" <ig***@live.com wrote in message
news:E5******** *************** ***********@mic rosoft.com...

Hi

I have a drop down list on my page that lists some items returned from a
database. Each item has its GUID (or uniqueidentifie r). I have to (in code
behind of the page) read this GUID, to hand it over to a query (stored
procedure) that takes the GUID and looks for some data in a specific
table. I don't know have to hand it to the query as GUID.

SqlCommand myCommand = new SqlCommand();
myCommand.Conne ction = myConnection;

myCommand.Comma ndText = "dbo.tbh_GetBou ndIdentifier";
myCommand.Comma ndType = CommandType.Sto redProcedure;

string BoundID =
DropDownList4.S electedItem.Val ue.ToString();

SqlParameter myParameter1 = new SqlParameter();
myParameter1.Pa rameterName = "@BoundID";
myParameter1.Sq lDbType = SqlDbType.Uniqu eIdentifier;
myParameter1.Va lue = BoundID;

SqlParameter myParameter2 = new SqlParameter();
myParameter2.Pa rameterName = "@BoundIdentifi er";
myParameter2.Sq lDbType = SqlDbType.Char;
myParameter2.Di rection = ParameterDirect ion.Output;

myCommand.Param eters.Add(myPar ameter1);
myCommand.Param eters.Add(myPar ameter2);

myConnection.Op en();

SqlDataReader myReader = myCommand.Execu teReader();
WIth the code above I get the following error: "Failed to convert
parameter value from a String to a Guid" when trying to execute the
command myCommand.Execu teReader();. How can I handle (or convert) the GUID
so it is handed as GUID and not as a string?