Solved

ASP.NET Scope Identity

Posted on 2008-10-30
1
191 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In an ASP.NET application, I faced some technical problems. In this article, I list them out and show the solutions that I found.  I hope it will be useful. Problem: After closing a pop-up window, the parent page should be refreshed automaticall…
ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

830 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