Filtering problem.... urgent please help

[Ubi]

hi
i have a problem with System.Data.DataViewRowState.

i have a ReadOnly datagrid,
a dataView and a dataTable.

i'm using the dataView's filter property to filter the data (firstName =
'Dani').
the problem is that i don't understanh how the ViewRowState works:
i have an external form that changes the value of the dataTable.
when it changes a row (even when the firstName col is not changed). the row
disappears; when a row that wasn't in the view before (because it's name want
Danni) changes to firstName->Danni, it doesn't appear in the view although it
should be...

please please help!

[Zürcher See]

Each DataRow has the readonly property RowState.
When you change a value in a row, also the RowState is changed to "Modified"
If you add a row, this row will have a RowState="Added "
If you delete a row, this row will be marked as "Deleted"

If you call the AcceptChages() method of the DataRow/DataTable, all the
chages made to the rows will take place and all the state of the rows are
set to "Unchanged"
If you call the RejectChages() method of the DataRow/DataTable, all the
chages made to the rows will be discarded and all the state of the rows are
set to "Unchanged"

DataView is able to filter also the RowState, if you are not intrested to
filter the rowstate set the
DataView.RowStateFilter=DataViewRowState.CurrentRo ws

"Ubi" <Ub*@discussions.microsoft.com> schrieb im Newsbeitrag
news:EB**********************************@microsof t.com...

hi
i have a problem with System.Data.DataViewRowState.

i have a ReadOnly datagrid,
a dataView and a dataTable.

i'm using the dataView's filter property to filter the data (firstName =
'Dani').
the problem is that i don't understanh how the ViewRowState works:
i have an external form that changes the value of the dataTable.
when it changes a row (even when the firstName col is not changed). the row disappears; when a row that wasn't in the view before (because it's name want Danni) changes to firstName->Danni, it doesn't appear in the view although it should be...

please please help!

[Ubi]

this is now working...

my code is something like
dataTable dt = new DataTable("tbl");
dataView dv = new DataView();
dv.Table = dt;

dt.Colums.Add("firstName");
dt.Colums.Add("lastName");

dataRow dr = dt.NewRow();

dv.Filter = "firstName = 'A'";

