LitDev.DataBase.ConnectSqlServer C# (CSharp) 메소드

ConnectSqlServer() 공개 메소드

public ConnectSqlServer ( string server ) : void
server string
리턴 void
        public void ConnectSqlServer(string server)
        {
            dbType = DBType.SqlServer;
            name = "DataBase" + id.ToString();
            dbConnection = "Server=" + server + ";Database=" + database + ";Integrated Security=SSPI";
            if (LDDataBase.Connection != "") dbConnection = LDDataBase.Connection;
            cnnSqlServer = new SqlConnection(dbConnection);
            cnnSqlServer.Open();
            commandSqlServer = new SqlCommand();
            commandSqlServer.Connection = cnnSqlServer;
        }

Usage Example

예제 #1
0
 /// <summary>
 /// Connect to a SqlServer database.
 /// This must be called before any SQL methods.
 /// The SqlServer service must be running and database with credentials already created, if in doubt use SQLite.
 /// </summary>
 /// <param name="server">The SqlServer server (e.g. "(local)\SQLEXPRESS").</param>
 /// <param name="database">The SqlServer database name.</param>
 /// <returns>A label to identify the database.</returns>
 public static Primitive ConnectSqlServer(Primitive server, Primitive database)
 {
     try
     {
         ExtractDll();
         DataBase dataBase = GetDataBase(database, false);
         if (null == dataBase)
         {
             dataBase = new DataBase(database, NextID());
             dataBase.ConnectSqlServer(server);
         }
         dataBases.Add(dataBase);
         return(dataBase.name);
     }
     catch (Exception ex)
     {
         Utilities.OnError(Utilities.GetCurrentMethod(), ex);
     }
     return("");
 }
All Usage Examples Of LitDev.DataBase::ConnectSqlServer