SqlConnection myConnection = new SqlConnection();myConnection.ConnectionString = ConfigurationSettings.AppSettings["ConnectionString"];
CollectTableData(myConnection,"代表情况");======================
上面代码我将myConnection作为参数传递到CollectTableData()方法使用我想问:在CollectTableData()中调用myConnection.Close();连接是否关闭?
myConnection.ConnectionString = ConfigurationSettings.AppSettings["ConnectionString"];
根本就没打开连接
CollectTableData(myConnection,"代表情况");
你应该在
CollectTableData(SqlConnection Conn,string str)
{Conn.Open();;;;
;;
Conn.Close();
}
中作
{
myConnection.Open();//再打开一次
.... myConnection.Close();
}
最后连接myConnection是否关闭?我这样做好象不符合规范吧?
{
myConnection.Open();//再打开一次
.... myConnection.Close();
}
{
if (myConnection.State != System.Data.ConnectionState.Open)
myConnection.Open();//再打开一次
.... //myConnection.Close();不要在此关闭它
}
测一下myConnection的状态。。myConnection.State
结果就出来了啊。。
对应写
_conn.Open();
try
{}
catch()
{}
finally
{
_conn.close();
}
finally
{
if(_conn!=null) _conn.close();
}