Printable View
'create a dataadapater and connectionobject
Public Function x()
dim x1 as oledbcommand
'statements to execute the command object here
'don't dispose or close
end function
public function y()
dim x1 as oledbcommand
'statements to execute the command object here
'don't dispose or close
end function
'execute both function simulteniously what will happen?
Object reference not set to an instance of an object.
What are you asking? Whether there might be concurrency issues occur with the database?
Private Sub MainFormLoad(sender As System.Object, e As System.EventArgs)
mycon.ConnectionString = "Provider=Microsoft.jet.oledb.4.0;Data source=dbchat.mdb;persist security info=false"
mycon.Open()
End Sub
Private Function x()
Dim x1 As New System.Data.OleDb.OleDbCommand("select * from Members",mycon)
x1.ExecuteNonQuery()
End Function
Private Function y()
Dim x1 As New System.Data.OleDb.OleDbCommand("select * from Members",mycon)
x1.ExecuteNonQuery()
End Function
Private Sub Button1Click(sender As System.Object, e As System.EventArgs)
Call x
Call y
End Sub
Try in vs.net
If you open a connection that is already open then there will be a problem.
Rule: Close the connection after using and just open it when it is needed.
its not the connection the oledbcommand name. use it twice and don't dispose in one function just keep on using it.
Quote:
Originally Posted by iehjsucker
There is no problem about the code, it is just the connection is simultaenously open which not a good practice.
did you try it
Yep, Since your using a variable that declared inside a sub then it is exclusive only in that sub and outside of that sub the variable is not recognized.
I tried it and no problem occur.
You still haven't told us exactly what it is you want to know. If you're going to make us guess then why should we care?