Need help with updating MySQL

SIM-297877 · 2015-02-04T01:35:57+00:00

I am able to read, insert, and delete data from my MySQL database but i need to be able to update the data too... Here is how i insert data (showing the coloums) Dim result As DialogResult = MessageBox.Show("Have you made sure to see any changes have happend to the DB?", "Check the Database!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) If result = DialogResult.Yes Then con.ConnectionString = ("server=" & MySQLServer & ";user id=" & MySQLUsername & ";password=" & MySQLPassword & ";database=" & MySQLDatabase) Try con.Open() Dim sb As New System.Text.StringBuilder For Each item In CheckedListBox1.CheckedItems sb.Append(item) sb.Append(" ") Next With cmd .Connection = con .CommandText = "INSERT INTO `" & MySQLTable & "` (`id`, `rank`, `username`, `games`, `status`, `enlistdate`, `recruiter`, `timedone`, `notes`, `ip`) " & _ "VALUES (NULL, '" & ComboBox1.Text & "', '" & TextBox1.Text & "', '" & sb.ToString() & "', '" & ComboBox2.Text & "', '" & MonthCalendar1.SelectionRange.Start & "'

Only3
Guest

Feb 5, 2015 10:31 AM

example http://www.w3schools.com/sql/sql_update.asp

Next Oldest | Next Newest

New Reply

Possibly Related Threads...
Thread / Author	Replies	Views	Last Post
[.NET] .Net MYSQL Information Updating. Not working? by GruntStylDec 6, 2016 04:45 AM	1	178	Dec 6, 2016 04:45 AM Last Post: Rhez
[C#] C# Updating SQL Table - Table not updating by siimon00Sep 28, 2016 09:58 PM	5	202	Sep 28, 2016 09:58 PM Last Post: some_dude13
[.NET] Selecting/Updating/Inserting MySQL by Netflix and WeedApr 17, 2016 03:04 PM	4	149	Apr 17, 2016 03:04 PM Last Post: Netflix and Weed

View a Printable Version
Export as PDF
Subscribe to this thread

Login
Username/Email:
Password:	Lost Password?
	Remember me