Solved

ASP.NET Scope Identity

Posted on 2008-10-30
1
185 Views
Last Modified: 2010-04-14
I need to get the PK associated with the Insert.  Could someone look at the code and tell me where I do this.  I want to use it when I send a confirmation to the user in my Submit Sub
Protected Sub btnSubmit_Click(ByVal sender as Object, ByVal e As System.EventArgs) Handles btnSubmit.Click

          'Will be used for multiple types of inserts - based on report event type

          If Event = "Fall" 

          sqlFallInsert.Insert()

          End If

 

       Dim mail as New MailMessage()

       mail.From=New MailAddress("Barta.Joan@mayo.edu")    

       mail.To.Add("Christensen.Katherine@mayo.edu")

             

       mail.subject="Safety Report Notification"

       mail.body = "Please do not reply to this email directly. If you have any questions, please contact Joan Barta, Safety Coordinator Email: barta.joan@mayo.edu Phone: (507) 385-5890 "

       

       Dim smpt As New SmtpClient

          smpt.Send(mail) 

         

End Sub
 

Protected Sub sqlFallInsert_Inserting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SQLDataSourceCommandEventArgs) Handles sqlFallInsert.Inserting

        	Dim Reportid As String

        	e.Command.Parameters("@PtAcct").Value = PtAcct.Text

       	e.Command.Parameters("@PtName").Value = PtName.Text

         	e.Command.Parameters("@PtStat").Value = PtStat.Text

        	e.Command.Parameters("@PtLoc").Value = PtLoc.Text

        	e.Command.Parameters("@drpdwnEvent").Value = drpdwnEvent.SelectedItem.Value 

         e.Command.Parameters("@drpdwnFacility").Value = drpdwnFacility.SelectedItem.Value 

           e.Command.Parameters("@drpdwnLocation").Value = drpdwnLocation.SelectedItem.Value 

			e.Command.Parameters("@drpdwnDept").Value = drpdwnDept.SelectedItem.Value 
 

   End Sub  
 

The Button with the DataSource

<asp:Button runat="server" Text="Submit Report" id="btnSubmit" Width="121px" Height="41px" />

	</div>

	<asp:SqlDataSource runat="server" id="SqlInsert" InsertCommand="INSERT INTO [IncidentTmp] ([PtAcct], [PtName], [PtStat], [PtLoc], [Event], [Facility], [EventLoc], [EventDept]) VALUES (@PtAcct, @PtName, @PtStat, @PtLoc, @drpdwnEvent, @drpdwnFacility, @drpdwnLocation, @drpdwnDept)"  ConnectionString="<%$ ConnectionStrings:QIMConnectionString %>" SelectCommand="SELECT [ID], [PtAcct], [PtName], [PtDob], [PtDos], [PtStat], [PtLoc] FROM [IncidentTmp]">

		

		<InsertParameters>

			<asp:parameter Name="PtAcct" Type="String" />

			<asp:parameter Name="PtName" Type="String" />

			<asp:parameter Name="PtStat" Type="String" />

			<asp:parameter Name="PtLoc" Type="String" />

			<asp:parameter Name="drpdwnEvent" Type="String"/>

			<asp:parameter Name="drpdwnFacility" Type="String"/>

			<asp:parameter Name="drpdwnLocation" Type="String"/>

			<asp:parameter Name="drpdwnDept" Type="String"/>

		</InsertParameters>

	</asp:SqlDataSource>

Open in new window

0
Comment
Question by:aninec
1 Comment
 
LVL 20

Accepted Solution

by:
brwwiggins earned 500 total points
ID: 22841590
i've never done it using a sqldatasource but I found this article that might help
http://forums.asp.net/p/1308155/2571348.aspx

I know you can do it using ADO similar to this method http://aspalliance.com/892_CodeSnip_How_to_Get_Id_of_the_Record_Using_ASPNET_and_SQL_Server_2000.1
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now