利用SqlDataAdapter Insertcommand 获取刚新增的自动编号ID值-技术开发专区

利用SqlDataAdapter Insertcommand 获取刚新增的自动编号ID值

作者：ITPUB论坛编辑： nancy 2008-06-13 00:00

【IT168技术文档】

这句很重要要用INSERTCOMMAND 必须要先有SELCOMMAND这个

 Dim myAda As SqlDataAdapter = New SqlDataAdapter("Select * From [UserInfo] Where [U_ID] Is Null", conn)

接下来就是INSERT了,注意有二个SQL语句 ";" Select SCOPE_IDENTITY() As U_ID (U_ID为自动ID)

sql = "INSERT INTO [UserInfo] ("
sql += "  [U_Name]"
sql += " ,[U_Password]"
sql += "  ,[U_EMail]"
sql += " ,[U_Face]"
sql += " ,[U_UserTruename]"
sql += " ,[U_Sex]"
sql += " ,[U_Age]"
sql += " ,[U_Identity]"
sql += " ,[U_Tel]"
sql += " ,[U_Cellphone]"
sql += " ,[U_Address]"
sql += " ,[U_Zipcode]"
sql += ",[U_MsnQQ]"
sql += ",[U_About]"
sql += ",[M_MaCode]"
sql += ",[U_Score]"
sql += " ) Values ("
sql += "  @U_Name"
sql += " ,@U_Password"
sql += " , @U_EMail"
sql += " ,@U_Face"
sql += " ,@U_UserTruename"
sql += " ,@U_Sex"
sql += " ,@U_Age"
sql += " ,@U_Identity"
sql += " ,@U_Tel"
sql += " ,@U_Cellphone"
sql += " ,@U_Address"
sql += " ,@U_Zipcode"
sql += ",@U_MsnQQ"
sql += ",@U_About"
sql += ",@M_MaCode"
sql += ",@U_Score"
sql += ");Select  SCOPE_IDENTITY() As U_ID"

关注我们