Zbiór zmian 267 dla trunk

Data:

2009-01-30 09:48:15 (17 years ago)

Autor:

marek

Opis:

fixes #69 - dodano nowa funkcje GetDataBaseInfo? do klasy ConnString?

Lokalizacja:

trunk/BazaReklam

Pliki:

• About.cs (zmodyfikowane) (2 diffs)
• Classes/ConnString.cs (zmodyfikowane) (2 diffs)

trunk/BazaReklam/About.cs

@@ -1 +1 @@
 using System;
-using System.Data.SqlClient;
 using System.Windows.Forms;
 
@@ -15 +14 @@
             lblVersion.Text = Application.ProductVersion;
 
-            SqlConnection sqlConnection = new SqlConnection(ConnString.getConnString().Value);
-
-            lblDB.Text = sqlConnection.DataSource + "/" + sqlConnection.Database;
-            sqlConnection.Dispose();
+            lblDB.Text = ConnString.GetDataBaseInfo();
         }
 

trunk/BazaReklam/Classes/ConnString.cs

@@ -1 @@
-using System;
-using System.Collections.Generic;
-using System.Text;
+using System.Data.SqlClient;
 
 namespace Baza_Reklam
@@ -10 +8 @@
 
         public string Value
-         {
-             get { return this.value; }
-             set { this.value = value; } 
-         }
+        {
+            get { return value; }
+            set { this.value = value; }
+        }
 
         private static ConnString connectionString;
 
-        private ConnString() { 
+        private ConnString()
+        {
         }
 
         public static ConnString getConnString()
         {
-            if (connectionString == null){
+            if (connectionString == null)
+            {
                 connectionString = new ConnString();
-            } 
+            }
             return connectionString;
-        } 
+        }
+
+        public static string GetDataBaseInfo()
+        {
+            SqlConnection sqlConnection = null;
+            try
+            {
+                sqlConnection = new SqlConnection(getConnString().Value);
+                return sqlConnection.DataSource + "/" + sqlConnection.Database;
+            }
+            catch
+            {
+                return string.Empty;
+            }
+            finally
+            {
+                if (sqlConnection != null) sqlConnection.Dispose();
+            }
+        }
     }
 }