With the code below data is keyed into a form and inserted into a table called Investors. After it is inserted, I'm trying to redirect back to the same page, passing the InvestorID on the querystring. Simply showing all of the information I just added, kind of insuring that it was posted to the database. Can someone help? Thanks.

Protected Sub btnAdd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnAdd.Click

        Dim conn As SqlConnection = SQLServer.Brethren
        Dim cmd As SqlCommand = New SqlCommand("BFI_AddInvestor", conn)
        cmd.CommandType = CommandType.StoredProcedure

        cmd.Parameters.AddWithValue("@grpid", Me.ddlGrpid.SelectedValue)
        cmd.Parameters.AddWithValue("@statement_name", Me.txtStatement_Name.Text)
        cmd.Parameters.AddWithValue("@name1", Me.txtName1.Text)
        cmd.Parameters.AddWithValue("@name2", Me.txtName2.Text)
        cmd.Parameters.AddWithValue("@addr3", Me.txtAddr3.Text)
        cmd.Parameters.AddWithValue("@addr4", Me.txtAddr4.Text)
        cmd.Parameters.AddWithValue("@city", Me.txtCity.Text)
        cmd.Parameters.AddWithValue("@state", Me.txtState.Text)
        cmd.Parameters.AddWithValue("@zip", Me.txtZip.Text)
        cmd.Parameters.AddWithValue("@phone", Me.txtPhone.Text)
        cmd.Parameters.AddWithValue("@email", Me.txtEmail.Text)
        cmd.Parameters.AddWithValue("@active", Me.chkActive.Checked)
        cmd.Parameters.AddWithValue("@client_inv", Me.txtClient_Inv.Text)
        cmd.Parameters.AddWithValue("@opendate", Me.txtOpendate.Text)

        Dim spRecord As SqlParameter = New SqlParameter("@investorid", Nothing)
        spRecord.Direction = Data.ParameterDirection.Output
        cmd.Parameters.Add(spRecord)

        Try
            conn.Open()
            cmd.ExecuteNonQuery()
        Finally
            conn.Close()
        End Try

Have look,

str="Page1.aspx?no=10&name=something"
Response.Redirect(str)
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.