VB.NET RSS VB.NET RSS

Data from datatable after datagrid sorting

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

•
•
Join Date: Oct 2006
Posts: 169
Reputation: ptaylor965 is an unknown quantity at this point 
Solved Threads: 19
Sponsor
ptaylor965's Avatar
ptaylor965 ptaylor965 is offline Offline
Junior Poster

Data from datatable after datagrid sorting

 
0
  #1
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
VB.NET Syntax (Toggle Plain Text) 
  1. Dim Row As DataRow
  2. Row = sqlTable.Rows(dgData.CurrentCell.RowIndex)
or
VB.NET Syntax (Toggle Plain Text) 
  1. 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
Reply With Quote Quick reply to this message  
•
•
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

 
0
  #2
Dec 16th, 2008
Try this:

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

Dim Row As DataRow = bm.Current.Row
Reply With Quote Quick reply to this message  
•
•
Join Date: Oct 2006
Posts: 169
Reputation: ptaylor965 is an unknown quantity at this point 
Solved Threads: 19
Sponsor
ptaylor965's Avatar
ptaylor965 ptaylor965 is offline Offline
Junior Poster

Re: Data from datatable after datagrid sorting

 
0
  #3
Dec 16th, 2008
Thanks for the post but since the question was asked on Jun 15th, 2007 I have found an easy answer

VB.NET Syntax (Toggle Plain Text) 
  1. Protected dvMyData as New DataView
Then
VB.NET Syntax (Toggle Plain Text) 
  1. dvMyData.Table = MyDataTable
  2. dgData.DataSource = dvMyData
Then I can use
VB.NET Syntax (Toggle Plain Text) 
  1. 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
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the VB.NET Forum
Thread Tools Search this Thread



"crystal .net .net2005 30minutes 2008 access add arithmetic array assignment basic binary box button buttons center click code combobox component connectionstring convert cpu data database databasesearch datagrid datagridview design dissertation dissertations dissertationthesis dosconsolevb.net editvb.net employees excel exists firewall folder image images isnumericfuntioncall listview login math memory mobile module ms msaccess mssqlbackend mysql navigate net opacity pan peertopeervideostreaming picturebox picturebox1 plugin port print printpreview problemwithinstallation project record regex reports" reuse right-to-left save savedialog serial server sorting sql sqldatbase storedprocedure string temp textbox timer updown upload useraccounts usercontrol vb vb.net vb.netcode vb.nettoolboxvisualbasic2008sidebar vbnet view vista visual visualbasic visualbasic.net visualstudio web wpf xml
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC