Can someone please tell me how I would get the ID of the row that was inserted using the following? (VS2012 VB.NET)
Code:Dim connString = ConfigurationManager.ConnectionStrings("DBConnectionString").ToString
Dim conn As New SqlConnection(connString)
Dim sqlMembers As New SqlDataSource
sqlMembers.ConnectionString = connString
sqlMembers.InsertCommand = "INSERT INTO [Members] ([MemberEmail], [MemberRole], [MemberFirstName], [MemberLastName], [MemberCity], [MemberState], [MemberCountry], [MemberCredits], [MemberJoinDate], [MemberStatus]) VALUES (@MemberEmail, @MemberRole, @MemberFirstName, @MemberLastName, @MemberCity, @MemberState, @MemberCountry, @MemberCredits, @MemberJoinDate, @MemberStatus)"
sqlMembers.InsertParameters.Clear()
With sqlMembers
.InsertParameters.Add("MemberEmail", txtCreateMemberEmail.Text)
.InsertParameters.Add("MemberRole", "Member")
.InsertParameters.Add("MemberFirstName", txtCreateMemberFirstName.Text)
.InsertParameters.Add("MemberLastName", txtCreateMemberLastName.Text)
.InsertParameters.Add("MemberCity", ddlCity.SelectedValue)
.InsertParameters.Add("MemberState", ddlState.SelectedValue)
' TODO: ADD ADDITIONAL COUNTRIES LATER
.InsertParameters.Add("MemberCountry", "187")
.InsertParameters.Add("MemberCredits", "0.00")
.InsertParameters.Add("MemberJoinDate", DateTime.Now.ToString)
.InsertParameters.Add("MemberStatus", "Pending")
End With
Try
sqlMembers.Insert()
Response.Redirect("/article.aspx?slug=new-member-registered")
Catch ex As Exception
pnlCreateAccountStatus.Visible = True
lblCreateAccountStatus.Text = "Sorry something is wrong"
End Try
