Blog

Update Command in VB.NET

By Rohatash Kumar Aug 17 2011
Here we will see how to use update command in VB.NET.
    • Like
    • Love It
    • Awesome
    • Interesting
    • It's Okay
    • Thumbs Down
  • 5k
  • 0

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