- Increase transparency
- Onboard new hires faster
- Access from mobile/offline
Dim cn As New SqlConnection Dim cmd As New SqlCommand cn = GetConnected() cmd.Connection = cn cmd.CommandText = sSQL cmd.Parameters.Add(New SqlParameter("@FromDate", SqlDbType.DateTime)) ' etc - more parameters added ' This works - the record is added with a visible uniqueidentifier cmd.ExecuteNonQuery() ' This is where I'm trying to grab the Primary Key, but it returns a null.... cmd.Parameters.Clear() cmd.CommandText = "SELECT @@IDENTITY" Dim newID As String = "" & cmd.ExecuteScalar() ' ... so all of the record added here have a blank SessionID sSQL = "INSERT INTO tblScheduleStuff (Scheduler_SessionID, GenericStuff) SELECT '" & newID & "', Stuff FROM tblTEMPStuff" cmd.CommandText = sSQL cmd.ExecuteNonQuery()
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!