Inserting row into user sorted, data-bound DataGridView

I'm trying to insert a new row at a specific location of a data-bound 
DataGridView. I understand that you would normally do that by inserting the 
row into the bound DataTable. 

The use case is sort of like an accounting situation with a "split" - I am 
entering donations made by donors, and I want another line in the DGV for a 
2nd donation by the same donor. When they click the "Split" button, a new 
row should appear right below the currently selected row, showing the same 
donor name.

The problem  is, I allow my users to sort the DGV by clicking on column 
headers. When they do that, the order of the rows in the DataGridView no 
longer matches the order of the rows in the DataTable, so I can't figure 
out how to get the correct position to insert the DataTable row at, so that 
when it appears in the DataGridView, it is immediately below the previously 
selected row (which it will be a partial copy of).

I think what is happening is that because the sort is on the DGV column, it 
automatically and immediately resorts after the column is added. Unless the  
current DGV sort is on the donor name column, this moves the new row away 
from the row it was supposed to be below.

None of the other solutions I have seen around this seem to take account of 
this sorting problem.

I saw one solution hinted at somewhere, where you add an extra column 
called, say, "Order", and fill in values that number the rows in the 
current correct sorted order (including the new row you are adding), then 
re-sort on Order. That seems to almost work (though not entirely) but it 
causes a big problem in determining which rows have been modified and need 
to be saved, because every row is modified by setting the Order column's 
value!

Any bright ideas? Thanks.

---------------------------
Dan Cooperstock
DONATION web site:  http://www.**--****.com/ 
DONATION Support forums:  http://www.**--****.com/ 
E-mail: mailto: XXXX@XXXXX.COM 
Home Phone: 416-423-9064

Consider what the maximum number of donations for an indivisual is likely to 
be and add a <Sequence> field to your table.  The sequence will start at 100 
for that each donor's first contribution so, each record picks up this value 
for the initial entry of the record.  Updates are still updates and not 
inserts.

Your sort will be a dual sort of column name, sequence.

If you discover that you have missed a sequence and need to instert on 
mid-sequence, you have 99 tries to do it.

The new sequence field should never need to be updated based on a column 
header sort.


BTW:
If you are using mouse up/down events to trap your column sort, how do you 
reference the column name?  I am using the following that works but wonder 
if there is a better way.

columnName = 
Me.OrdersTableStyleDataGridTableStyle.GridColumnStyles(i).MappingName

RB
-- 
remove underscore to send me mail, no spam

Unfortunately, my DGV is listing donations for all donors. So, the sort 
(based on clicking on column headers) might be on the Amount of the 
donation, across all donors. No sort using a new sequence number field 
will put a new row right below the current row, when they are sorted by 
amount.

In answer to your question, Robert, currently I'm not catching the 
ColumnHeaderClick event which is what triggers the sort, I'm just letting 
the sorts happen automatically. But I think in that event it is easy to 
find out which column was clicked.

"RB" < XXXX@XXXXX.COM > wrote in






-- 
---------------------------
Dan Cooperstock
DONATION web site:  http://www.**--****.com/ 
DONATION Support forums:  http://www.**--****.com/ 
E-mail: mailto: XXXX@XXXXX.COM 
Home Phone: 416-423-9064

Hi Dan,

Based on my understanding, you have a data bound DataGridView and want to 
add a similar row to the current selected row into the DataGridView and 
right after this row when you click a button on the form. If I'm off base, 
please feel free to let me know.

Firstly, we couldn't add a row into a DataGridView programmatically if the 
DataGridView is bound to a data source. So we have to add the new row into 
the data source. To get the newly added row to appear near the 'copied' 
row, we could sort the DataGridView by the particular column, in your case, 
the donor name column.

You may use BindingSource as the data source, i.e. bind the BindingSource 
to a DataSet and a DataTable in it and then bind the DataGridView to the 
BindingSource. To sort on a column, set the Sort property of the 
BindingSoure  to the column's name. 

The following is a sample. It requires to add a DataGridView and a Button 
on the form.

 private void Form1_Load(object sender, EventArgs e)
        {          
            BindingSource bs = new BindingSource(this.dataSet11, 
"DataTable1");
            this.dataGridView1.DataSource = bs;         
            // fill data into the data source
            DataSet1TableAdapters.StudentTableAdapter ta = new 
WindowsMediaPlayer.DataSet1TableAdapters.DataTable1TableAdapter();
            ta.Fill(this.dataSet11.DataTable1);
        }

private void button1_Click(object sender, EventArgs e)
        {
            DataRowView drv = this.dataGridView1.CurrentRow.DataBoundItem 
as DataRowView;

            if (drv != null)
            {
                DataRow row = this.dataSet11.DataTable.NewRow();
                // the first field is the primary key
                row[0] = some unique id ;
                row[1] = drv[1];
                row[2] = drv[2];
                this.dataSet11.Student.Rows.Add(row);
                (this.dataGridView1.DataSource as BindingSource).Sort = 
"ColumnName";
            }                    
        }

