J
johnp
I have the following line:
string SearchValue = string.Format("Select ACCOUNTID,
ACCOUNT from ACCOUNT where ACCOUNT LIKE \'{0:#%}\' order
by ACCOUNT, SearchString.Trim()");
I have tried just about everything to insert a % into my
string. In the past this has not been an issue since I
mostly use stored procedures. I am running some test
queries on a database that I do not want to add new
stored procedures to.
SearchString comes from a text box on my test form.
The above code returns the following error:
Index (zero based) must be greater than or equal to zero
and less than the size of the argument list.
Suggestions greatly appreciated.
string SearchValue = string.Format("Select ACCOUNTID,
ACCOUNT from ACCOUNT where ACCOUNT LIKE \'{0:#%}\' order
by ACCOUNT, SearchString.Trim()");
I have tried just about everything to insert a % into my
string. In the past this has not been an issue since I
mostly use stored procedures. I am running some test
queries on a database that I do not want to add new
stored procedures to.
SearchString comes from a text box on my test form.
The above code returns the following error:
Index (zero based) must be greater than or equal to zero
and less than the size of the argument list.
Suggestions greatly appreciated.