After DataGrid Sort find Current Row?

[Becker]

Very simple, I have a datagrid on a windows form. I load some rows in it.
I click a column header and it sorts ascending. I click it again it sorts
descending. This is great, but what I want to do is after the sort, I want
to know what row is now the "selected" row. I want to do this so I can
update some stuff on the form that correlates to this row. This does not
seem so easy...please advise.

Thanks,
Ben

[Ken Tucker [MVP]]

Hi,

Use the currencymanager to get the row number. If your datagrid is
bound to a dataset.table use the dataset.table.d efaultview to get the
row.

http://www.onteorasoftware.com/downl...redcolumns.zip

Ken
--------------------

"Becker" <be*@benbecker. net> wrote in message
news:#I******** ******@TK2MSFTN GP10.phx.gbl:

Very simple, I have a datagrid on a windows form. I load some rows in it.

I click a column header and it sorts ascending. I click it again it sorts

descending. This is great, but what I want to do is after the sort, I
want
to know what row is now the "selected" row. I want to do this so I can
update some stuff on the form that correlates to this row. This does not

seem so easy...please advise.

Thanks,
Ben

--
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.230 / Virus Database: 263.3.3 - Release Date: 6/18/2004

[Becker]

Ken,

I'm confused. The example you pointed me to does the exact same thing I've
got now. When you click, it shows you the name of the current row pre-sort,
but when you let up and it sorts, it doesn't show the name of the post-sort
record that is selected.

What I want is after the sort, the row that is selected, I want to know it's
data values, not the record that used to be there before the sort. Make
sense? I've looked at an answer on syncfusion, and it uses the bindcast
thing, but it doesn't seem to work. I've not seen any working examples of
this. Any ideas?

Thanks,
Ben

"Ken Tucker [MVP]" <vb***@bellsout h.net> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..

Hi,

Use the currencymanager to get the row number. If your datagrid is
bound to a dataset.table use the dataset.table.d efaultview to get the
row.

http://www.onteorasoftware.com/downl...redcolumns.zip

Ken
--------------------

"Becker" <be*@benbecker. net> wrote in message
news:#I******** ******@TK2MSFTN GP10.phx.gbl:

Very simple, I have a datagrid on a windows form. I load some rows in it.
I click a column header and it sorts ascending. I click it again it sorts
descending. This is great, but what I want to do is after the sort, I
want
to know what row is now the "selected" row. I want to do this so I can
update some stuff on the form that correlates to this row. This does not
seem so easy...please advise.

Thanks,
Ben

--
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.230 / Virus Database: 263.3.3 - Release Date: 6/18/2004

[Cor Ligthert]

Hi Ben,

The first question, did you use the dataview as the datasource.

That solves the sort problem mostly, and than use the dataview as the
connection to your tables

I hope this helps?
(And when not reply)

Cor

Very simple, I have a datagrid on a windows form. I load some rows in it.
I click a column header and it sorts ascending. I click it again it sorts
descending. This is great, but what I want to do is after the sort, I want to know what row is now the "selected" row. I want to do this so I can
update some stuff on the form that correlates to this row. This does not
seem so easy...please advise.

Thanks,
Ben

[Cor Ligthert]

Hi Ben,

The first question, did you use the dataview as the datasource.

That solves the sort problem mostly, and than use the dataview as the
connection to your tables

I hope this helps?
(And when not reply)

Cor

Very simple, I have a datagrid on a windows form. I load some rows in it.
I click a column header and it sorts ascending. I click it again it sorts
descending. This is great, but what I want to do is after the sort, I want to know what row is now the "selected" row. I want to do this so I can
update some stuff on the form that correlates to this row. This does not
seem so easy...please advise.

Thanks,
Ben

[Ken Tucker [MVP]]

Hi,

Made a few changes I added a handler to the dataview list changed
event.

Changes to form load

