Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
All-Star
117430 Points
8032 Posts
Moderator
MVP
Aug 05, 2009 09:39 PM|LINK
Here is a sample in VB.NET:
<asp:SqlDataSource ConnectionString="<%$ ConnectionStrings:myConn %>" ID="SqlDataSource1"runat="server" SelectCommand="SELECT ContactID, ContactName from Contacts" InsertCommand="INSERT INTO Contacts (ContactName) VALUES (@contactName);SELECT @contactID = Scope_Identity()" OnInserted="SqlDataSource1_Inserted" > <InsertParameters> <asp:Parameter Name="contactName" Type="String" /> <asp:Parameter Direction="Output" Name="contactID" Type="Int32" /> </InsertParameters> </asp:SqlDataSource>
Protected Sub SqlDataSource1_Inserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceStatusEventArgs)
Response.Write("Record Inserted: " + Server.HtmlEncode(e.Command.Parameters("@ContactID").Value.ToString()) + "<br/>") End Sub
limno
All-Star
117430 Points
8032 Posts
Moderator
MVP
Re: Populating Session Var in STORED PROC or POSTBACK - HELP please!!
Aug 05, 2009 09:39 PM|LINK
Here is a sample in VB.NET:
Protected Sub SqlDataSource1_Inserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceStatusEventArgs)Response.Write("Record Inserted: " + Server.HtmlEncode(e.Command.Parameters("@ContactID").Value.ToString()) + "<br/>") End SubFormat your SQL query with instant sql formatter:
http://www.dpriver.com/pp/sqlformat.htm