SqlConnection myConnection = new SqlConnection(myConnectionString);
SqlCommand myCommand = new SqlCommand(mySelectQuery, myConnection);
myConnection.Open();
SqlDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
while(myReader.Read())
{
Console.WriteLine(myReader.GetString(0));
}
myReader.Close();
}
SqlCommand myCommand = new SqlCommand(mySelectQuery, myConnection);
myConnection.Open();
SqlDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
while(myReader.Read())
{
Console.WriteLine(myReader.GetString(0));
}
myReader.Close();
}
则加上:myConnection.Close();
用Microsoft.ApplicationBlocks.Data
完成下面的过程。objReader = SqlHelper.ExecuteReader(.......)
text1 = objReader("Text1")
objReader.Close()
到这里是不是数据库的链接资源都已经释放了?
我总觉的还应该释放数据链接。请各位指点~~~
你没有释放连接。要释放连接,可以这样:
myConnection1.Close();
或者
myCommand1.Connection.Close();
1,用Microsoft.ApplicationBlocks.Data
中的SqlHelper.ExecuteReader获得objReader完成业务后,如何释放数据库资源?2,是否只需要objReader.Close()便可释放所有资源?3,如果不是,那么现在只有Reader对象,如何释放其他资源?4,如果不是,那么Microsoft.ApplicationBlocks.Data是否提供了释放所有数据库链接的方法?拜托各位~~~
你后面的.....是什么内容?用Microsoft.ApplicationBlocks.Data是可以关闭连接的。
你可以这样:
objReader = SqlHelper.ExecuteReader(myConnection1,CommandType.Text, connectionString);
myConnection1.Close();
dr = cmd.ExecuteReader()
Else
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
End If
......"so if you didn't open the connection (and didn't specify the last parameter SqlConnectionOwnership), then you only need to calldr.Close()to release the resources