DataGrid1.DataS ource = ds.Tables("Cate gories")
DataGrid2.DataS ource = ds.Tables("Empl oyees")
AddHandler ds.Tables("Cate gories").Defaul tView.ListChang ed,
AddressOf OnListChanged

Other changes

Private Sub DataGrid1_Mouse Down(ByVal sender As Object, ByVal e As
System.Windows. Forms.MouseEven tArgs) Handles DataGrid1.Mouse Down
Dim hti As DataGrid.HitTes tInfo = DataGrid1.HitTe st(e.X, e.Y)

If hti.Type = DataGrid.HitTes tType.ColumnHea der Then
'
' Just sorted
'

Trace.WriteLine (DataGrid1.Tabl eStyles(0).Grid ColumnStyles.It em(hti.Column). MappingName)
End If
End Sub

Protected Sub OnListChanged(B yVal sender As Object, ByVal args As
System.Componen tModel.ListChan gedEventArgs)
GetName()
End Sub

Private Sub GetName()
Dim cm As CurrencyManager =
CType(Me.Bindin gContext(DataGr id1.DataSource) , _
CurrencyManager )
Dim drv As DataRowView

drv = ds.Tables("Cate gories").Defaul tView.Item(cm.P osition)
Trace.WriteLine (drv.Item("Cate goryName").ToSt ring)
End Sub

Ken
----------------------
"Becker" <be*@benbecker. net> wrote in message
news:#I******** ******@TK2MSFTN GP11.phx.gbl:

Ken,

I'm confused. The example you pointed me to does the exact same thing
I've
got now. When you click, it shows you the name of the current row
pre-sort,
but when you let up and it sorts, it doesn't show the name of the
post-sort
record that is selected.

What I want is after the sort, the row that is selected, I want to know
it's
data values, not the record that used to be there before the sort. Make

sense? I've looked at an answer on syncfusion, and it uses the bindcast

thing, but it doesn't seem to work. I've not seen any working examples of

this. Any ideas?

Thanks,
Ben

"Ken Tucker [MVP]" <HYPERLINK
"mailto:vb***@b ellsouth.net"vb ***@bellsouth.n et> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..

Hi,

Use the currencymanager to get the row number. If your datagrid is
bound to a dataset.table use the dataset.table.d efaultview to get the
row.

HYPERLINK
"http://www.onteorasoft ware.com/downloads/coloredcolumns. zip"http://www.onte
orasoftware.com/downloads/coloredcolumns. zip

Ken
--------------------

"Becker" <HYPERLINK "mailto:be*@ben becker.net"be*@ benbecker.net> wrote
in message
news:#I******** ******@TK2MSFTN GP10.phx.gbl:

Very simple, I have a datagrid on a windows form. I load some rows
in
it.

I click a column header and it sorts ascending. I click it again it
sorts

descending. This is great, but what I want to do is after the sort,
I
want
to know what row is now the "selected" row. I want to do this so I
can
update some stuff on the form that correlates to this row. This
does
not

seem so easy...please advise.

Thanks,
Ben

--
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.230 / Virus Database: 263.3.3 - Release Date: 6/18/2004

--
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.230 / Virus Database: 263.3.6 - Release Date: 6/25/2004

[Becker]

No, thats probably my problem. I use datasource = ds.tables("tabl e")

I will try the ideas I've seen here.

Thanks!
Ben

"Cor Ligthert" <no**********@p lanet.nl> wrote in message
news:%2******** ********@TK2MSF TNGP10.phx.gbl. ..

Hi Ben,

The first question, did you use the dataview as the datasource.

That solves the sort problem mostly, and than use the dataview as the
connection to your tables

I hope this helps?
(And when not reply)

Cor

Very simple, I have a datagrid on a windows form. I load some rows in it. I click a column header and it sorts ascending. I click it again it sorts descending. This is great, but what I want to do is after the sort, I

want

to know what row is now the "selected" row. I want to do this so I can
update some stuff on the form that correlates to this row. This does not seem so easy...please advise.

Thanks,
Ben