如何关闭connection连接,
我是这样调用的
OracleDataReader dr = DbHelperOra.ExecuteReader(querysql);
while (dr.Read())
{
txtmatecode.Text = dr.GetString(0); } dr.Close();
我是这样调用的
OracleDataReader dr = DbHelperOra.ExecuteReader(querysql);
while (dr.Read())
{
txtmatecode.Text = dr.GetString(0); } dr.Close();
或者
using(OracleConnection connection = new OracleConnection(connectionString))
{
using(OracleCommand cmd = new OracleCommand(strSQL,connection))
{
try
{
}
}
}
就不需要你自己去释放了,出了using块它自己就关闭了
using (var conn = new OracleConnection(cnStr))
{
conn.Open();
var comm = conn.CreateCommand();
comm.CommandText = "select * from all_tables where temporary='N'";
comm.CommandType = System.Data.CommandType.Text;
var result = from DbDataRecord record in comm.ExecuteReader()
let name = (string)record["X_NAME"]
where name.EndsWith("E")
select new MyDataType{ XName = name, WSize = (double)record["size"]};
list = result.ToList();
}