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