Customizing the connection string for TableAdapters

re: Customizing the connection string for TableAdapters

Bill Vaughn — Tue, 26 Jul 2005 00:03:06 GMT

If we want to encrypt/decrypt the connection string, are there any suggested "best practice" techniques to use?

re: Customizing the connection string for TableAdapters

MDeevi — Wed, 17 Aug 2005 12:29:36 GMT

The DataAdaptor in Beta 1 had a generate WebMethod property. In Beta 2 this property isn't there. I want to know how to web-enable the dataset and update data across the web using the DataSet designer rather than hand coding it, the way I could use the generateWebMethod property.

Please let us know whether this feature will be available in VS2005 RTM product.

Working with local databases

Smart Client Data — Fri, 26 Aug 2005 23:31:33 GMT

Overview
In Visual Studio 2005 we added a number of features to help developers build and deploy applications...

Working with local databases

Smart Client Data — Sat, 27 Aug 2005 01:51:10 GMT

Overview
In Visual Studio 2005 we added a number of features to help developers build and deploy applications...

re: Customizing the connection string for TableAdapters

Vittorio — Thu, 19 Jan 2006 20:16:16 GMT

This is my workaround, it doesn't need an app.config at runtime:

http://forums.microsoft.com/msdn/ShowPost.aspx?postid=210683&isthread=false&siteid=1&authhash=a59c997bbbb849c1b318b58c1bf1a579f9b0bcc5&ticks=632732557629342289

re: Customizing the connection string for TableAdapters

Michael Freidgeim — Thu, 02 Mar 2006 02:08:28 GMT

In instruction "To add an event handler" step 5 is applicable for VB only.
AFAIK Visual Studio doesn't help to create c# event handler and you should do it manually.

re: Customizing the connection string for TableAdapters

Michael Freidgeim — Thu, 02 Mar 2006 02:16:50 GMT

Actually "To create an event handler in C#"
(from http://msdn2.microsoft.com/en-us/library/cwwt2wtw.aspx)
Create the event delegate in the Constructor of the class by typing the qualified event name followed by a space, and then typing += with no space afterwards. For example:

this.<object name>.<event name> +=

At the end of the line of code, press the TAB key twice.

Visual Studio automatically completes the line of code, creates the event handler, and moves the insertion point to the newly created event handler.

re: Customizing the connection string for TableAdapters

Nigel Browning — Thu, 23 Mar 2006 21:04:21 GMT

My application needs to be installed from a network location and each user needs to access data from a single network database file (Access by OLEDB). This location is not (and is never likely to be) the same as the location used for development!

I cannot believe that any other application is going to need a hard-coded path to its data. Yet, if one is creating a Click-Once installation, that is exactly what happens. If one installs the installation files on a new network, then one cannot edit the application.exe.config file in the deployment as the hash value is then different and the installation fails.

I have just spent an entire day attempting to set the |DataDirectory| location at run-time. Eventually, I made a work-around in which I edited the application.exe.config file directly from code when my startup form was loading, saved the changes, then restarted the application.

Why on earth was the fact that the |DataDirectory| variable is merely a property of the AppDomain not included in the Visual Studio documentation? Furthermore, why has the on-line documentation not been updated to include this crucial piece of information?

re: Customizing the connection string for MY LIFE!

Ashkan — Sat, 26 Aug 2006 10:06:08 GMT

Hi... I'm a solo programer. I've create a new C# project in VS 2005. I've intall SQL Server 2005 Ent. eddition on my localhost and I'm using it as my database server. At VS in "server Explorer" window I create a new data connection to my sql server. Test and OK! At next step I create a new sqlconnection object to use it in my application. I don't want to use dataset, I need just to add data to my table manually. Every thing is good. but now I'm trying to deploy my very simple application to destination computer on a network. I JUST NEED TO CHANGE MY COMPUTER NAME TO SQL SERVER NAME ON THAT NETWORK... WHAT SHOUL I DO? I tried to change .Config file, but it seems these files are using when I'm using "Data Source" in VS2005. ashkan.email@gmail.com Thank you. Ashkan

cadenas de conexion desde .NET para SQL Server 2005

Sergio Tarrillo's Blog -> enhancements — Thu, 16 Nov 2006 09:02:54 GMT

si es que estamos usando SQLExpress, y estamos creando una aplicación .NET para el acceso a datos, hay...

cadenas de conexion desde .NET para SQL Server 2005

SergioTarrillo's Blog — Thu, 16 Nov 2006 09:03:12 GMT

si es que estamos usando SQLExpress, y estamos creando una aplicación .NET para el acceso a datos, hay

Visual Studio and local databases « The eagle on the stone

Visual Studio and local databases « The eagle on the stone — Sat, 21 Jul 2007 20:40:47 GMT

PingBack from http://arnulfo.wordpress.com/2007/07/21/visual-studio-and-local-databases/

Modificare le Settings con scope Application

Ermanno Goletto — Thu, 03 Jul 2008 10:55:32 GMT

Modificare le Settings con scope Application

How to : Programmatically change Connection String « Iuvo

How to : Programmatically change Connection String « Iuvo — Wed, 01 Apr 2009 11:49:51 GMT

PingBack from http://iuvo.wordpress.com/2009/04/01/how-to-programmatically-change-connection-string/

Working with local databases

老许 — Tue, 09 Jun 2009 10:17:53 GMT

Workingwithlocaldatabases

Overview

InVisualStudio2005weaddedanumberoffeaturestohelp...