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

Question

Hai i want to execute more than 1 sql command in a asp.net programone for count the number of rows in a tableanother for extract the fields from a table and display that using datareader Thank u

Krishna Garad · Answer

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.