I have an old VB.NET application in production that recently developed an issue (probably caused while fixing something else, you know how that goes). The grid uses data from two SQL Server tables displayed on the same grid like this:
TableAcol1 TableAcol2 TableBcol3 TableBcol4 TableBcol5
col1 and col 2 are common keys in the database, with cascading enabled from TableA to TableB so when TableA updates col1 and/or col2 those changes are automatically applied to TableB in the database.
My problem comes in when updating TableB which gets a foreign key error (TableB is trying to update col1 and col2, but those original keys no longer exist) so I get a foreign key error.
Is there any sample code for this situation using Ultragrid with two tables?
I have a couple of other similar situations and would like to gig hire an UltraGrid ninja just to solve these issues. Where is the best place to do get qualified help?
Hi,
Display multiple sibling tables at the root level has never been a feature as far as I am aware. This was discussed here:
https://es.infragistics.com/community/forums/f/ultimate-ui-for-windows-forms/80278/bind-ultragrid-to-a-dataset-with-multiple-datatables
With that said if you cannot reproduce the behavior with the Microsoft DataGrid for Windows Forms and you are able to provide a sample that isolates the behavior we can take a look at it.