Aspose.Cells.Examples.CSharp.Articles.ManageDatabaseConnection.ModifyingExistingDataConnection.Run C# (CSharp) Method

        public static void Run()
        {
            // ExStart:ModifyingExistingDataConnection
            // The path to the documents directory.
            string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

            // Create workbook object
            Workbook workbook = new Workbook(dataDir + "DataConnection.xlsx");

            // Access first Data Connection
            ExternalConnection conn = workbook.DataConnections[0];

            // Change the Data Connection Name and Odc file
            conn.Name = "MyConnectionName";
            conn.OdcFile = "C:\\Users\\MyDefaulConnection.odc";

            // Change the Command Type, Command and Connection String
            DBConnection dbConn = conn as DBConnection;
            dbConn.CommandType = OLEDBCommandType.SqlStatement;
            dbConn.Command = "Select * from AdminTable";
            dbConn.ConnectionInfo = "Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False";

            // Save the workbook
            workbook.Save(dataDir + "output_out.xlsx");
            // ExEnd:ModifyingExistingDataConnection
        }
    }