ASP NET - Connection String nesnesi olusturmak Web Config Dosyasi

10.04.2017

<?xml version="1.0"?>
<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->

<configuration>
  <appSettings>
    <add key="webpages:Version" value="4.0.0.0" />
    <add key="webpages:Enabled" value="false" />
    <add key="PreserveLoginUrl" value="true" />
    <add key="ClientValidationEnabled" value="true" />
    <add key="UnobtrusiveJavaScriptEnabled" value="true" />
    <add key="connectionStringName" value="vt_fd" />
  </appSettings>
  <connectionStrings>
    <add name="ayson" connectionString="Server=mssql.aysunyildirim.xyz\MSSQLSERVER2012;Database=aysunyildirim_;uid=aysunyildirim;pwd=aysun02;pooling=true;max pool size=10000; MultipleActiveResultSets=True;" />
  </connectionStrings>
  <system.web>

    <pages enableEventValidation="false" validateRequest="false" enableViewStateMac="false" >
    </pages>
    <httpRuntime executionTimeout="24000" maxRequestLength="30480" />
    <membership>
      <providers>
        <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="LocalSqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression=""/>
      </providers>
    </membership>
    <profile>
      <providers>
        <add name="AspNetSqlProfileProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Profile.SqlProfileProvider, System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
      </providers>
    </profile>
    <roleManager>
      <providers>
        <add name="AspNetSqlRoleProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Security.SqlRoleProvider, System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
        <add name="AspNetWindowsTokenRoleProvider" applicationName="/" type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
      </providers>
    </roleManager>

    <globalization requestEncoding="windows-1254" responseEncoding="windows-1254" culture="tr-TR" uiCulture="tr" fileEncoding="windows-1254"/>

    <compilation debug="true" strict="true" explicit="true" batch="true"
                 optimizeCompilations="true" batchTimeout="900"
                 maxBatchSize="1000" maxBatchGeneratedFileSize="1000"
                 numRecompilesBeforeAppRestart="15" defaultLanguage="C#"
                 targetFramework="4.0" assemblyPostProcessorType="">
      <assemblies>
        <add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
      </assemblies>

    </compilation>

    <customErrors mode="Off">

    </customErrors>

  </system.web>
  <system.webServer>
    <security>
      <requestFiltering>
        <requestLimits maxAllowedContentLength="1073741824" />
      </requestFiltering>
    </security>
    <validation validateIntegratedModeConfiguration="false" />
    <modules runAllManagedModulesForAllRequests="true" />

    <urlCompression doStaticCompression="true" doDynamicCompression="true" dynamicCompressionBeforeCache="true" />

  </system.webServer>

</configuration>
 

web.config dosyasi içerigi yukarida yer aldigi sekilde olacaktir. kendi web sitenize göre kullanici ismi veritabani ismi ve sifreleri degistirmelisiniz. 

aspx sayfalarimizda kod kisminda ise  kütüphanemiz ekleyecegiz

using System.Configuration;

daha sonra page_load tan önce 
        string vtbag = ConfigurationManager.ConnectionStrings["ayson"].ConnectionString;

satirini yaziyoruz. 

bundan sonraki kisimda veritabani baglantisini yapacagimiz local baglanti noktasi yerine vtbag yazarak baglantimizi gerçeklestirmek olacaktir. 

     
            SqlConnection baglan = new SqlConnection(vtbag);
            baglan.Open();