Hi
I am using a WinGrid bound to a LinqToSQL datasource
I am displaying my USERS table, which has a relationship to virtually every other table in my database
What is happening is that the WinGrid doesn't just get the USER data, its getting the data for all the connected tables
I have set the grid viewstyle to SingleBand and the hide property to true against all the other tables in the column band editor
SQLProfiler exposes the numerous data calls
I only want to get the user data, getting all the other data is slowing down my forms and caneing the database
Brilliant, that worked a treat, thanks so much
Try setting MaxBandDepth to 1.