dr["firstName"]="A";
dr["lastName'']="bla bla";
dt.Rows.Add(dr);

dataGrid1.dataSource = dv;

NOW, THIS ROW WILL BE SHOWN, BUT IF I SO SOMETHING LIKE:
dr = dt.Rows[0];
dr["lastName"] = "bla bla bla bla";
dt.AcceptChanges();

THE ROW WILL DISAPPEAR (even thought i didn't change the first name at all).
I've tried using : dv.RowStateView = Current but it didn't work...

please help
"Zürcher See" wrote:

Each DataRow has the readonly property RowState.
When you change a value in a row, also the RowState is changed to "Modified"
If you add a row, this row will have a RowState="Added "
If you delete a row, this row will be marked as "Deleted"

If you call the AcceptChages() method of the DataRow/DataTable, all the
chages made to the rows will take place and all the state of the rows are
set to "Unchanged"
If you call the RejectChages() method of the DataRow/DataTable, all the
chages made to the rows will be discarded and all the state of the rows are
set to "Unchanged"

DataView is able to filter also the RowState, if you are not intrested to
filter the rowstate set the
DataView.RowStateFilter=DataViewRowState.CurrentRo ws

"Ubi" <Ub*@discussions.microsoft.com> schrieb im Newsbeitrag
news:EB**********************************@microsof t.com...

hi
i have a problem with System.Data.DataViewRowState.

i have a ReadOnly datagrid,
a dataView and a dataTable.

i'm using the dataView's filter property to filter the data (firstName =
'Dani').
the problem is that i don't understanh how the ViewRowState works:
i have an external form that changes the value of the dataTable.
when it changes a row (even when the firstName col is not changed). the

row

disappears; when a row that wasn't in the view before (because it's name

want

Danni) changes to firstName->Danni, it doesn't appear in the view although

it

should be...

please please help!

[Ubi]

this is now working...

my code is something like
dataTable dt = new DataTable("tbl");
dataView dv = new DataView();
dv.Table = dt;

dt.Colums.Add("firstName");
dt.Colums.Add("lastName");

dataRow dr = dt.NewRow();

dv.Filter = "firstName = 'A'";

dr["firstName"]="A";
dr["lastName'']="bla bla";
dt.Rows.Add(dr);

dataGrid1.dataSource = dv;

NOW, THIS ROW WILL BE SHOWN, BUT IF I SO SOMETHING LIKE:
dr = dt.Rows[0];
dr["lastName"] = "bla bla bla bla";
dt.AcceptChanges();

THE ROW WILL DISAPPEAR (even thought i didn't change the first name at all).
I've tried using : dv.RowStateView = Current but it didn't work...

please help
"Zürcher See" wrote:

Each DataRow has the readonly property RowState.
When you change a value in a row, also the RowState is changed to "Modified"
If you add a row, this row will have a RowState="Added "
If you delete a row, this row will be marked as "Deleted"

If you call the AcceptChages() method of the DataRow/DataTable, all the
chages made to the rows will take place and all the state of the rows are
set to "Unchanged"
If you call the RejectChages() method of the DataRow/DataTable, all the
chages made to the rows will be discarded and all the state of the rows are
set to "Unchanged"

DataView is able to filter also the RowState, if you are not intrested to
filter the rowstate set the
DataView.RowStateFilter=DataViewRowState.CurrentRo ws

"Ubi" <Ub*@discussions.microsoft.com> schrieb im Newsbeitrag
news:EB**********************************@microsof t.com...

hi
i have a problem with System.Data.DataViewRowState.

i have a ReadOnly datagrid,
a dataView and a dataTable.

i'm using the dataView's filter property to filter the data (firstName =
'Dani').
the problem is that i don't understanh how the ViewRowState works:
i have an external form that changes the value of the dataTable.
when it changes a row (even when the firstName col is not changed). the

row

disappears; when a row that wasn't in the view before (because it's name

want

Danni) changes to firstName->Danni, it doesn't appear in the view although

it

should be...

please please help!

[Zürcher See]

Disappears only the changed row or all rows disappear?
"Ubi" <Ub*@discussions.microsoft.com> schrieb im Newsbeitrag
news:BA**********************************@microsof t.com...

this is now working...

my code is something like
dataTable dt = new DataTable("tbl");
dataView dv = new DataView();
dv.Table = dt;

dt.Colums.Add("firstName");
dt.Colums.Add("lastName");

dataRow dr = dt.NewRow();

dv.Filter = "firstName = 'A'";

dr["firstName"]="A";
dr["lastName'']="bla bla";
dt.Rows.Add(dr);

dataGrid1.dataSource = dv;

NOW, THIS ROW WILL BE SHOWN, BUT IF I SO SOMETHING LIKE:
dr = dt.Rows[0];
dr["lastName"] = "bla bla bla bla";
dt.AcceptChanges();

THE ROW WILL DISAPPEAR (even thought i didn't change the first name at all). I've tried using : dv.RowStateView = Current but it didn't work...

please help
"Zürcher See" wrote:

Each DataRow has the readonly property RowState.
When you change a value in a row, also the RowState is changed to "Modified" If you add a row, this row will have a RowState="Added "
If you delete a row, this row will be marked as "Deleted"

If you call the AcceptChages() method of the DataRow/DataTable, all the
chages made to the rows will take place and all the state of the rows are set to "Unchanged"
If you call the RejectChages() method of the DataRow/DataTable, all the
chages made to the rows will be discarded and all the state of the rows are set to "Unchanged"

DataView is able to filter also the RowState, if you are not intrested to filter the rowstate set the
DataView.RowStateFilter=DataViewRowState.CurrentRo ws

"Ubi" <Ub*@discussions.microsoft.com> schrieb im Newsbeitrag
news:EB**********************************@microsof t.com...

hi
i have a problem with System.Data.DataViewRowState.

i have a ReadOnly datagrid,
a dataView and a dataTable.

i'm using the dataView's filter property to filter the data (firstName = 'Dani').
the problem is that i don't understanh how the ViewRowState works:
i have an external form that changes the value of the dataTable.
when it changes a row (even when the firstName col is not changed).

the row

disappears; when a row that wasn't in the view before (because it's

name want

Danni) changes to firstName->Danni, it doesn't appear in the view

although it

should be...

please please help!

[Zürcher See]

No idea, after changing the lastname to 'bla bla bla' control if the the row
firstname is still 'A'

"Ubi" <Ub*@discussions.microsoft.com> schrieb im Newsbeitrag
news:C0**********************************@microsof t.com...

Only the changed row disappear...

"Zürcher See" wrote:

Disappears only the changed row or all rows disappear?
"Ubi" <Ub*@discussions.microsoft.com> schrieb im Newsbeitrag
news:BA**********************************@microsof t.com...

this is now working...

my code is something like
dataTable dt = new DataTable("tbl");
dataView dv = new DataView();
dv.Table = dt;

dt.Colums.Add("firstName");
dt.Colums.Add("lastName");

dataRow dr = dt.NewRow();

dv.Filter = "firstName = 'A'";

dr["firstName"]="A";
dr["lastName'']="bla bla";
dt.Rows.Add(dr);

dataGrid1.dataSource = dv;

NOW, THIS ROW WILL BE SHOWN, BUT IF I SO SOMETHING LIKE:
dr = dt.Rows[0];
dr["lastName"] = "bla bla bla bla";
dt.AcceptChanges();

THE ROW WILL DISAPPEAR (even thought i didn't change the first name at

all).

I've tried using : dv.RowStateView = Current but it didn't work...

please help
"Zürcher See" wrote:

> Each DataRow has the readonly property RowState.
> When you change a value in a row, also the RowState is changed to

"Modified"

> If you add a row, this row will have a RowState="Added "
> If you delete a row, this row will be marked as "Deleted"
>
> If you call the AcceptChages() method of the DataRow/DataTable, all the > chages made to the rows will take place and all the state of the rows

are

> set to "Unchanged"
> If you call the RejectChages() method of the DataRow/DataTable, all

the > chages made to the rows will be discarded and all the state of the

rows are

> set to "Unchanged"
>
> DataView is able to filter also the RowState, if you are not

intrested to

> filter the rowstate set the
> DataView.RowStateFilter=DataViewRowState.CurrentRo ws
>
> "Ubi" <Ub*@discussions.microsoft.com> schrieb im Newsbeitrag
> news:EB**********************************@microsof t.com...
> > hi
> > i have a problem with System.Data.DataViewRowState.
> >
> > i have a ReadOnly datagrid,
> > a dataView and a dataTable.
> >
> > i'm using the dataView's filter property to filter the data

(firstName =

> > 'Dani').
> > the problem is that i don't understanh how the ViewRowState works:
> > i have an external form that changes the value of the dataTable.
> > when it changes a row (even when the firstName col is not

changed). the

> row
> > disappears; when a row that wasn't in the view before (because

it's name

> want
> > Danni) changes to firstName->Danni, it doesn't appear in the view

although

> it
> > should be...
> >
> > please please help!
> >
>
>
>

[Ubi]

OK, thanks anyway

"Zürcher See" wrote:

No idea, after changing the lastname to 'bla bla bla' control if the the row
firstname is still 'A'

"Ubi" <Ub*@discussions.microsoft.com> schrieb im Newsbeitrag
news:C0**********************************@microsof t.com...

Only the changed row disappear...

"Zürcher See" wrote:

Disappears only the changed row or all rows disappear?
"Ubi" <Ub*@discussions.microsoft.com> schrieb im Newsbeitrag
news:BA**********************************@microsof t.com...
> this is now working...
>
> my code is something like
> dataTable dt = new DataTable("tbl");
> dataView dv = new DataView();
> dv.Table = dt;
>
> dt.Colums.Add("firstName");
> dt.Colums.Add("lastName");
>
> dataRow dr = dt.NewRow();
>
> dv.Filter = "firstName = 'A'";
>
> dr["firstName"]="A";
> dr["lastName'']="bla bla";
> dt.Rows.Add(dr);
>
> dataGrid1.dataSource = dv;
>
> NOW, THIS ROW WILL BE SHOWN, BUT IF I SO SOMETHING LIKE:
> dr = dt.Rows[0];
> dr["lastName"] = "bla bla bla bla";
> dt.AcceptChanges();
>
> THE ROW WILL DISAPPEAR (even thought i didn't change the first name at
all).
> I've tried using : dv.RowStateView = Current but it didn't work...
>
> please help
>
>
> "Zürcher See" wrote:
>
> > Each DataRow has the readonly property RowState.
> > When you change a value in a row, also the RowState is changed to
"Modified"
> > If you add a row, this row will have a RowState="Added "
> > If you delete a row, this row will be marked as "Deleted"
> >
> > If you call the AcceptChages() method of the DataRow/DataTable, all the > > chages made to the rows will take place and all the state of the rows are
> > set to "Unchanged"
> > If you call the RejectChages() method of the DataRow/DataTable, all the > > chages made to the rows will be discarded and all the state of the rows are
> > set to "Unchanged"
> >
> > DataView is able to filter also the RowState, if you are not intrested to
> > filter the rowstate set the
> > DataView.RowStateFilter=DataViewRowState.CurrentRo ws
> >
> > "Ubi" <Ub*@discussions.microsoft.com> schrieb im Newsbeitrag
> > news:EB**********************************@microsof t.com...
> > > hi
> > > i have a problem with System.Data.DataViewRowState.
> > >
> > > i have a ReadOnly datagrid,
> > > a dataView and a dataTable.
> > >
> > > i'm using the dataView's filter property to filter the data (firstName =
> > > 'Dani').
> > > the problem is that i don't understanh how the ViewRowState works:
> > > i have an external form that changes the value of the dataTable.
> > > when it changes a row (even when the firstName col is not changed). the
> > row
> > > disappears; when a row that wasn't in the view before (because it's name
> > want
> > > Danni) changes to firstName->Danni, it doesn't appear in the view
although
> > it
> > > should be...
> > >
> > > please please help!
> > >
> >
> >
> >