VB.NET

VB.NET RSS

Data from datatable after datagrid sorting

Please support our VB.NET advertiser: Intel Parallel Studio Home

•

Join Date: Oct 2006

Posts: 169

Reputation: ptaylor965 is an unknown quantity at this point

Solved Threads: 19

ptaylor965 ptaylor965 is offline

Offline

Junior Poster

Data from datatable after datagrid sorting

Jun 15th, 2007

I have a datatable (sqltable) and a datagrid (dgData)

if the user click the datagrid header the grid changes sort order
but when i try to get

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
Dim Row As DataRow
Row = sqlTable.Rows(dgData.CurrentCell.RowIndex)
Dim Row As DataRow
Row = sqlTable.Rows(dgData.CurrentCell.RowIndex)

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
Dim Row As DataRow = sqlTable.Rows(e.RowIndex)
Dim Row As DataRow = sqlTable.Rows(e.RowIndex)

the row returned is not the row selected in the datagrid

any ideas how to do this?

Thanks

•

Join Date: Dec 2008

Posts: 5

Reputation: chriswininger is an unknown quantity at this point

Solved Threads: 0

chriswininger chriswininger is offline

Offline

Newbie Poster

Re: Data from datatable after datagrid sorting

Dec 16th, 2008

Try this:

Dim bm As BindingManagerBase = _
dgData.BindingContext(dgData.DataSource, dgData.DataMember)

Dim Row As DataRow = bm.Current.Row

•

Join Date: Oct 2006

Posts: 169

Reputation: ptaylor965 is an unknown quantity at this point

Solved Threads: 19

ptaylor965 ptaylor965 is offline

Offline

Junior Poster

Re: Data from datatable after datagrid sorting

Dec 16th, 2008

Thanks for the post but since the question was asked on Jun 15th, 2007 I have found an easy answer

Help with Code Tags

VB.NET Syntax (Toggle Plain Text)

Protected dvMyData as New DataView

Then

Help with Code Tags

VB.NET Syntax (Toggle Plain Text)

dvMyData.Table = MyDataTable
dgData.DataSource = dvMyData

Then I can use

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
dim Row as DataRow = dvMyData(dgDataGrid.CurrentRow.Index)
dim Row as DataRow = dvMyData(dgDataGrid.CurrentRow.Index)

This has been the best and I have been using it for several months now.

Thanks
Peter

Peter Taylor
Visual Basic.NET Application Developer

TaylorsNet
http://www.taylorsnet.co.uk

Quick Reply to Thread

Show Printable Version

Similar Threads

Datagrid to draw a table (C#)
another one...selecing rows in datagrid and sorting with column headers (VB.NET)
Paging in dataGrid (ASP.NET)
Sorting in Python (Python)
IListSource does not contain any data sources (ASP.NET)
bubble sorting in an array (C)
ASP.NET: Context.Items.Add question (ASP.NET)

Other Threads in the VB.NET Forum

Previous Thread: scrollbar control that is changing its colour
Next Thread: Format Number

Thread Tools	Search this Thread
Show Printable Version Email this Page

DaniWeb Message

Cancel Changes