I have a windows app written in VB which I connect to an SQL Server using OLEDB (I plan on looking at the SQLClient). I change the data displayed in the grid to contain the vailues of one of several stored procedure.
During the process of switching stored procs and data display, I build columns objects, accululate them in a gridstyles collection, and add that to a tablestyles object and merrily see the data displayed on the grid.
For some reason though, when I go to bind the datagrid to another stored procedure I am having problems with the databrid apparently holding the previous mapping names with null values for them, and showing them, along with the requested columns, on the grid. I steo through the code and see that I clear the the datagrid table styles and gridstyles collections and still the "old" mapped columns stick.
And and all suggestions and this would be greatly appreciated.
During the process of switching stored procs and data display, I build columns objects, accululate them in a gridstyles collection, and add that to a tablestyles object and merrily see the data displayed on the grid.
For some reason though, when I go to bind the datagrid to another stored procedure I am having problems with the databrid apparently holding the previous mapping names with null values for them, and showing them, along with the requested columns, on the grid. I steo through the code and see that I clear the the datagrid table styles and gridstyles collections and still the "old" mapped columns stick.
And and all suggestions and this would be greatly appreciated.