Locking Tables with VB .NET

[cosmoh2o]

I am new to VB .NET as it applies to MySQL databases and have a question about data integrity within MySQL. I have an application written in Visual Basic .NET that is connected to a MySQL database via ODBC and everything works great. How can I be sure that when a table in the database, say "TABLE1" is being written to no one else can access it until the transaction is through? When I used PERL, I just "locked" the table, however I can not seem to get this to work with VB .NET.

Has anyone out there ran into a similar situation and if so, how did you solve it? Any help would be great, and simple sample code would be even better . Thanks in advance for any help.

 

[sleipnir214]

What are you doing that you need table locks?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[cosmoh2o]

I am adding a list of scores to a table and then deleting them after selecting them all. So I need some way to "lock" the SCORES table when values are being added to it.