Resetting values in DataGrid

[Job Lot]

On form load my datagrid gets populated with values from database table. How
can I reset values in my DataGrid to 0 on click of a button?
thanks

[W.G. Ryan eMVP]

If I understand you correctly, you can call the .Clear method of the
datatable object its bound to. that will eliminate all of the rows and the
grid will be empty. Is this what you meant?
"Job Lot" <Jo****@discussions.microsoft.com> wrote in message
news:2F**********************************@microsof t.com...

On form load my datagrid gets populated with values from database table. How can I reset values in my DataGrid to 0 on click of a button?
thanks

[Job Lot]

Hi Ryan

Actually i don't want my DataGrid to get empty. I want to reset the value in
the cells (or values held in the datatable) to 0 (Zero). On click on button
it should change all the values to 0.

"W.G. Ryan eMVP" wrote:

If I understand you correctly, you can call the .Clear method of the
datatable object its bound to. that will eliminate all of the rows and the
grid will be empty. Is this what you meant?
"Job Lot" <Jo****@discussions.microsoft.com> wrote in message
news:2F**********************************@microsof t.com...

On form load my datagrid gets populated with values from database table.

How

can I reset values in my DataGrid to 0 on click of a button?
thanks

[Cor Ligthert]

Job,

You never can set a value in a datagrid (windowforms) to zero when the
underlaying datasource has another value than zero.

So when you want what you ask you have to set that field to zero. You can
reset a datarow by the original state (last filled) with
datarow.rejectchanges

I hope this helps?

Cor

"Job Lot" <Jo****@discussions.microsoft.com>

Actually i don't want my DataGrid to get empty. I want to reset the value in the cells (or values held in the datatable) to 0 (Zero). On click on button it should change all the values to 0.

"W.G. Ryan eMVP" wrote:

If I understand you correctly, you can call the .Clear method of the
datatable object its bound to. that will eliminate all of the rows and the grid will be empty. Is this what you meant?
"Job Lot" <Jo****@discussions.microsoft.com> wrote in message
news:2F**********************************@microsof t.com...

On form load my datagrid gets populated with values from database

table. How

can I reset values in my DataGrid to 0 on click of a button?
thanks

[Cor Ligthert]

br............

The rejectchanges reset untill the last acceptchanges to be more clear.

Cor