C# (CSharp) global::System.Data.OleDb.OleDbConnection.Close Exemples

Exemple #1

 internal static System.Data.DataSet getXldata(System.Data.OleDb.OleDbConnection xlConn, string sheetName, string excelPath, string excelExten)
 {
     System.Data.DataSet ds = new System.Data.DataSet();
     SPSecurity.RunWithElevatedPrivileges(delegate()
     {
         xlConn     = new global::System.Data.OleDb.OleDbConnection(Utilities.ConnUtilities.CreateXlConnectionString(excelPath, excelExten));
         string cmd = string.Format("select * from [{0}]", sheetName);
         System.Data.OleDb.OleDbCommand Comm = new System.Data.OleDb.OleDbCommand(cmd, xlConn);
         Comm.Connection = xlConn;
         System.Data.OleDb.OleDbDataAdapter adapter = new System.Data.OleDb.OleDbDataAdapter();
         xlConn.Open();
         Comm.CommandType      = System.Data.CommandType.Text;
         adapter.SelectCommand = Comm;
         adapter.Fill(ds);
         xlConn.Close();
     });
     return(ds);
 }