Operand type clash: uniqueidentifier is incompatible with numeric

Mike Jonson

I have create next Method and every time error: Operand type clash: uniqueidentifier is incompatible with numeric. I vant undestand why. Please help.

public object GetCredits(string idDebitor)
        {
            ArrayList allCredits = new ArrayList();

            using (SqlConnection con = new SqlConnection(conectionString)) //???????????? ? ??
            {
                string query = string.Format("select * from Credits where DebitorID={0}", idDebitor);
                SqlCommand com = new SqlCommand(query, con); //??????? ???????? ???????
                //try
                {
                    con.Open(); //????????? ??????????

                    SqlDataReader dr = com.ExecuteReader(); //????????? ?????? ?? ??????? ? ?????????? dr
                    if (dr.HasRows) //???? ??????? ?? ??????, ????????? ? ??????
                        foreach (DbDataRecord result in dr)
                            allCredits.Add(result);
                }
                //catch
                { }
            }
            return allCredits;
        }

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pradeep Chandraker15y ago
Thanks for sharing.
0
Mike Jonson15y ago
musst: select * from Credits where DebitorID='{0}'", idDebitor
0
Mike Jonson15y ago
have found error. Must in add in ' ', becose its not numeric format. Now all work, thanks for you help)
0
Pradeep Chandraker15y ago
The uniqueidentifier accepts only GUID format. If you don't want to pass GUID, you will have to change datatype in database.
0
Mike Jonson15y ago
but i have fields debitorID of table is type uniqueidentifier. And now write Incorrect syntax near 'dbbec9c'. I need without GUID
0
Pradeep Chandraker15y ago
The value of idDebitor should be GUID. You can set.

idDebitor = Guid.NewGuid().ToString()
0
Mike Jonson15y ago
table field debitorID has type uniqueidentifier.
I entered manually this number in debitorID: 12321234-1232-1232-2343-343432783562

0
Pradeep Chandraker15y ago
Converting GUID to numeric will not work in this case. Check if you have some column declared as uniqueidentifier and passing int value.
0
Suthish Nair15y ago

Am not sure, string idDebitor this must be a int datatype in DB Table and you are passing string value.

Can you explain, what you are doing. Any insertion happening before for this select statement?

0