We have a customization on the part tracker that shows all jobs listed for a part and a list of operations for each job. Currently, the customization looks for the most recent completed operation and colors all the operations that came before it to show where we are at on the job. We are trying to color each operation that has been marked as complete. To do this we have built a dictionary that should be populated by a dynamic query:
DynamicQueryDataSet ds = dynamicQuery.GetByID(EAB_PartTracker2);|
QueryExecutionDataSet execDS = new QueryExecutionDataSet();|
execDS.ExecutionParameter.AddExecutionParameterRow(PartNum, currentPartNum, nvarchar, false, Guid.NewGuid(), );
execDS.AcceptChanges();
dtResults.Clear();
dtResults = dynamicQuery.Execute(ds, execDS).Tables[Results];
However, only the first entry on the data grid is being populated instead of everything that is completed.
What we need is a way to see what all is being placed in the dictionary. The following code I believe should work, but when it runs no message box shows:
System.Text.StringBuilder b = new System.Text.StringBuilder();
foreach (System.Data.DataRow r in dtResults.Rows)
{
foreach (System.Data.DataColumn c in dtResults.Columns)
{
b.Append(c.ColumnName.ToString() + ":" + r[c.ColumnName].ToString());
}
}
MessageBox.Show(b.ToString());
Could someone help me understand what I need to change in order to make this code show a message box so I can troubleshoot what is in the dictionary?