tags:

views:

9

answers:

0
Q: 

WPF and Datasets: How do I get the SQLConnection.DataSource from TableAdapterManager.Connection?

My VB WPF app is using strongly typed datasets. The connection string is set in the app.config file and is changed via the application settings designer gui. During development I connect to the test database on another server. I want a screen indicator to make it clear that the app is connected to test data.

I know I could parse the connection string, but I'm trying something different. I noticed (using intellisense) that the TableAdapterManager has a connection property that is a SQLConnection. I'm trying to get at the underlying SQLConnection.DataSource property to determine whether I'm connected to the test database. For some reason I cannot cast the TableAdapterManager.Connection to a SQLClient.SQLConnection...

CType(_labTableAdapterManager.Connection, System.Data.SqlClient.SqlConnection)

generates the error "SQLConnection cannot be converted to String". Huh?

Any suggestions?

related questions

Best way to manage database connection for a Java servlet
C# Web Server Connection Problem
PHP's sleep function and client connections
VistaDB Connection Issue Programmatically using SQLConnection and ConnectionString
Common WCF Exception : Connection Unexpectedly Closed
DTS Packages & a Connection to Access
How to determine total number of open/active connections in ms sql server 2005
connecting web parts in sharepoint
Connection to Oracle without a username or password
Best Portable way to connect to SQL server using c++
Connection Forcibly Closed error
Determining when an EDGE connection comes back after a dropout on an iPhone
How can I re-use an existing database connection in phpBB3?
Help:How to make ODBC connection in web.Config file.
Java HttpURLConnection: Can it cope with duplicate header names?
Artificially create a connection timeout error
How to use system_user in audit trigger but still use connection pooling?
Why would a "java.net.ConnectException: Connection timed out" exception occur when URL is up?
java.net.SocketException: Connection reset
Graph Algorithm To Find All Connections Between Two Arbitrary Vertices
HELP SSL GURUs!!! ... Problems with SSL Connection
SQLServer Native Client Error "Connection Busy With Results From Another Command" in SSIS
Fast database access test from .Net
Oracle - What TNS Names file am I using?
How do I connect to a database and loop over a recordset in C#?