Dim mySqlcommand2 As Data.SqlClient.SqlCommand = mySqlconnection.CreateCommand
mySqlcommand2.Connection = mySqlconnection
mySqlcommand2.CommandText = "update guaji set gj_r_many=gj_mail_many where gj_id=" & Convert.ToInt32(Me.GridView1.SelectedRow.Cells(0).Text)
Dim reader2 As Data.SqlClient.SqlDataReader = mySqlcommand2.ExecuteReader
reader2.Read()我在程序中使用了以上语句,写完后根据asp的经验是应该close数据库连接,我想问一下,我应该close哪几条
mySqlcommand2.Connection = mySqlconnection
mySqlcommand2.CommandText = "update guaji set gj_r_many=gj_mail_many where gj_id=" & Convert.ToInt32(Me.GridView1.SelectedRow.Cells(0).Text)
Dim reader2 As Data.SqlClient.SqlDataReader = mySqlcommand2.ExecuteReader
reader2.Read()我在程序中使用了以上语句,写完后根据asp的经验是应该close数据库连接,我想问一下,我应该close哪几条
mySqlcommand2.dispose();
mySqlconnection.close();
mySqlconnection.dispose();个人见解,共同学习
close 和 dispose 方法的区别 前者只是关闭了数据连接 可以再open()
后者是把mySqlconnection这个实例完全销毁了 要新建连接需要再实例化一个。
reader2.dispose();
mySqlconnection.dispose()l