+- Hack Forums (https://hackforums.net)
+-- Forum: Tech (https://hackforums.net/forumdisplay.php?fid=444)
+--- Forum: Coding (https://hackforums.net/forumdisplay.php?fid=151)
+---- Forum: Software Development (https://hackforums.net/forumdisplay.php?fid=118)
+---- Thread: [.NET] Need help with updating MySQL (/showthread.php?tid=4669324)
Need help with updating MySQL - SIM-297877 - Feb 3, 2015
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)
PHP Code
<?php
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 & "', '" & TextBox2.Text & "', '" & NumericUpDown1.Value.ToString & "', '" & TextBox3.Text & "', '" & MyClientIP & "');"
result = cmd.ExecuteNonQuery
If result = 0 Then
MsgBox("Data has been Inserted!")
Refresh()
Else
MsgBox("Successfully saved!")
Refresh()
End If
End With
Catch ex As Exception
MessageBox.Show("Database Error: " & ex.Message)
End Try
con.Close()
ElseIf result = DialogResult.No Then
MessageBox.Show("Try again after you check for DB updates.")
Else
End If
I load the data into the panel (add and Edit panel) via;
PHP Code
<?php
Private Sub DataGridView1_CellMouseClick(sender As Object, e As DataGridViewCellMouseEventArgs) Handles DataGridView1.CellMouseClick
Try
TmpID = DataGridView1.CurrentRow.Cells(0).Value
ComboBox1.Text = DataGridView1.CurrentRow.Cells(1).Value
TextBox1.Text = DataGridView1.CurrentRow.Cells(2).Value
Dim TmpStrng As String() = DataGridView1.CurrentRow.Cells(3).Value.ToString.Split(New Char() {" "c})
Dim TmpGames As String
For Each TmpGames In TmpStrng
Dim I As Integer
For I = 0 To CheckedListBox1.Items.Count - 1
If CheckedListBox1.Items(I).IndexOf(TmpGames) <> -1 Then
CheckedListBox1.SetItemChecked(I, True)
End If
Next
Next
ComboBox2.Text = DataGridView1.CurrentRow.Cells(4).Value
MonthCalendar1.SelectionRange.Start = DataGridView1.CurrentRow.Cells(5).Value
TextBox2.Text = DataGridView1.CurrentRow.Cells(6).Value
NumericUpDown1.Value = Convert.ToInt32(DataGridView1.CurrentRow.Cells(7).Value)
TextBox3.Text = DataGridView1.CurrentRow.Cells(8).Value
Catch ex As Exception
TmpID = 0
ComboBox1.Text = "Recruit.gif"
TextBox1.Text = ""
ComboBox2.Text = ""
TextBox2.Text = ""
NumericUpDown1.Value = 1
TextBox3.Text = ""
End Try
End Sub
I really need help trying to make it so i can update the data using the same information panel... (ie. where i get the info for inserting into the db)
Still really need some help with this one... Everything i try errors or just plain dont work.
* - Xghost7 - Feb 4, 2015
PHP Code
<?php
strQuery = "UPDATE users SET value1 = '" & value1variable & "', value2 = '" & value2variable & WHERE id = '" & usernameid & "' '"
where ID is so it updates that user's colum.
i hope you get the idea mate.
* - Only3 - Feb 5, 2015
example http://www.w3schools.com/sql/sql_update.asp