🔒 Closed Vb.net with mysql

[kram0256]

Pa tulong naman ng codes para update mga paps yaw mag function ng uodate button ko
Ito po

 

[akositito]

walang error? try mo muna debug or messagebox yung value ng ''Texbox1.Text" mo baka mali ang value na pinapasa mo

 

[Shiraori]

try nyo po muna lagyan ng cmd.Prepare(); para gumana yung parameters

 

[aa1012]

your code seems to be okay but try using this code Snippet. Im using MSSQLServer here.

I supposed to update the firstname from a particular table. the new value was set into the fname string variable.
I used the using keyword here for the automatic disposal of the objects connection and command

Dim constring As String = "your_connectionstring_here"
Dim query As String = "your_commandtext_here"
Dim fname As String = "name_to_be_set_as_new_firtsname_value"
Try
Using con As SqlConnection = New SqlConnection(constring)
Using cmd As SqlCommand = New SqlCommand()
cmd.CommandText = query
cmd.CommandType = CommandType.Text
cmd.Parameters.AddWithValue("@fname", fname)
cmd.Connection = con
con.Open()
cmd.ExecuteNonQuery()
End Using
End Using
Catch ex As Exception
'some exception handling here
End Try

let me know how it works from your project.

 

[PHC-Xes]

mas recommended po ba na MySql database kesa sa 1st choice ko na SQL Server medyo hirap po kasi ako mag connect thru ip address at lan network. Salamat po sa sagot