如何得到一个update或者delete语句执行之后所影响的记录行数？

[bowlder]

同题。

[redcaff_l]

int count = 0;
SqlCommand cmd = new SqlCommand(sqlStr, conn);
count = cmd.ExecuteNonQuery();//受影响的行数

[netwalking]

在你的update或者delete语句后加上select @nowID = @@IDENTITY,你取得@nowID的值就可以了
就象：
this.sqlCommand1.CommandText = @"INSERT INTO dbo.imageStore(Data, ContentType, Description, Size, Store_DB, Store_ID) VALUES (@Data, @ContentType, @Description, @Size, @Store_DB, @Store_ID); SELECT img_ID, Data, ContentType, Description, Size, Store_DB, Store_ID FROM dbo.imageStore WHERE (img_ID = @@IDENTITY);select @nowID = @@IDENTITY";
....
this.sqlCommand1.Parameters["@nowID"].Direction=ParameterDirection.Output;