Update data in SQL database table
Try
con = New SqlConnection(cs)
con.Open()
Dim cb As String = "update Product set Productname = '" & txtProductName.Text & "',[HSNCode]= '" & cmbHSN.Text & "',Category = '" & cmbCategory.Text & "',[Tax]= '" & cmbTAX.Text & "',[Range]= '" & cmbRange.Text & "',[PCompany]= '" & cmbCompany.Text & "' where Productcode = '" & txtProductCode.Text & "'"
cmd = New SqlCommand(cb)
cmd.Connection = con
cmd.ExecuteReader()
MessageBox.Show("Successfully updated", "Product Details", MessageBoxButtons.OK, MessageBoxIcon.Information)
If con.State = ConnectionState.Open Then
con.Close()
End If
con.Close()
Catch ex As Exception
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
End Try
• Insert/Save Data to Database Table From V...
this link for save/insert data in SQL database
• Auto Fill Data in Combo box From Database ...
this link for fatch data from SQL database in combo box
• Auto generate Random Number for unique Pro...
this link for Auto generate Random Number for unique ID
• FONT AND COLOR CHNAGE IN DATAGRIDVIEW - VB...
this link for FONT AND COLOR CHNAGE IN DATAGRIDVIEW
On this page of the site you can watch the video online Update data in SQL database table with a duration of hours minute second in good quality, which was uploaded by the user SUNDEEPGAMEIN 24 November 2018, share the link with friends and acquaintances, this video has already been watched 64 times on youtube and it was liked by 1 viewers. Enjoy your viewing!
