Click here to Skip to main content
Click here to Skip to main content

Data Debugger Visualizer

By , 30 May 2005
Rate this:
Please Sign up or sign in to vote.

Sample Image - DataDebuggerVisualizer.gif

Introduction

These data visualizers for Visual Studio 2005 extend the Special QuickWatch for a DataSet that I found invaluable in VS 2003.

What it does?

These visualizers provide the following features:

  • Visualization for DataSets, strongly typed DataSets, DataTables, DataViews, DataRows and DataColumns.
  • Modified rows display in red.
  • Modified cells display in bold red.
  • Added rows display in blue.
  • If deleted rows exist, they can be viewed by selecting the Deleted Rows radio button.
  • A Row Filter can be established for active or deleted rows, using standard row filter expressions.
  • Additional cell and row properties display in the bottom grid. These properties are: cell original value, cell error message, row state, row error message.
  • When visualizing a DataRow, the respective row will be selected in the visualizer's grid.
  • XML representation of the DataSet can be in the format generated by the XmlSerializer (as used by the Web Service framework, for example) or by the DataSet's WriteXmlSchema and WriteXml methods.

Using the code

For now, I'll leave examination of the code as an exercise for the reader.

Technical notes

  • The visualizer DLL file is installed into your [VS8]\Common7\Packages\Debugger\Visualizers directory as part of the build. To remove it, delete the DotNetDan.Visualizers.dll file.
  • Multi-threading is used to load the visualizer form at the same time as serializing across the data from the debuggee to the debugger process. This may not be the fastest technique on non-HyperThreaded single-CPU machines, and complicates the code, so is a potential refactor target.
  • The visualizers use the new binary RemotingFormat facility of the DataSet and DataTable objects for enhancing the performance of serializing the objects across the Debuggee and Debugger processes.
  • At the time of writing, the DataGridView control wasn't particularly well documented and so getting the styles right was of more effort than expected and may not be the best way.
  • Programmatically selecting a row inside of a DataGridView (or DataGrid) is still way too hard. It requires a combination of DataViews, BindingSources and brute force. See DataTableVisualizerTab.OnVisibleChanged for the code that does the trick.
  • The bottom "grid" that displays additional cell and row properties consists of text boxes and uses the .NET 2.0 IPropertyChange interface of the DataTableProperties object for its binding.
  • I intend to look at enabling modifications to the data in the near future. Oh yeah, and improve the icons. Smile | :)

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

About the Author

dotnetdan

Australia Australia
No Biography provided

Comments and Discussions

 
QuestionNice post PinmemberTridip Bhattacharjee12-Dec-13 21:51 
GeneralVisual Studio 2008 PinmemberJimSchultz7423-Apr-08 7:32 
GeneralRe: Visual Studio 2008 PinmemberAbsurdChampion26-Aug-08 10:43 
GeneralEnhancement needed Pinmemberabdu21-Mar-07 13:56 
GeneralNice! PinmemberLowOrbit8-Nov-06 16:59 
GeneralGood work [modified] PinmemberDanMyNews19-Jul-06 20:02 
QuestionHow do I use it? Pinmemberhongze1-Feb-06 6:14 
Questionisn't it built-in functions in vs.net 2005? PinmemberUnruled Boy30-May-05 3:23 
AnswerRe: isn't it built-in functions in vs.net 2005? PinmemberMP3Observer30-May-05 21:53 
AnswerRe: isn't it built-in functions in vs.net 2005? Pinmemberdotnetdan2-Jun-05 1:14 
GeneralRe: isn't it built-in functions in vs.net 2005? PinmemberToAoM30-Nov-05 10:19 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web02 | 2.8.140421.2 | Last Updated 30 May 2005
Article Copyright 2005 by dotnetdan
Everything else Copyright © CodeProject, 1999-2014
Terms of Use
Layout: fixed | fluid