hi,
i am not sure how ur coding work. but u can try below coding to call a store procedure and pass a value to SP and navigate with DB.
hope can help u
Dim sqlcmd As New SqlCommand()
Dim sqlDa As New SqlDataAdapter()
sqlConn.Open()
sqlcmd = New SqlCommand("StoreProcedure name", sqlConn, RollBackAction)
sqlDa.SelectCommand = sqlcmd
sqlcmd.CommandType = CommandType.StoredProcedure
sqlcmd.CommandTimeout = 2000
sqlcmd.Parameters.Add("@parameter", SqlDbType.VarChar, 30).Value = value
sqlcmd.ExecuteNonQuery()
sqlConn.Close()
sqlConn.Dispose()
http://programmingschools.blogspot.com/
http://sqltutorials.blogspot.com/