/[AnywhereTS-MSSQL]/trunk/AnywhereTS.DBSupport/SqlMdfConnector.cs
ViewVC logotype

Contents of /trunk/AnywhereTS.DBSupport/SqlMdfConnector.cs

Parent Directory Parent Directory | Revision Log Revision Log


Revision 85 - (show annotations) (download)
Fri Jul 13 21:10:26 2012 UTC (8 years, 4 months ago) by william
File size: 1156 byte(s)
+ add support for database access from:
* SQL Server Express
* SQL Server (not Express)
* SQL Server MDF file

1 using System;
2 using System.Collections.Generic;
3 using System.Text;
4 using System.Data.SqlClient;
5
6 namespace AnywhereTS.DBSupport
7 {
8 public class SqlMdfConnector : DBConnector<SqlParameter, SqlCommand, SqlConnection, SqlDataAdapter>
9 {
10 public SqlMdfConnector(string DBServerAddress, string DBServerInstance, string SqlMdf) : base(DBServerAddress, DBServerInstance, SqlMdf) { }
11
12 public override void CreateConnection(out Exception ErrorInfo)
13 {
14 ErrorInfo = null;
15 try
16 {
17 string connetionString = null;
18 connetionString = string.Format(@"Data Source={0}\{1};;AttachDbFilename=|DataDirectory|\{2};Integrated Security=SSPI", DBServerAddress, DBServerInstance, DBDatabase);
19 connection = new SqlConnection();
20 connection.ConnectionString = connetionString;
21 }
22 //catch (SqlException ex) { Console.WriteLine(ex.ToString()); ErrorInfo = ex; throw ErrorInfo;}
23 catch (Exception ex) { Console.WriteLine(ex.ToString()); ErrorInfo = ex; throw ErrorInfo; }
24 }
25 }
26 }

  ViewVC Help
Powered by ViewVC 1.1.22