F
FyinsFlip
Microsoft Data Access Blocks (SqlHelper) you can do an insert and get
the new row ID without using a stored procedure?
DataMembers.Car_IDObject = SqlHelper.ExecuteScalar( _connectionString ,
"INSERT INTO tCar (name) VALUES ('Ford') SELECT CAST(@@Identity AS
INTEGER) ", FillSqlParameter());
Is there a new line symbol I can add before the SELECT, like a ';'
or something?
--
Sincerely,
David Dimmer
Quality Builders of ASP.NET Web Sites
B: 414.769.1233
M: 414.688.3941
W: http://www.milwaukeewebdesigners.com/
the new row ID without using a stored procedure?
DataMembers.Car_IDObject = SqlHelper.ExecuteScalar( _connectionString ,
"INSERT INTO tCar (name) VALUES ('Ford') SELECT CAST(@@Identity AS
INTEGER) ", FillSqlParameter());
Is there a new line symbol I can add before the SELECT, like a ';'
or something?
--
Sincerely,
David Dimmer
Quality Builders of ASP.NET Web Sites
B: 414.769.1233
M: 414.688.3941
W: http://www.milwaukeewebdesigners.com/