62,074
社区成员
发帖
与我相关
我的任务
分享
public static OleDbDataReader getRead(string sql)//返回一个数据集
{
OleDbDataReader myReader = null;
try
{
OleDbCommand myCommand = new OleDbCommand(sql, con);
Open();
myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
Close();
}
catch (Exception ex)
{
Close();
myReader = null;
}
finally
{
Close();
}
return myReader;
}
OleDbDataReader myReader = getRead(“select * from table”);
if (myReader.Read())//当程序走到这里时提示说:阅读器关闭时 Read 的尝试无效。
{
tbUserName.Text = myReader.GetString(0);
tbName.Text = myReader.GetString(1);
tbTel.Text = myReader.GetString(2);
tbMobile.Text = myReader.GetString(3);
tbMail.Text = myReader.GetString(4);
}
if(myReader!=null)
{
if (myReader.Read())//当程序走到这里时提示说:阅读器关闭时 Read 的尝试无效。
{
tbUserName.Text = myReader.GetString(0);
tbName.Text = myReader.GetString(1);
tbTel.Text = myReader.GetString(2);
tbMobile.Text = myReader.GetString(3);
tbMail.Text = myReader.GetString(4);
}
}