Simple Guide line for Insert data with VB.NET web forms
( Code for save data calling SP)
Import namespace="system.data"
Import namespace="system.data.sqlclient"
Private Sub Page_Load(ByVal Source As Object, ByVal E As EventArgs)
Dim sql As String = "InsertEmployee"
Dim strConnection As String = "Data Source=local;Initial Catalog=TestDB;User ID=sa;Password='111';"
Dim conn As New SqlConnection(strConnection)
conn.Open()
Dim cmd As New SqlCommand(sql, conn)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@FirstName", "ASMA")
cmd.Parameters.Add("@LastName", "QURESHI")
Try
cmd.ExecuteNonQuery()
Catch ex As Exception
Response.Write("Error: " & ex.Message & "")
End Try
cmd.Connection.Close()
End Sub