关于New OleDbConnection(cnstr)在各个过程调用问题
Dim cn As OleDbConnection
Dim da As OleDbDataAdapter
Dim ds As DataSet
Dim cnstr As String
Dim crecommand As OleDbCommand
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
cnstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\VB\db1.mdb"
cn = New OleDbConnection(cnstr)
cn.Open()
cnstr = "create table " + TextBox3.Text + " (id int identity(1,1) primary key,摘要 varchar(20),内容 varchar(200))"
crecommand = New OleDbCommand(cnstr, cn)
crecommand.ExecuteNonQuery()
End Sub
我在其它过程中直接写
cnstr = "insert into " + TextBox3.Text + "(摘要,内容) values('" + TextBox2.Text + "','" + TextBox1.Text + "')"
crecommand = New OleDbCommand(cnstr, cn)
crecommand.ExecuteNonQuery()
提示 ExecuteNonQuery() 异常,在前面添加下面语句就好了。
cnstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\VB\db1.mdb"
cn = New OleDbConnection(cnstr)
cn.Open()
我想问下,是不是每个过程中都要写cn = New OleDbConnection(cnstr),那是不是每个过程都要连接access一次?
每次连接后是自动断开吗?每个过程调用时没有显示重复连接的提示。
本人新新手,望指教!