1 2 3 4 5 6 7 8 9 10 11 12 13 14
| command.CommandText = @"INSERT INTO Alarms VALUES ("
+ "@DeviceBearerId, "
+ "@time,"
+ "@position); "
+ " SET @returnid = SCOPE_IDENTITY();";
command.Parameters.Add(new SqlParameter("@DeviceBearerId", memopasAlarm.DeviceBearerId));
command.Parameters.Add(new SqlParameter("@time", memopasAlarm.Time));
command.Parameters.Add(new SqlParameter("@position", memopasAlarm.Position));
SqlParameter returnId = new SqlParameter("@returnid", SqlDbType.Int);
returnId.Direction = ParameterDirection.Output;
command.Parameters.Add(returnId);
command.ExecuteNonQuery(); |
Partager