Hi,
You should follow these steps:
Quote:
1. Fetch all the selected row from your gridview.
2. Store it in a string separated with comma. Like (2, 3, 4, 5)
3. Now use IN operator in your sql query. Like:
"SELECT * FROM stusub WHERE StuID IN '" + GridviewSelectedRows + "' ";
Here GridviewSelectedRows
is the the string which you are framing with comma separation.
4. Now get the recordset from database.
Follow the steps and try your best.
All the best.
--Amit