dataset not getting data of the the datagrid

[anand]

hi,
let:

dataSet1 is having some data from database.

dataView1 = dataSet1.table( 0).defaultView
dataGrid1.dataS ource = dataView1
[.. programatically construct a tablestyle for the grid ..]
dataGrid1.Table Style.add(myTab leStyle1)

ok, now i show the datagrid on a form. the use left clicks on a cell,
changes a value, and WITHOUT CLICKING ON ANY OTHER CELL OF THE
DATAGRID,
clicks a button on the same form.

on button click, i do:

if dataSet1.HasCha nges(DataRowSta te.Modified) then
dataSet2 = dataSet1.GetCha nges(DataRowSta te.Modified)
end if

the problem is that dataSet2 has a table with one row, the row which
the use had clicked, BUT WITHOUT THE CHANGED DATA. it contains the
same old data with wich the grid was loaded initially.

is there any way out of this problem ? i need the changed data.
i have tried dataGrid1.refre sh et.al....

saha
--

[Cor]

Hi Anand,

I think you do a lot more than needed, but start with to try this before
that haschanges.

BindingContext( dataset1.tables (0)).EndCurrent Edit()

I hope this was the solution?

Cor

[james]

First question, if you re-connect to the database are the changes your user
makes, actually being written back to the database? If not, then that is
the reasons your changes are not showing up. I ran into the same problem
with an Access Database and got so frustrated that what I finally did (which
is not the "proper" way to do it) was to just re-connect to the database
AFTER deleting the current row that was being edited and adding it back to
the database as a NEW datarow. A very ugly work-around, but it works. I am
currently in the proccess of fixing that as that is not the way it is
supposed to work.
If you are using a DataAdaptor to get to your database, be sure you are
refreshing it too.
james

(I'm almost ashamed to post this, but, I understand the frustration of
working with Access Databases in VB.NET)

"anand" <an*******@redi ffmail.com> wrote in message
news:f7******** *************** ***@posting.goo gle.com...

hi,
let:

dataSet1 is having some data from database.

dataView1 = dataSet1.table( 0).defaultView
dataGrid1.dataS ource = dataView1
[.. programatically construct a tablestyle for the grid ..]
dataGrid1.Table Style.add(myTab leStyle1)

ok, now i show the datagrid on a form. the use left clicks on a cell,
changes a value, and WITHOUT CLICKING ON ANY OTHER CELL OF THE
DATAGRID,
clicks a button on the same form.

on button click, i do:

if dataSet1.HasCha nges(DataRowSta te.Modified) then
dataSet2 = dataSet1.GetCha nges(DataRowSta te.Modified)
end if

the problem is that dataSet2 has a table with one row, the row which
the use had clicked, BUT WITHOUT THE CHANGED DATA. it contains the
same old data with wich the grid was loaded initially.

is there any way out of this problem ? i need the changed data.
i have tried dataGrid1.refre sh et.al....

saha
--

[anand]

"Cor" <no*@non.com> wrote in message news:<eG******* ******@tk2msftn gp13.phx.gbl>.. .

Hi Anand,

I think you do a lot more than needed, but start with to try this before
that haschanges.

BindingContext( dataset1.tables (0)).EndCurrent Edit()

I hope this was the solution?

Cor

hi Cor,

i could solve it this way. before doing a dataset1.hascha nge, i did:

For Each cs As DataGridColumnS tyle In
dataGrid1.Table Styles(0).GridC olumnStyles

dataGrid1.Table Styles(0).EndEd it(cs,
datagrid1.Curre ntCell.RowNumbe r, False)

Next

then after doing a dataset1.hascha nge and before dataset1.getcha nge, i
did:

Dim rowIndex As Integer
rowIndex = baseDataGrid.Cu rrentRowIndex
dataGrid1.Curre ntRowIndex = 0
dataGrid1.Curre ntRowIndex = rowIndex

dataSet3 = dataSet1.GetCha nges(DataRowSta te.Modified)
it worked! the trick is, i think, that the changes appeared in
dataSet3 after i changed(shuffle d) the row index of the datagrid.
thanks for the hint.

saha
--