value from stored procedure to ASP.NET sub

[ellaeel]

Hi<BR>I am inserting a record in my table through a stored procedure. My inserting happens without any glich. But the problem is I need to use the outputted ID for me to go to the next page. My codes are as follows<BR>1. Store procedure to add the data. I am outputting "pub_id".<BR>2. In my code behind I have my codes for checking the insert has happend as throwing out the outputted value of that particular insert...<BR>... public function AddPub(...) as interger<BR>...<BR>...<BR>'here i am checking whther the insert has happend and I am outputting the pub_id too<BR><BR> If Not parameterPubId.Value Is Nothing And Not parameterPubId.Value Is System.DBNull.Value Then<BR> Return CStr(parameterPubId.Value).Trim()<BR> Else<BR> Return String.Empty<BR> End If<BR><BR>3. Now in my actual ASP.NET page I am having a click on the button and by clicking the button I trigger this sub<BR><BR>Sub PlanBasicBtn_Click(ByVal sender As Object, ByVal E As EventArgs)<BR>...<BR>...<BR>If Page.IsValid = true then<BR>...<BR>...<BR>response.Redirect("next_page.aspx?id=" & theoutputtedpubid)<BR>I need to know how do I show the outputtedpubid. Any help would be grateful<BR><BR>Thanx<BR><BR>