mydb thedb = new mydb();
MyGlobal oapp = new MyGlobal();
//define the reader
System.Data.OleDb.OleDbDataReader theReader = null;
//defining sql
string _sql = "SELECT * FROM searchtest WHERE ID = " + _ddsearch;
string _sqlupdate = "";
//execute the reader
theReader = thedb.SQLExecute_Reader(_sql);
this code is try to grab the value from _ddsearch variable
if the value is number it works
but if it is string, theReader return null
this is the problem string _sql = "SELECT * FROM searchtest WHERE ID = " + _ddsearch;
the code above is for number
how do you make ID = " + _ddsearch;
to get variable value as string
I try to put another qutation mark but it is still wrong