Dela via


Do you want to include the password in the connection string Dialog Box

Allows you to control whether a password is embedded into the connection string. The Do you want to include the password in the connection string dialog box appears whenever a new connection object is added to a project that includes an embedded connection string.

  • Include password (Yes)
    This will embed the password into the connection string that will be saved as clear text in the application's source code and compiled assembly.

    Security noteSecurity Note

    Storing connection-string details (such as a password) can affect the security of your application. Using Windows Integrated Security is a more secure way to control access to a database. For more information, see Protecting Connection Information (ADO.NET).

  • Don't include password (No)
    Creates a connection string that does not include a password value.

    Note

    Code to provide valid credentials to the data source needs to be added to your application, or an exception may be thrown due to login failure if the login at the data source requires a password.

See Also

Concepts

Preparing Your Application to Receive Data

Fetching Data into Your Application

Binding Controls to Data in Visual Studio

Editing Data in Your Application

Validating Data

Saving Data

Other Resources

Overview of Data Applications in Visual Studio

Connecting to Data in Visual Studio

Tools for Working with Data Sources in Visual Studio