[thelist] Key ID of Record Just Created?

Casey aspnet at thecrookstons.com
Tue Aug 23 10:53:18 CDT 2005


In ASP.NET / VB.NET, is it possible to discover the key_id of a record just
created?  Key ID column is doc_id.

TIA!!


 Dim conAddDoc As SqlConnection = New
SqlConnection(System.Configuration.ConfigurationSettings.AppSettings("MccCon
String"))

 Dim strInsert As String = "Insert MCCIME_Doctor (fname, lname, specialty,
....) VALUES (@fname, @lname, @specality, ...)"

 Dim cmdInsert As SqlCommand = NEW SqlCommand(strInsert, conAddDoc)

conAddDoc.Open

  cmdInsert.ExecuteNonQuery()

conAddDoc.Close



More information about the thelist mailing list