Advertisement
lexeugene14

C# - Connection String using Webconfig and Manual

Jul 26th, 2013
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.78 KB | None | 0 0
  1. //Conection
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Linq;
  5. using System.Text;
  6. using System.Data.SqlClient;
  7. using System.Configuration;
  8. using System.Data;
  9. namespace DAL
  10. {    
  11.     public class Connection
  12.     {
  13.         #region Methods
  14.         public static SqlConnection conn;
  15.  
  16.         public static void OpenConnection()
  17.         {
  18.             try
  19.             {
  20.                 //SQL Connection Initialize using Manual Connection
  21.                 conn = new SqlConnection("Server=(local); Database=CRUD; Integrated Security=true");
  22.         //SQL Connection Initialize using Web Config Connection
  23.         conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionStringName"].ToString());
  24.                 conn.Open();
  25.             }
  26.             catch
  27.             {
  28.  
  29.             }
  30.         }
  31.  
  32.         public static void CloseConnection()
  33.         {
  34.             try
  35.             {
  36.                 //SQL Close Connection Initialize
  37.                 if (conn != null)
  38.                 {
  39.                     if (conn.State == ConnectionState.Open)
  40.                     {
  41.                         conn.Close();
  42.                     }
  43.                 }
  44.                
  45.             }
  46.             catch
  47.             {
  48.  
  49.             }
  50.         }
  51.         #endregion
  52.     }
  53. }
  54.  
  55.  
  56. <connectionStrings>
  57. <add name="conn" connectionString="Data Source=coolxpc\\SQLEXPRESS;Initial Catalog=db_deneme;uid=sa;pwd=12345";Integrated Security=False;MultipleActiveResultSets=False;Packet Size=4096;Application Name=&quot;Microsoft SQL Server Management Studio Express&quot;" providerName="System.Data.SqlClient"/>
  58.  
  59. </connectionStrings>
  60.  
  61. //Web Config Part
  62. <add name="ConnectionStringName"  connectionString=YourServer"; Initial Catalog=YourDB; Integrated Security=True"/>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement