标准数据类型不匹配

[jiangfan99]

string myConn1 = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = '../../hx.mdb'";
OleDbConnection myConn = new OleDbConnection(myConn1);
myConn.Open();
string strselect = "select * from information where hx_id=" + “‘tx_id.Text’”;
OleDbCommand inst = new OleDbCommand(strselect, myConn);
OleDbDataReader reader;
reader = inst.ExecuteReader();

执行到ExecuteReader（）提示标准数据类型不匹配，数据库中hx_id定义的是文本类型，数据库中有hx_id=123，而我在tx_id中输入123的时候，reader返回的是空，问题是在哪里？？

[ms44]

加个'在123两边。

[symbol441]

string   strselect   =   "select   *   from   information   where   hx_id='"+tx_id.Text+"’”; 

[yqlvcxl_2007]

string strselect = "select * from information where hx_id=" + “‘tx_id.Text’”; 写错了
string strselect = "select * from information where hx_id='" + tx_id.Text+"'";

[symbol441]

//怎么还是有全角符号

string   strselect   = string.Format("select * from information where hx_id='{0}'",tx_id,Text); 

[yqlvcxl_2007]

string strselect = "select * from information where hx_id=" + “‘tx_id.Text’”;
写错了
string strselect = "select * from information where hx_id='" + tx_id.Text+"'";

[jiangfan99]

谢谢，解决了