Help me About Recordset in ADO.NET

Zombie

New member
Joined
Nov 30, 2004
Messages
1
Programming Experience
Beginner
I have table with these Field

ID = AutoNumber < Primary
Software = Text
Version = Text
....

and i'm using these code to INSERT New Record

VB.NET:
strSQL = "SELECT * FROM SoftwareDetail"
        Try
            With rsSoftwareDetail
                .Open(strSQL, conn, CursorTypeEnum.adOpenStatic, LockTypeEnum.adLockBatchOptimistic)
                .AddNew()
                .Fields("Software").Value = in_strSoftware
                .Fields("Version").Value = in_strVersion
                .Fields("Release").Value = CStr(in_dtRelease)
                .Fields("ProLanguage").Value = in_strLanguage
                .Fields("Packer").Value = in_strPacker
                .Fields("Introduce").Value = in_strIntroduce
                .Fields("FileSize").Value = in_lngFileSize
                .Fields("HomePage").Value = in_strHomePage
                .Fields("Download").Value = in_strDownload
                .Update()
                .UpdateBatch()

Have any way to known field ID of new Record have just added?
Hm ..I can use SELECT to Find it . But.. i hopy have another fast way to do..

Thanx
 
Back
Top