Hi sir ,I want to Call Mysql Stored Procedure with parameters and its gives multiple rows. i want to perform 

1. storing results in datatable

2.perform some operations on each row

3. bind it to the gridview

I tried but first row of result set is stored in datatable. I want to all rows of stored procedure