473,811 Members | 2,843 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

DataSet connection string

Hi,

I created a DataSet in a seperate DAL library project. It created the
settings file to store my connection string. However, AFAIK, library
projects do not support settings files because the app.config file is not
copied to the output directory. Therefore, I cannot change the connection
string without changing my code. Is this a known problem and is there a
simple workaround?

Thanks,
Kent
Mar 11 '06 #1
1 1832
I'll answer my own question (sorry, should have googled first):
http://www.bbits.co.uk/blog/archive/...1/28/6698.aspx
"Kent Boogaart" <ke****@interno de.on.net> wrote in message
news:un******** ******@TK2MSFTN GP09.phx.gbl...
Hi,

I created a DataSet in a seperate DAL library project. It created the
settings file to store my connection string. However, AFAIK, library
projects do not support settings files because the app.config file is not
copied to the output directory. Therefore, I cannot change the connection
string without changing my code. Is this a known problem and is there a
simple workaround?

Thanks,
Kent

Mar 11 '06 #2

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

Similar topics

5
1576
by: Joachim | last post by:
When executing the following code ArrayList list = new ArrayList(); try { //Make sure connection is open if (!connection.State.ToString().Equals("Open")) connection.Open(); DataSet list = new DataSet();
2
1163
by: Vinod I | last post by:
Hi Team, I want to use DataSet in my ASP.Net application extensively. Scenario is, I am showing Data Set in one of my ASP.Net Page and changing row & column values thru Page. After that I want to send this changed DataSet to Server side and want to use "DataAdapter.Update" to commit the change into Database.
1
1892
by: Oney | last post by:
I created a middle tier component that produce dataset from database for sql reporting services but i can not open connection details: middle tier component which name is MyReports.dll using System; using System.Data; using Microsoft.ApplicationBlocks.Data;
15
2251
by: JIM.H. | last post by:
Hello, Can I send a dataset as a parameter into stored procedure and import data to a table in the stored procedure? Thanks, Jim.
2
1659
by: martinharvey via DotNetMonster.com | last post by:
I realise this is a beginners question but i would be grateful for some help Untill now i have been using Datareaders for example; Public Class Catalog Public Shared Function SP_GetBB() As SqlDataReader ' Create the connection object Dim connection As New SqlConnection(ConnectionString)
1
2024
by: cindy | last post by:
Get data into datatable, add to dataset dsSearch " Get data into datatable, add to dataset dsSearch Using In-Memory SQL Engine join the tables and select the filenames from the join, add to dataset dsSearch CODE ON http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=3994&lngWId=10 using SQL connection get data from view on sql server, add to dataset dsSearch
4
3756
by: Dave Edwards | last post by:
I understand that I can fill a datagrid with multiple queries, but I cannot figure out how to fill a dataset with the same query but run against multiple SQL servers, the query , table structure and username, password etc will be exactly the same for each server, the only thing that will change is the server name. Idealy I would like to get the server names from a seperate dataset so there could be any number of servers, allthough in...
0
2185
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 project, and load that project under IIS6/ASP/2003 using COM, it fails with the folowing error on the FIRST request only: > Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at...
3
2970
by: Khurram | last post by:
Hi, Firstly, I will apologise now if I have posted in the wrong discussion group. Please let me know if I have for future reference. Below is the code to a WebMethod that is querying an Access 2003 database, saving the results as a dataset and returning the dataset. public DataSet findAAPAssessment(string assessmentID) {
1
5055
by: =?Utf-8?B?Y29uc3RhbnRpbg==?= | last post by:
I have problem with my code I need to read from Excel worksheet into dataset the problem is in this line oleda.Fill(ds). The data adapter should fill dataSet with data from Excel worksheet but isn't doing so. Below is my code,thanks Imports System.Data.OleDb Imports System.Data Imports Oracle.DataAccess.Client Public Class Form1
0
9726
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10384
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10395
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10130
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7667
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6887
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5553
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5692
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3865
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.