Datagrids

I need to know how to arrange the columns in my data grid to any order, VB is doing it alphabetically by itself. In my access database they are in the order I want them, but vb just rearranges them?

Any Suggestions?

I think if you just set the datasource and datamember of a datagrid, by default it sets the columns according to the order they are added to your dataset table, and this order is determined by the way you select your columns when you make a dataadapter, if you select * (all) they are added in alphabetical order.

If you want to change the order at datagrid level you have to add a Tablestyle to your datagrid Tablestyles collection and then DataGirdColumnStyle to GridColumnStyles collection of that Tablestyle and set the mapping name for each column. Here you can rearrange them and set more properties of each column for example being Read-Only and so on. There is quite a good documentation about this in MSDN.

thanks that exactly what I did was select "all", theres my problem.