Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MySQL and VB .NET
- Thread starter cosmoh2o
- Start date
Would this be what you are looking for?
(Scroll down to Lock Types on the page)
·genoa
If a dog craps in the yard and buries it, is that considered steganography?
(Scroll down to Lock Types on the page)
·genoa
If a dog craps in the yard and buries it, is that considered steganography?
- Thread starter
- #3
I am new to VB .NET and MySQL and the info sounds like what I need. Thank you for responding, however I have a question. Do you know how to implement it in code? Below is a sample of some of the code:
Dim c as new OdbcCommand()
Dim conn as new OdbcConnection("DSN=mysql_dsn"
conn.Open()
c.Connection = conn
c.CommandText = "insert into A values('x','y','z')"
c.executenonquery()
conn.Close()
I would like to "lock" the table A before inserting any values. In Java or PERL I would just execute a "lock" command but I am not sure how to do it in VB .NET.
Once again, thank you for your response.
Dim c as new OdbcCommand()
Dim conn as new OdbcConnection("DSN=mysql_dsn"
conn.Open()
c.Connection = conn
c.CommandText = "insert into A values('x','y','z')"
c.executenonquery()
conn.Close()
I would like to "lock" the table A before inserting any values. In Java or PERL I would just execute a "lock" command but I am not sure how to do it in VB .NET.
Once again, thank you for your response.
- Status