|
-
Feb 27th, 2011, 06:53 AM
#4
Re: Help connecting to MySQL with .NET Plz :D
Use a MySqlCommand object and with the SQL query, call the ExecuteNonQuery() method.
For example:
Code:
SQL = " UPDATE boomtable SET Tab1 = 'CLOSED' WHERE Tab1 = 'OPEN' "
myCommand.CommandText = SQL
myCommand.ExecuteNonQuery()
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 IndiaSkills: 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
|
Reply With Quote