StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
9400722
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-02-22T18:25:45.187
FavoriteCount
0
LastActivityDate
2012-02-22T18:25:45.187
LastEditDate
LastEditorUserId
0
OwnerUserId
1214827
ParentId
5575971
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
When DataGridView binds to the DataSource (DataView, BindingSource, Table, DataSet+"tablename") in all cases it refere to the DataView. Get reference to this DataView and set Sort (and Filter) as you wish: <pre><code>DataView dv = null; CurrencyManager cm = (CurrencyManager)(dgv.BindingContext[dgv.DataSource, dgv.DataMember]); if (cm.List is BindingSource) { // In case of BindingSource it may be chain of BindingSources+relations BindingSource bs = (BindingSource)cm.List; while (bs.List is BindingSource) { bs = bs.List as BindingSource; } if (bs.List is DataView) { dv = bs.List as DataView; } } else if (cm.List is DataView) { // dgv bind to the DataView, Table or DataSet+"tablename" dv = cm.List as DataView; } if (dv != null) { dv.Sort = "somedate desc, firstname"; // dv.Filter = "lastname = 'Smith' OR lastname = 'Doe'"; // You can Set the Glyphs something like this: int somedateColIdx = 5; // somedate int firstnameColIdx = 3; // firstname dgv.Columns[somedateColIdx].HeaderCell.SortGlyphDirection = SortOrder.Descending; dgv.Columns[firstnameColIdx].HeaderCell.SortGlyphDirection = SortOrder.Ascending; } </code></pre> Note: Column names used in Sort and Filter correspond to the column names in DataTable, Column names in DataGridView are the names of controls used to display cells in dgv. You can get column name used in DataView like this: <pre><code>string colName = dgv.Columns[colIdx].DataPropertyName </code></pre> Depends of how do you want to track sorted columns (colSequence, colName, asc/desc, dgvColIdx) you may decide how to build Sort and Filter expression and set the SortGlyph in dgv (I made hardcode for simplicity).
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to sort data from DataGridView with automatically generated columns from BindingList?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USparfilko
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.