I am building a web page that will be presenting users two dataset results from two stored procedures in sql but the data is not similar. Is it possible to present both datasets to users in one datagridview? I am unable to do a union of the data in SQL due to the fact that the results aren't similar and wanted to see if I could work around this issue with .net.
Have you tried looping through your data sets? I've tried that in visual.net. If i can't come up with the desired output using one stored procedure, what I do is try to assign field values from both data sets (output of stored procedures) to each corresponding grid cell. This MIGHT require 2 loops (or two counters) since you have 2 data sets.