Update command
The update command is used to update the existing record from database has the below command:
update table1 set Firstname='rohatash', Lastname='kumar' where City='mumbai' and Id='1'
For example
Imports System.Data.SqlClient
Module Module1
Sub Main()
Dim str As String = "Data Source=.;uid=sa;pwd=Password$2;database=master"
Dim con As New SqlConnection(str)
Try
con.Open()
Dim com As New SqlCommand("update table1 set Firstname='rohatash', Lastname='kumar' where City='mumbai' and Id='1' ", con)
Console.WriteLine("Number of row in table:=" & com.ExecuteScalar())
com.ExecuteNonQuery()
Console.WriteLine("update has been completed")
con.Close()
Catch ex As Exception
Console.WriteLine("can not update record")
End Try
End Sub
End Module