简单问题,看看有什么错误? 关于OleDbCommand 查询的问题,说完就给分!
s = "192.168.1.6";
strExpress = "Select * from data_info order by user_ip";//where user_ip = '·ip'
OleDbCommand cmm = new OleDbCommand(strExpress,f.ConnectToDb());
//cmm.Parameters.Add("·ip",OleDbType.VarChar,15);
//cmm.Parameters["·ip"].Value = s;
OleDbDataReader dataReader = cmm.ExecuteReader();
if(!dataReader.HasRows)
{}
else
{
do
{
Console.WriteLine("\t{0}\t{1}\n", dataReader.GetName(0), dataReader.GetName(1));
while (dataReader.Read())
Console.WriteLine("\t{0}\t{1}\n", dataReader.GetString(0), dataReader.GetString(1));
} while (dataReader.NextResult());
}
dataReader.Close();
加上//后面的语句就什么也查不到!,大家帮忙看看什么问题?