Hope this helps.
If you have any question, please feel free to let me know.

Sincerely,
Linda Liu
Microsoft Online Community Support

==================================================
Get notification to my posts through email? Please refer to 
 http://www.**--****.com/ #notif
ications.
 
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues 
where an initial response from the community or a Microsoft Support 
Engineer within 1 business day is acceptable. Please note that each follow 
up response may take approximately 2 business days as the support 
professional working with you may need further investigation to reach the 
most efficient resolution. The offering is not appropriate for situations 
that require urgent, real-time or phone-based interactions or complex 
project analysis and dump analysis issues. Issues of this nature are best 
handled working with a dedicated Microsoft Support Engineer by contacting 
Microsoft Customer Support Services (CSS) at 
 http://www.**--****.com/ 
==================================================
 
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Dan,

I am busy today so I haven't got a chance to research on this issue.

In addition, I will be OOF on the next Monday and Tuesday, so I will reply 
to you on the next Wednesday.

Sorry for the delay!

Have a nice weekend!

Sincerely,
Linda Liu
Microsoft Online Community Support

Hi Dan,

Thank you for your prompt response.

Since you'd like to customize sorting in the DataGridView, I suggest that 
you handle the SortCompare event of the DataGridView for your practice. You 
may refer to the following MSDN document for a sample of custom sorting 
using the SortCompare event, as well as other methods for custom sorting:

'How to: Customize Sorting in the Windows Forms DataGridView Control'
 http://www.**--****.com/ 

Hope this helps.
If you have any question, please feel free to let me know.


Sincerely,
Linda Liu
Microsoft Online Community Support

Hi Dan,

How about the problem now?

If you need our further assistance, please feel free to let me know.

Thank you for using our MSDN Managed Newsgroup Support Service!

Sincerely,
Linda Liu
Microsoft Online Community Support

Sorry Linda and Dan if I interposing me around this thread but I also 
troubling about DataGridView sort. I trying (I think like Dan) to disable 
automatic sort during adding data into a datagridview without success !!!

I creating a more or less complex structure which allows to sort,  search, 
update, insert datas into a DB table through a DataGridView (also above 
master DGV is linked to a detail DGVs in order to populate information 
related to detail tables).

So, my problem is that I want preserve all new rows added in the original 
position  and to trigger DGV sort on demand (e.g. after right commit) . It 
because my form check all data consistence during save data (by event 
handler) and due to the fact that utomatic sortspreads all new rows 
inside DGV (after each insert),  if error raised, I have to search where the 
new rows are.

So, keep in mind that I already read s171608.aspxand it seams that there 
isn into it solution at my problem. Also, keep in mind that I tried to 
handling utomatic sortby verrideof the class 
ataGridViewColumnHeaderCell(in order to handle{*filter*} on header column 
. For that I set ataGridViewColumnSortModeto rogrammatic(also I tried 
otSortablewith the same result) in order to manage GV.Sortmethod into 
my class.

It works right just until irst clickon header column (because ortMode
property disabled all). But after that, DGV (seams) captures ort method
and it restarts rows spreads again, as usual.

So, is it a bug ? Above is the right way to manage a sort via rogrammatic
status ,  isn it ?

Many Thanks for answer.





>
>>Hi Dan,
> 
> How about the >rob>em now?
> 
> If you need our further assistance, please feel free to >et >e know.
> 
> Thank you for using our MSDN Managed Newsgroup Supp>rt >ervice!
> 
> Microsoft Online Commu>ity>Support

Hi Gio,

I performed a test based on your description but didn't reproduce the 
problem on my side.

I add two DataGridViewTextBoxColumns in a DataGridView and set the SortMode 
property of the two DataGridViewTextBoxColumns to Programmatic. I run the 
application and no matter how many times I click on the header column, not 
sorting happens. 

You may have a try adding a standard DataGridViewTextBoxColumn in the 
DataGridView and set the column's SortMode property to Programmatic to see 
if the problem still exists.

Sincerely,
Linda Liu
Microsoft Online Community Support

Hi Gio,

I performed some tests based on your description and did reproduce the 
problem.

In my tests, the problem exists only when the DataGridView's bound to a 
data source. 

In fact, if the DataGridView is bound to a data source, when we call the 
DataGridView.Sort method to sort the grid programmatically, the sort is 
actually done by the underlying data source. 

Then the sort is maintained in the underlying data source. Any new data 
added into the data source after this will be shown in a 'proper' position 
in the DataGridView.

I suggest that you use BindingSource as the data source and call the 
RemoveSort method to remove the sort when you add new data in the data 
source.

Hope this helps.

Sincerely,
Linda Liu
Microsoft Online Community Support

Dear Linda,

I testing your suggestion and it seems is working right (I searched a 
method able to remove sort from DGV and, really, I did not see that it was 
there, under my nose !!!).

Thank you very much for your help.

Sincerely.
Gio