<div>
One easy way: fire Profiler, and steal the actual query (that's when it's sql server, obviously)
</div>


One easy way: fire Profiler, and steal the actual query (that's when it's sql server, obviously)

<div>
<div class="content wysiwyg-content">
This might sound lazy, but when you're working with OLEDBConnection &nbsp;command object, and you've added your parameters, and you have the command text a string with loads of @paramname's in, and it goes wrong!!! Often with not enough feedback.<br />
This might be firing at an mdb or SQL backend...is there a handy dandy extension that allows you to flip those values into a string so I can test it in a QBE grid or a SQL server management window, where I get more feedback?<br />
I know I should make my own, but I wondered if anyone had something out there...as it seems such a common hassle.
</div>
</div>


This might sound lazy, but when you're working with OLEDBConnection  command object, and you've added your parameters, and you have the command text a string with loads of @paramname's in, and it goes wrong!!! Often with not enough feedback.
This might be firing at an mdb or SQL backend...is there a handy dandy extension that allows you to flip those values into a string so I can test it in a QBE grid or a SQL server management window, where I get more feedback?
I know I should make my own, but I wondered if anyone had something out there...as it seems such a common hassle.

Handy Dandy CommandText

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.