|
-
Feb 27th, 2011, 05:27 AM
#2
Re: Help connecting to MySQL with .NET Plz :D
Hi.. Welcome to the forums...
You have declared SQL as a String and in the code, you are doing this:
Code:
SQL = " UPDATE boomtable SET Tab1 = 'OPEN' WHERE Tab1 = 'CLOSED' "
SQL.ExecuteNonQuery()
where, the second line is invalid. Because, SQL is not a MySqlCommand object !. You've declared it as a String !
If my post was helpful to you, then express your gratitude using Rate this Post. 
And if your problem is SOLVED, then please Mark the Thread as RESOLVED (see it in action - video)
My system: AMD FX 6100, Gigabyte Motherboard, 8 GB Crossair Vengance, Cooler Master 450W Thunder PSU, 1.4 TB HDD, 18.5" TFT(Wide), Antec V1 Cabinet
Social Group: VBForums - Developers from India
Skills: PHP, MySQL, jQuery, VB.Net, Photoshop, CodeIgniter, Bootstrap,...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|