I am working on an ERP that is dealing with datasets a lot, and every time I need to know the contents of the dataset during debugging I try to make a quick watch but it has caused me headaches so I decided to make my own dataset quick watch.
How does it work?
I wrote my code using C#. I started by creating an Extensibility Projects from VS.NET's New Project menu. The wizard shows up and now the main idea behind this addin is how to pass an object from the VS.NET debug mode to the add-in. I did a lot of search but I did not find anything. The only way to know what is going in the debug mode is to use
How did I insert my button in the context menu?
The wizard adds the created button (
Command) in the Tools menu so I need to change the Tools to the context menu and to do that I replaced the
Code Window, noting that the status for the command is
(int)vsCommandStatus.vsCommandStatusUnsupported +(int)vsCommandStatus.vsCommandStatusInvisible to show it just when I need it:
Command command = commands.AddNamedCommand ( addInInstance, DSWatchNode ,
DataSet Quick Watch, DataSet Quick Watch, true, 60, ref contextGUIDS,
CommandBar commandBar = (CommandBar)commandBars[Code Window];
CommandBarControl commandBarControl = command.AddControl(commandBar, 1);
I have found a great article talking about addin and context menu in code project written by Erick Sgarbi called strongly typed collection
and it was very useful
How to know if the selected test is a dataset?
After capturing the selected text i can use it as an expression in the
Debugger.GetExpression() method of the application and evaluate anything I want. Now I will try to cast the selected text to dataset by evaluating the following:
_TextSelection = (TextSelection) applicationObject.ActiveDocument.Selection;
str = _TextSelection.Text;
applicationObject.ActiveDocument.FullName.Length-2 ) ;
isDataSetExpression="ctype("+ str +",System.Data.DataSet).Tables";
getXmlExpression="ctype("+ str +",System.Data.DataSet).GetXml()";
expr = debugger.GetExpression(isDataSetExpression,true,500);
System.Windows.Forms.MessageBox.Show("This is not a DataSet!");
expr object does not have error message it will be a dataset:
System.Windows.Forms.MessageBox.Show(this is not DataSet!!);
How to get the content of the dataset?
I could not get the object from the debugging project so I have to know the selected dataset XML contents by evaluating
Using the code
Run the add-in setup file and after installing the add-in you will be able to watch any dataset by selecting it in the debug mode and choosing "DataSet Quick Watch" from right-click menu.