473,387 Members | 1,440 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Connection string from Dataset VS2005

Hi,
I will like to read and set the Connection string in a dataset created
by the Vs2005 wizard, but I'm not able to find any way to interact with
is connection string ( unless I change the Xml and reload the app ).
Thanks,
Paolol
Jun 21 '06 #1
3 5363

"paolol" <paolol@no_spamsalsan.net> wrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
Hi,
I will like to read and set the Connection string in a dataset created by
the Vs2005 wizard, but I'm not able to find any way to interact with is
connection string ( unless I change the Xml and reload the app ).
Thanks,
Paolol


Your dataset has a collection of DataTable objects, each one of which
can/should have a TableAdapter. The TableAdapter Connection.ConnectionString
should give you what you want.
Jun 21 '06 #2
HI,
a connectionstring in a dataset?
--
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"paolol" <paolol@no_spamsalsan.net> wrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
Hi,
I will like to read and set the Connection string in a dataset created by
the Vs2005 wizard, but I'm not able to find any way to interact with is
connection string ( unless I change the Xml and reload the app ).
Thanks,
Paolol

Jun 21 '06 #3
You are a wonderfull helper :)))
Now I understand better how this works Thanks a Million :)
Paolol

pvdg42 ha scritto:
"paolol" <paolol@no_spamsalsan.net> wrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
Hi,
I will like to read and set the Connection string in a dataset created by
the Vs2005 wizard, but I'm not able to find any way to interact with is
connection string ( unless I change the Xml and reload the app ).
Thanks,
Paolol


Your dataset has a collection of DataTable objects, each one of which
can/should have a TableAdapter. The TableAdapter Connection.ConnectionString
should give you what you want.

Jun 21 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Jim | last post by:
Is it possible to have a Connection class that opens up connection to my DB and leaves it open until I decide to close it? I run many SQL statements so I was wondering if it's possible to call a...
3
by: John | last post by:
Hi I have a dataset from a web service. I want to use a dataadapter with the dataset. What connection string should I use so the da knows that it is acting on the remote db associated with the...
1
by: ad | last post by:
I use vs2005. I wnat to create a dataset in design time. I have a connection string in web.config. At the first step of DataAdapter wizard, it prompt me to enter a new connection, At the last...
0
by: Christopher H. Laco | last post by:
I'm in a strange situation. I have a dataset that uses it own connection string from MySettings. All is well. This thing works in .NET just dandy. If I reference this dataset from another...
20
by: fniles | last post by:
I am using VS2003 and connecting to MS Access database. When using a connection pooling (every time I open the OLEDBCONNECTION I use the exact matching connection string), 1. how can I know how...
6
Cintury
by: Cintury | last post by:
Hi all, I've developed a mobile application for windows mobile 5.0 that has been in use for a while (1 year and a couple of months). It was developed in visual studios 2005 with a back-end sql...
2
by: Thorsten Dittmar | last post by:
Hi, I don't get it. I'm using a typed dataset with table adapters and all that stuff. I have the database server running locally on my development system. Now: when creating a tableadapter...
5
by: Edwin Smith | last post by:
Hello: I'm using VS2005 with an ODBC database. I am trying to add a Dialog to an existing Database application to allow the user to select the database. We have 2 different databases with the...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.