连接ACCESS数据库没问题,SQL语句直接在ACCESS里用也没问题,但放到C#.NET中就查不到——myReader.Read()返回false请高手帮忙指点指点,谢谢!string sql_select = "SELECT * from topic WHERE TopicBody like '*具体文本内容*'
OleDbCommand cmd_select = new OleDbCommand(sql_select,Conn1);
OleDbDataReader myReader = cmd_select.ExecuteReader();
OleDbCommand cmd_select = new OleDbCommand(sql_select,Conn1);
OleDbDataReader myReader = cmd_select.ExecuteReader();
对于access,是使用"*"来进行模糊查询的,
string sql_select = "SELECT * from topic WHERE TopicBody like '*具体文本内容*'"
conn.Open();
string strSQL = "查询语句";
OleDbCommand comm = new OleDbCommand(strSQL, _conn);OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = comm;
da.Fill( 数据表DataTable );
string sql_select = "SELECT * from [topic] WHERE TopicBody like '*具体文本内容*'";
SqlConnection con = new SqlConnection(Con);
con.Open();
SqlCommand cmd1=new SqlCommand("SELECT * from topic WHERE TopicBody like '*具体文本内容*'",con);
SqlDataReader myReader=cmd1.ExecuteReader();
if(myReader.Read())
{
L1.Text=myReader["warning"].ToString().Trim();
}
myReader.Close();
如果是asp里头去查询access,8要改成%