BindingSource Removing Current Row

[msnews.microsoft.com]

Greetings

I have a a simple application with 1 form. On my form I use a
BindingSource to bind a database table to a "table (gridDataView)" (one
in the database, one on my form, 2 different types of tables).

I want to remove the current row I tried :

GrantsBindingSo urce.RemoveCurr ent();

this removes it from the list on the form, but does not remove it from
the database, so I tried this :

GrantsBindingSo urce.RemoveCurr ent();
GrantsBindingSo urce.EndEdit();

this also did not work, so finally I uesd the following :

DataRowView drv = (DataRowView)gr antsBindingSour ce.Current;
AcroDataSet.Gra ntsRow row = (AcroDataSet.Gr antsRow)drv.Row ;
grantsTableAdap ter.Delete(row. login, row.application , row.level);
grantsBindingSo urce.RemoveCurr ent();

This "works" but seems like a lot to just remove the current record, is
there a "better" way? some way I can use the BindingSource natively and
remove the item from the "list" and the database at the same time?

thanks in advance
troy

[Nicholas Paldino [.NET/C# MVP]]

Troy,

No, there is not. The binding source connects to a disconnected data
set. When you remove the current row, assuming that you are using a DataSet
or DataTable, it sets the state of the row to delete. You have to pass that
DataSet/DataTable to a data adapter in order to have the database updated.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"msnews.microso ft.com" <tr*******@gmai l.comwrote in message
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..

Greetings

I have a a simple application with 1 form. On my form I use a
BindingSource to bind a database table to a "table (gridDataView)" (one in
the database, one on my form, 2 different types of tables).

I want to remove the current row I tried :

GrantsBindingSo urce.RemoveCurr ent();

this removes it from the list on the form, but does not remove it from the
database, so I tried this :

GrantsBindingSo urce.RemoveCurr ent();
GrantsBindingSo urce.EndEdit();

this also did not work, so finally I uesd the following :

DataRowView drv = (DataRowView)gr antsBindingSour ce.Current;
AcroDataSet.Gra ntsRow row = (AcroDataSet.Gr antsRow)drv.Row ;
grantsTableAdap ter.Delete(row. login, row.application , row.level);
grantsBindingSo urce.RemoveCurr ent();

This "works" but seems like a lot to just remove the current record, is
there a "better" way? some way I can use the BindingSource natively and
remove the item from the "list" and the database at the same time?

thanks in advance
troy

[Troy Bull]

Nicholas Paldino [.NET/C# MVP] wrote:

Troy,

No, there is not. The binding source connects to a disconnected data
set. When you remove the current row, assuming that you are using a
DataSet or DataTable, it sets the state of the row to delete. You have
to pass that DataSet/DataTable to a data adapter in order to have the
database updated.

So, am i doing this incorrectly? How do I pass the DataSet associated
with my BindingSource to a dataadapter?

Thanks
troy

[Nicholas Paldino [.NET/C# MVP]]

Troy,

The way you are doing it is right. I was just explaining why that way
was right.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Troy Bull" <tr*******@gmai l.comwrote in message
news:et******** ******@TK2MSFTN GP03.phx.gbl...

Nicholas Paldino [.NET/C# MVP] wrote:

>Troy,

No, there is not. The binding source connects to a disconnected data
set. When you remove the current row, assuming that you are using a
DataSet or DataTable, it sets the state of the row to delete. You have
to pass that DataSet/DataTable to a data adapter in order to have the
database updated.

So, am i doing this incorrectly? How do I pass the DataSet associated
with my BindingSource to a dataadapter?

Thanks
troy