i need how to write a select statements in stored procedure , and how to connect my vb.net WEB aplication

Protected Sub insertbtn_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles insertbtn.Click
Dim request = New IDSRequest()
request.slnno = txtbxslnno.Text
request.empid = txtbxempid.Text
request.empno = txtbxempno.Text
request.empadress = txtbxadress.Text
Dim Response = DAOClass.manpulation(request)



Dim da As New SqlDataAdapter
Dim ds As New DataSet()


da.Fill(ds, "g")
GridView1.DataSource = ds.Tables(0)
GridView1.DataBind()

End Sub


this is in UI layer
and i write in logic in DAO layer ie;


Public Class DAOClass

Private Property GridView1 As Object

Public Shared Function manpulation(ByVal request As IDSRequest) As IDSResponse 'here parameters as REQUEST and returns as RESPONSE
Dim response = New IDSResponse()
Dim con As New SqlConnection()
Dim cmd As New SqlCommand()
Dim da As New SqlDataAdapter
Dim connectionstring As String
connectionstring = "server=SSPLDEV9;database=testing;User ID =sa; password=svt123;integrated security=false"
con = New SqlConnection(connectionstring)
con.Open()
cmd.CommandText = "Getemployeedetails"
cmd.CommandType = CommandType.StoredProcedure

'cmd.Parameters.AddWithValue("@slnno", )
cmd.Parameters.AddWithValue("@slnno", request.slnno)
cmd.Parameters.AddWithValue("@empid", request.empid)
cmd.Parameters.AddWithValue("@empno", request.empno)
cmd.Parameters.AddWithValue("@empadress", request.empadress)
cmd.Connection = con
cmd.ExecuteNonQuery()


con.Close()

Return response
End Function


here i got error

now successfully i am doing inserting the values using stored procedures.
can you give any successions for delete the record using stored procedures and logic in the button click can i take separate stored procedure for delete