ADO.Net DBConnection Visualizer

dotnet framework


  • 1. DataSet Updates to/from Sql Server
    I'm creating a simple VB.Net application that uses a DataGridView in a form to show records originating in a Sql database. I have two questions related to keeping the data current and synchronized between the DataGridView and the Sql database. 1) What's the preferred method of invoking the SqlDataAdapter.Update method? I'd like it to be called anytime the DataTable in my DataSet has changed. I have added a handler for the DataTable.RowChanged event and am calling it there. 2) When the data changes in the source Sql Database, how do I propagate those changes to my DataSet? I seem to remember that the old RecordSet would do this automatically by declaring a "dynamic" cursor, but I don't see the equivalent in a DataSet. TIA
  • 2. Any book about writting secure ADO.NET code?
    I remember seeing it online, the book itself was available online not just an ad about it. Does any one knows any thing about it?
  • 3. Deploying SQL in VB applications
    Ok ok This is more than likley and OLD question but I've gone through msdn, the sql server sites and am no further forward. I use SQL 2000 developer edition and VS2003 (I have SQL 2005 developer but not installed yet) I have a simple database which I access through a front end. Works great on the development pc. I now need to transfer the lot(db & application) to another pc with NO SQL on it. Iv'e looke at msde using the developer kit but that don't work (keep getting the string to long error). Looked at SQL Express on the MS web site but its all in C# ! Somebody MUST know a straight forward way to do this Please Help!
  • 4. datasource and binding question
    I think this should be possible, but can't seem to figure out how to do this. i create a webform with three text boxes and buttons (4) I create a datasource by dragging and dropping it onto the form. I configure this datasource with select, update, insert, and delete SP's. Now i want to bind this data source to the three text boxes. so that i can call a select and an update , insert. Is this possible? I know the formview will do this, but i'd like to get a bit more flexability for more complex webforms. -- thanks (as always) some day i''m gona pay this forum back for all the help i''m getting kes

ADO.Net DBConnection Visualizer

Postby codemonkey » Thu, 27 Jul 2006 10:45:36 GMT

Hey Folks,

I've just finished an initial version of a de{*filter*} visualizer for 
Visual Studio 2005 that allows you to hover over an ADO.Net connection 
object and run quick SQL statements against it and see the results in a 
grid. Any feedback is much appreciated.

The add-on dll can be found at  http://www.**--****.com/ 

To install, simply copy the dll to "My Documents\Visual Studio 

I've only tried it with the SQLite provider for ADO.Net 
( http://www.**--****.com/ ), but it should work with any type of 
database connection that derives from System.Data.Common.DBConnection.

Let me know what you think (please reply to this post or use the 
SourceForge project forums).



Similar Threads:

1.Newbie Questions on ADO.NET in VB.NET(basically ADO.NET questions)

ok.  I have a basic understanding of the dataset but still more questions
than answers.

For example, if you use the Server Explorer to create connections, and then
wizards to generate datasets...

1.)  What if this is an app that you will redistribute and not a corporate
app where these connections are fixed?  What do those GUI representations
really mean in terms of code and how do you allow the user to change where
that connection points--I.e. computername, sqlservername, database name

2.)  Isn't a dataset a lot of overkill?  I get this dataset and load it with
separate tables with tons of data so that I don't have to reconnect to the
database--that is the purpose right?  Then if that is a lot of data that is
a lot of network traffic and client memory used up right?  Also if I get
just a portion of the data then if I want more I must hit the database again
anyway.  Also, if I make updates then I have to write code to try to deal
with collisions.

What do you do if User A enters a lot of stuff and then User B does two...
both try to update the dataset to the database and one gets failures--does
that mean I tell him... sorry all your work for the last 30minutes couldn't
be done and dump it?

I guess I just don't get it..  Seems like a whole lot more work than
benefit.  I have seen a few instances where I could see the dataset being
useful--like getting a bunch of data to just display and sort etc.  But when
it comes to adding data etc.  Seems teh direct approach with sqlcommands and
stored procs is more sensible.

Then do you just create a dataset for the whole project and use the same one
for each form--is it globally available, or is the xsd file just a spec that
I use to create a new one in each form as needed?

Am I totally lost here?

Any ideas would be appreciated.   As you can see I know enough to be
dangerous but still fail to get the big picture and think that it all has to
be easier than what I can see and that also these GUI items in the IDE like
the Server Explorer have to make life easier... But I honestly haven't been
using it so far for my connections--just code--because I know what that does
and how to allow the user to change it.



2.ASP.Net cache Debugger Visualizer?

3.newbie vb6 ADO to, paging

4.differences between and 1.1

please, can anyone tell me the differences betwwen these 2 versions?... i 
just find comparisons between 2.0 and 1.1

thanks a lot. ADO Wrapper....


I'm just about to write one of these components to simplify simple dataset
return, and command execution against a SQL Server database.

Does ANYONE have a component freely available that I can use? This will save
me a day or two!

Cheers :)


Liddle Feesh
*fap fap fap fap*
<><   <><    <><  <><    ><>
         <><    <><     <><    <><  <><  <><

6. Serialized ADO.NET 1.0 dataset compatible with ADO.NET 2.0

7. Converting code ADO VBA to ADO net

8. ADO.NET 2.0 vs ADO.NET 1.1

Return to dotnet framework


Who is online

Users browsing this forum: No registered users and 28 guest