gridview paging problem

Question

hi iam using asp.net2.0 with c#
In the gridview 1st column is checkbox,in my gridview iam using paging , iam dispalying data at page load,
when user selects the check box that records are stored in database.
but when i selects the checkbox at 1st page then it is
storing all the records but when i selects the 1st page records as well as 2nd page records
 then it is storing only second page records .

iwant to store all the records what ever  user has  selects the checkbox.
can you give me example which helps me.

Answer 1

Check this..It might be helpful.

http://humrahimcs.wordpress.com/2010/09/21/how-to-add-currency-symbol-in-gridview-priceamount-column/

Answer 2

thankx for reply but will it be work in case if i will display the total price....
because i think it will display an error during addition of price like "usd 1231 + usd 2465"

what will i do to resolve this problem.?

Answer 3

try this

before binding the datatable to gridview.
foreach(DataRow dr in datatable1)
{
dr["price"]=ConfigurationSettings.AppSettings["Currency"] + dr["Price"].ToString();
}

and in web.config.

<AppSettings>
<add key="Currency" value ="USD"/>
</AppSettings>