using System.Data; using System.Data.OleDb; OleDbConnection thisConnection = new OleDbConnection( //数据库路径 string strCom = "select * from account where uid = '" + strUid + "' and pwd = '" + strPwd + "'"; (这两句都可以执行sql语句) thisConnection.Close(); 将下划线部分替换为: OleDbDataReader thisReader = thisCommand.ExecuteReader(); if(thisReader.HasRows) { } 或者 if(thisReader.Read()) { string strLevel = thisReader["level"].ToString(); } OleDbDataReader 中的bool类型HasRows属性可以判断查询结果是否为空. thisReader["列名"] 可显示查询出的该列数据. C# 怎么从OleDbDataReader里读数据?string ID=reader["ID"].ToString(); |
|