不行哦, 错误: SELECT 子句中包含一个保留字、拼写错误或丢失的参数,或标点符号不正确。 BDComm=new OleDbCommand("select top 1 from Comm_apply order by appid desc",BDConn); BDRead=BDComm.ExecuteReader();
BDComm=new OleDbCommand("select top 1 * from Comm_apply order by appid desc",BDConn); BDRead=BDComm.ExecuteReader();
Dim mySqlCommand As New SqlClient.SqlCommand()sqlString = "INSERT INTO " & strTableName & "(" & strSqlFieldName & ")" sqlString &= " VALUES (" & strSqlFieldValue & ")" sqlString &= ";SELECT " & TableKey & " FROM " & strTableName sqlString &= " WHERE (" & TableKey & "= @@IDENTITY)"mySqlCommand.Connection.Open() lngNewRecordID = mySqlCommand.ExecuteScalarlngNewRecordID就是你刚刚新增的纪录id号
错误:
SELECT 子句中包含一个保留字、拼写错误或丢失的参数,或标点符号不正确。 BDComm=new OleDbCommand("select top 1 from Comm_apply order by appid desc",BDConn);
BDRead=BDComm.ExecuteReader();
BDRead=BDComm.ExecuteReader();
sqlString &= " VALUES (" & strSqlFieldValue & ")"
sqlString &= ";SELECT " & TableKey & " FROM " & strTableName
sqlString &= " WHERE (" & TableKey & "= @@IDENTITY)"mySqlCommand.Connection.Open()
lngNewRecordID = mySqlCommand.ExecuteScalarlngNewRecordID就是你刚刚新增的纪录id号