在ASP.NET中,用什么方法可以取回当前添加的记录的自增ID?
问题:
有什么方法可以取回当前添加的数据的编号([id])?
数据结构:
[id] [int] IDENTITY (1, 1) NOT NULL ,
[a] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[b] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[c] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[d] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[e] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
程序段:
Dim dbConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connectionString)
Dim queryString As String = "SELECT * FROM table1"
Dim dbCommand As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection
Dim Dt As New DataTable
Dim dataAdapter As System.Data.SqlClient.SqlDataAdapter = New System.Data.SqlClient.SqlDataAdapter
dataAdapter.SelectCommand = dbCommand
Dim myDataRowsCommandBuilder As System.Data.SqlClient.SqlCommandBuilder = New System.Data.SqlClient.SqlCommandBuilder(dataAdapter)
dataAdapter.Fill(Dt)
Dim myRow As DataRow = Dt.NewRow
myRow("a") = "A"
myRow("b") = "B"
myRow("C") = "C"
myRow("D") = "D"
myRow("E") = "E"
response.write(myRow("id")) 说明:输出结果为空
Dt.Rows.Add(myRow)
dataAdapter.Update(Dt)
在这里取回的最后记录的[ID]也是为空