求助大神,为什么远程连接Access数据库后,断开网络,执行查询后依然有数据
用的是VS2008,远程连接Access2003数据库,连接成功后,我将网络连接禁用,然后发现没有报错,我用断点查的时候发现执行查询语句还能查询出数据,奇怪,不是断开了吗?为什么还有数据
public DataTable Mydatatable(string s3) { DataTable inv = new DataTable(); inv.Clear(); try { ReConnection(); if (sqlcn.State == ConnectionState.Open) { using (SqlCommand sqlcom3 = new SqlCommand(s3, this.sqlcn)) { SqlDataReader sdr = sqlcom3.ExecuteReader(); inv.Load(sdr); sqlcom3.Dispose(); sdr.Dispose(); sdr.Close(); } } else if (olecn.State == ConnectionState.Open) { using (OleDbCommand olecom2 = new OleDbCommand(s3, this.olecn)) { OleDbDataReader oledr = olecom2.ExecuteReader(); inv.Load(oledr); olecom2.Dispose(); oledr.Dispose(); oledr.Close(); } } errflag = false; return inv; } catch(Exception err) { errflag = true; return inv; throw err; } }
DataTable dt1 = new DataTable();select_st1 = "select ScTime from sRecords where ScTime in (select max(ScTime) from sRecords)";dt1 = access_con1.Mydatatable(select_st1);DataTableReader dbreader = new DataTableReader(dt1);dbreader.Read();st1 = Convert.ToString(dbreader.GetValue(dbreader.GetOrdinal("ScTime")));