Loading

Sql C#

ilhami caliskan

I have an error with following but I can't see it.

can anybody help urgently?

text is here a string

try

{

ConnUtil connUtil = new ConnUtil();

OleDbDataReader reader = connUtil.readData("select * from Must where CompanyName = " + text);

while (reader.Read())

if text is an int then code works (CompanyName is CompanyID in that case which is an int value)

but as I turn all to a string, I have null value in reader

1 Reply

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

Vulpes12y ago
Accepted answer
If text is a string, you'll need to surround it with single quotes i.e.

text = "'" + text + "'";