I am using v2018.1 & VS2019 I have a wingrid tied to a dataset. I add new columns to the dataset and they show in the designer. But when I run the program they aren't visible. The new columns hidden property is false. What do I need to do to get the columns to show up?
Thanks
Steve
Hello,
Thank you for posting on our forums.
When do you add the new columns? If it is on runtime, do you have any change detection for your data source?
Or if you add them before you build the app, the new columns are not added to the data source and the grid loads the old one?\
Looking forward to your reply.
Sincerely,
Tihomir TonevAssociate Software DeveloperInfragistics
I changed the select sql statement for the table in the dataset designer. the table shows the new columns. when i then switch back to the ultragrid designer the new columns show up. when i then build/run the project they don't show.
Thank you for your reply.
At some point in your code you should probably have the following line:
this.ultraGrid1.DataSource = collection coming from SQL statement;
Is this collection updated with the new statement? Because if it is not, it will not be reflected when you build your app.
Here’s the code. The grid should change based on the new columns added to the data table.
Me.ugShippingLabelData.DataMember = "ShippingLabelData"
Me.ugShippingLabelData.DataSource = Me.Ds1
The grid works properly in that it shows data from the dataset table for the existing columns as below
However, the current design of the grid in the grid designer looks like this
So the issue is why doesn’t the runtime grid look like the designtime grid? Obviously the grid designer sees the new columns. it's like the build isn't looking at the new design of the grid. How can that be?
When do you call the select statement?
You assign .DataSource to .Ds1, but what is in .Ds1 at that point?
If Ds1 is a collection that implements INotifyPropertyChanged, when the select statement resolves, the grid will update. If it does not, and it takes some time for the server to respond, the grid won't know that the data has been updated and it will not show the new data.