dataadpter.update() and response qsuestion

[dorothy2010]

Hi everyone

my application use dataadpter.update() to update inforamtion to database(ms sql), and get number of row affected.

when i insert new data to database (e.g. 100 rows), on the server side the stored procedure is going to filter those rows if it match the condition, then it will insert it, otherwise just not insert that rows.

as i said before, the appliction is going to response how many row affected.
it returns 100rows, no matter how many rows is actully insert to the database
question: how can i get the number of row that is actully been insert into the database

thx

[Nightwalker83]

Which language are you using?

[dorothy2010]

vb.net and ms sql