Blog

Update Command in VB.NET

Posted by Rohatash Kumar Blogs | Visual Basic 2010 Aug 17, 2011
Here we will see how to use update command in VB.NET.

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

COMMENT USING
PREMIUM SPONSORS
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.
Employers - Post Free Jobs
SPONSORED BY
  • MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.
Employers - Post Free Jobs