Insert command in ADO.NET

To create a connection we pass the connection string as a parameter in connection object.

Dim str As String = "Data Source=.;uid=sa;pwd=123;database=master"

Dim con As New SqlConnection(str)

The above string defines the connection string which is used to connect the database with the application.

Insert command

This statement is used to insert a row of data in a table.

Dim ins As String = "insert into emp values(1,'monu')"

Dim com As New SqlCommand(Ins, con)

Now we create a database table and insert some values in this table. Table looks like this.

create table emp

(

empid varchar(40),

empname varchar(30) 

)

go

insert into employee values(1,'monu')

go

select * from emp

OUTPUT

Table1.gif

For example

Imports System.Data.SqlClient

Module Module1

    Sub Main()

        Dim str As String = "Data Source=.;uid=sa;pwd=123;database=master"

        Dim con As New SqlConnection(str)

        Try

            con.Open()

            Dim ins As String = "insert into emp values(2,'Hari')"

            Dim com As New SqlCommand(ins, con)

            com.ExecuteNonQuery()

            Console.WriteLine("record has been saved")

        Catch ex As Exception

            Console.WriteLine("can not save record")

        End Try

    End Sub

End Module

OUTPUT

Now open the database table and test it.

Table2.gif