How do I sort a column in a datagrid that is not attached to the query.

Also check these links

http://msdn.microsoft.com/en-us/library/ms171608.aspx

http://p2p.wrox.com/c/45179-column-sorting-formatting-ms-datagrid.html

http://www.vb-tips.com/dbpages.aspx?IA=DG2

http://www.eggheadcafe.com/tutorials/aspnet/801fd1b4-eec9-4999-82ef-109cb4345c0f/custom-sorting-using-the.aspx

I am going to try what you said above. I dont need to actually know how many matches there are.. Just that they are in order.. So if they don't match then they can hang out at the bottom or top of the datagrid.. dosent matter.. :) I have a binding Navigator that keeps a count.. that is good enough for them.

It seems that there is an issue when trying to sort a column that is attached to a datasource.. Some your third link seems to point out that his example would not work if it was attached.

So far I have been able to sort the Unit Numbers.. but if I click on the column title.. it erases all results in column 2 and 3.. NOT GOOD..

When I click on column header.. nothing happens...

I will keep review examples..

I was unable to make understand the first time that you should make changes in the dataset rather than the grid directly. That is why you are losing data. What is the name of the datasource to your grid? If unsure, check the Form_Load event of your form.

The name of the DataSource is Parvo_All_ReportBindingSource.

I just need to sort all three columns on the 3rd column ordered by earliest time to latest time.

Also.. I have a form 1 which has all three of my columns.. before I added columns 2 and 3 I created a inherited form (form 2). Later on I added columns 2 and 3 to form 1. I notice that unless I run my project I do not see column 2 and 3 on form 2. Should I be doing some kind of re-compileing of inheritance to form 2 from form 1???

The columns are being added at runtime so nothing to worry. Do you save the changes made in the grid? Are you using the binding source anywhere else?

No I don't save the changes.. I have a print button.. They print out the results.. A hard copy is all they need. The only other use for the binding source is a on a fill tool strip.. this is where the parameters are located so the user can enter in the data and then hit the fill button (connected on the tool strip) to populate the unit numbers column..

It may be too late at this stage but if i was doing this form, i would not have used the bindingsource. I would not have used the designer for database. I would design the interface, then i would write some code like this

Dim dbadp as New SQLDataAdapter("select ...", connectionstring)
Dim dTable As New DataTable
dbadp.Fill(dTable)
dbadp.dispose
dTable.Columns.Add("Match", GetType(String))
dTable.Columns.Add("TimeStamp", GetType(DateTime))
grid.datasource = dTable

Did you receive my electronic mail?

Your right.. it is most likely to late for me to re-vamp the project.. I would need to do it over the weekend or copy the program and make changes to the program over the weekend..
What I really should do is have a test program and then a live program.. I never did that in the beginning..

I need to make changes..but they also need to use the program..

I did not receive your email... My email is jbarman@mvrbc.com

i sent you an email from my other address. Check your spam folder.

Got it!! :)

Hmm Good. I suggest that you make a copy of your project and try to modify the code as i suggested.

I made a copy of my project.. but I think for this project being that the only thing left to do is find a way to get the 3rd column to sort.. I think I should finish this and start on the next.

My next project is almost exactly the same as this one.. I am not sure how to "design" the interface..
I am not sure where to place the code you provided eaither..

I also found that when I add a 3rd column.. Print doesn't work.. I was thinking of concatinating Match and timestring just so the the print will work.. This project is getting kinda messy.. YUCK...

hmmmm... this is getting hairy..

I am still having sorting issues..

Can you think of anyway to fix this as the program stands now?

Figured out how to get the print to work.. I added the columns to the actual Parvo_All_Reports DataSet..

NOW.. for the figure out how to sort.. ugggg... You have probably gone home for the day.. :)

Great Work!!

I had gone home. Is sorting still not working?

Sorting is working Great!! :)

I just had to add the 2 new columns to the dataset :) You were right.. nothing that I needed to work was working because everything was focused on the bound datasource..

Now.. granted.. I am using timestring... I never did find out how to make the numbering system work...

I am getting ready to start a new project.. very similiar to what I just did.. :)

Morning. If you want to try the numbering, copy the project into a test project (just copy the whole project folder and open in VS) and similarly add another column to the dataset. Then use my code to try the numbering. Remember to adjust to column indices accordingly.