Thursday 15 August 2013

SQL select statements in C# -


I have a problem facing the code below ( syntax error ). Please help me, what should I do. Thank you

Table column: PID, pAltId, pMobile, pdate, pName

variable: argID, alt_ID, p_mobile, p_date, p_Name

Statement:

  string selectStr = "select * to" + thisTable + "where pid = '' + + +" + + + + + + + + or + pAltId = "+ Alt_ID" + OR + pMobile = "+ p_mobile" + OR + pDate = "+ p_date" + OR + pName = "+ p_Name" '';    

"itemprop =" text ">

in +" where pid = '' + + "argid +" The value for PID should be in single quote or not? You have an initial ', but no end.

In addition, you are missing a number of double quote marks or they are missing the wrong place, a number of spaces, and try to start pName for 'Remember' :. "Select from" *

  string selectStr = + thisTable + "where PID =" + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + or + "pmobile = "+ P_mobile +" "+ or +" pdate = '' + p_date + "'+" + or + "pName =' '+ p_Name +' '" 

if PMobile is a string, you can type it from + "pMobile =" + p_mobile + "" to + "pMobile = '" + P_mobile + "' '' '

No comments:

Post a Comment