---
title: "Configura de forma dinámica tu ConnectionString usando un sqlDatasource de DevExpress"
url: "https://fcuba.net/threads/12292-configura-de-forma-dinamica-tu-connectionstring-usando-un-sqldatasource-de-devexpress"
forum: "Foro UIJ"
author: "peterK-Gtmo"
published: "2018-04-23T19:09:21.000Z"
updated: "2018-04-23T19:09:21.000Z"
page: 1
pages: 1
---

# Configura de forma dinámica tu ConnectionString usando un sqlDatasource de DevExpress

In [Foro UIJ](https://fcuba.net/forums/433-foro-uij.md), started by peterK-Gtmo on 2018-04-23T19:09:21.000Z.

## peterK-Gtmo, [2018-04-23T19:09:21.000Z](https://fcuba.net/threads/12292-configura-de-forma-dinamica-tu-connectionstring-usando-un-sqldatasource-de-devexpress#post-150777)

> if (ConfigurationManager.ConnectionStrings\["ConnectionString"\] != null)
> {
> string connectionString = ConfigurationManager.ConnectionStrings\["ConnectionString"\].ConnectionString;
> if (connectionString == "")
> {
> connectionString = @"XpoProvider=MSSqlServer;data source=;user id=;password=;initial catalog=;Persist Security Info=true";
> }
> CustomStringConnectionParameters connectionParameters = new CustomStringConnectionParameters(connectionString);
> SqlDataSource sq = new SqlDataSource(connectionParameters);
>
> try
> {
> sq.RebuildResultSchema();
> winApplication.ConnectionString = connectionString;
> }
> catch (Exception)
> {
> SqlDataSourceUIHelper.ConfigureConnection(sq);
> connectionString = sq.Connection.CreateConnectionString();
> var config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
> var connectionStringsSection = (ConnectionStringsSection)config.GetSection("connectionStrings");
> connectionStringsSection.ConnectionStrings\["ConnectionString"\].ConnectionString = connectionString;
> config.Save();
> connectionStringsSection.SectionInformation.ProtectSection("DataProtectionConfigurationProvider");
> winApplication.ConnectionString = connectionString;
> }
> }