ADO.NET

There are 3 entries for the tag ADO.NET

SQL Command Visualizer for Visual Studio 2005

SQL Command Visualizer for Visual Studio 2005 will give you a visual representation of a SQL Command object, allowing you to work with the connection details, parameters, properties, and values. I can't remember the last time I actually worked with ADO.NET at this level, but still this could be very useful for anyone who still needs to work with SQL Commands.   Tags: Visual Studio, ADO.NET

Debugging DataSet Constraint issues

If you work with typed datasets often enough, then chances are that at some point you're going to run across this error message: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. The error message is logical enough - it tells you what's wrong. You have a dataset, and there's a piece of data which is violating it's constraints. If you have a small dataset, then you can usually spot where the problem lies quickly enough. However for larger datasets the offending table(s) and/or column(s) are usually harder...

Small DataSet tip - blank/empty .cs files

If you happen to press F7 in the while working in the DataSet designer, it will generate you a class file for your DataSet. If you've pressed F7 accidentally and dont want/need this file, then you might delete it at some point, or someone tidying up your code might decide to do it for you. The file might seem like an obvious candidate for deletion - the main hint being that it contains no code! However, if the file is simply deleted then your solution may no longer compile. The solution is pretty simple - you simply need...