How to sort a datagrid on form load? 2

[markdmac]

I have a form with a datagrid on it. The table only has two columns. I'm only showing one of those columns. The column I am showing is called "Categories". The hidden field is the primary key and the data is being sorted on that by default.

When the form opens I can click the header in the datagrid and get the data to sort by the Category. Is there a way to sort on this column at form load?

All of my searches have resulted in solutions that involved adding of additional columns which just doesn't seem right to me. If I can click it, there should be a way to mimic that event in code right?

Any assistance is greatly appreciated.

 

[Kliot]

You didn't specify how you are populating the datagrid, normally when I want to sort a datagrid I do the sorting with the query that I populate the datagrid with. Other than that you can use the bindingsource.sort to sort data the way you want it.

 

[RiverGuy]

Another method:

        Dim dv As New DataView
        dv.Table = YourDataTable
        dv.Sort = "Category"
        YourDataGridView.DataSource = dv

 

[markdmac]

Thank you both. I ended up using kliot's suggestion since it was the easiest to implement, however it is great to know how to do it programatically as well.

My user interface if for the most part done. Now I need to move on to more difficult tasks. Will start a new thread after I do some searching to try to help myself before asking for help.

Thanks again guys. Your help has been much appreciated and is helping me to discover parts of Visual Basic I didn't know existed.

 

[Kliot]

Glad to help, I remember how much fun it was when I started learning vb.net, not. Post if you get stuck again.

Perrin