110,500
社区成员
发帖
与我相关
我的任务
分享
public OleDbDataReader ExecuteQueryReturnReader(string sql, string connStr)
{
OleDbConnection conn = new OleDbConnection();
OleDbDataReader reader = null;
try
{
conn = new OleDbConnection(connStr);
conn.Open();
OleDbCommand command = conn.CreateCommand();
command.CommandText = sql;
reader = command.ExecuteReader();
}
catch
{
}
finally
{
if (conn != null)
conn.Close();
}
return reader;
}
string DataBase = "HCConfig.mdb";
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
+ Application.StartupPath + "//" + DataBase;
ExecSql con = new ExecSql();
string Sql= "select * form config where ID='sss'";
OleDbDataReader p = con.ExecuteQueryReturnReader(strConnection, Sql);
MessageBox.Show(p.FieldCount.ToString());