dataview, which row is selected

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul Wohlhart - 25 Nov 2005 13:03 GMT

hi

i'm a complete newby to the adonet stuff. so i'm facing beginner problems.

i have a DataGrid bound to a table called data

dataGrid.DataSource = data;

data gets filled by a DataAdapter da

da.fill(data);

the table has two rows: "id" and "name".
since i inserted a TableStyle to the DataGrid the grid shows
only the "name".

now if someone clicks the "name" i need to the matching "id".
(shouldn't this be damn simple?)

The only thing i found is dataGrid.CurrentCell.RowNumber which
for sure is just the number of the row in the dataGrid,
not in the Table. Isn't there something like a
cursor/current-/active-cell/row in the Tabel that gets updated when
i click on a row in the DataGrid?

thanks,
paul

Reply to this Message

Bart Mermuys - 25 Nov 2005 13:26 GMT

Hi,

> hi
>
[quoted text clipped - 20 lines]
> cursor/current-/active-cell/row in the Tabel that gets updated when
> i click on a row in the DataGrid?

A question that has been asked many times.

You have to know that even when you bind a DataTable to a DataGrid it
actually uses a DataView internally. A DataTable isn't directly bindable
nor sortable while a DataView is both.

A CurrencyManager manages a list binding and the position, you can get the
relevant CurrencyManager using BindingContext[...]. A CurrencyManager
exposes some usefull properties:
- Position ( = CurrentRowIndex )
- List ( = DataView)
- Current ( = DataRowView).

Now, it's possible to get the value for id from the Current DataRowView:

public void ShowCurrentId()
{
DataRowView currentDRV = (DataRowView)
BindingContext[dataGrid1.DataSource, dataGrid1.DataMember].Current;

Console.WriteLine( currentDRV["id"] );
}

HTH,
Greetings

> thanks,
> paul

Reply to this Message

Paul Wohlhart - 25 Nov 2005 13:54 GMT

> A question that has been asked many times.

I thought so. Obviously the msdn lacks an easy to find pointer to those
things or people like me are to dumb to find them.

CurrencyManager was the keyword, now i got it.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbco
nconsumersofdataonwindowsforms.asp

> HTH,
> Greetings

sure that helps.
you're kind of hyperactive in here. great work, keep it up
and thanks a lot.

paul

Reply to this Message

Bart Mermuys - 25 Nov 2005 14:36 GMT

Hi Paul,

>> A question that has been asked many times.
>
> I thought so. Obviously the msdn lacks an easy to find pointer to those
> things or people like me are to dumb to find them.

I wasn't really implying anthing, but i agree it could be more documented.

> CurrencyManager was the keyword, now i got it.
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbco
nconsumersofdataonwindowsforms.asp

Don't forget the other stuff about the DataView/DataRowView i mentioned.

>> HTH,
>> Greetings
>
> sure that helps.
> you're kind of hyperactive in here. great work, keep it up

I'll try.

> and thanks a lot.

You're welcome.

Greetings

> paul

Reply to this Message

dataview, which row is selected

Free Magazines