to execute more than 1 sql commands in a asp.net prgram

You can write two seperate method one for counting records and second for extracting. Call the method first which you need mean if you have to conut record first called contmethod and then call extract method ar vise-versa. you can go for batch sql but it is not updatable.