如何关闭Microsoft Jet数据库引擎MS Access [英] How To Close The Microsoft Jet database engine MS Access

问题描述

Microsoft Jet数据库引擎无法打开文件它已由其他用户独占打开，或者您需要获得查看其数据的权限。



此错误显示之后使用
处理代码

The Microsoft Jet database engine cannot open the file It is already opened exclusively by another user, or you need permission to view its data.

This Error Disply after Handling The Code BY Using

string f = fu.PostedFile.FileName;
      
       string fileType = f.Split('.')[1];

        OleDbConnection excelCon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + f + ";Extended Properties=Excel 8.0");

        if (excelCon.State == ConnectionState.Closed)
        {
            excelCon.Open();
        }
        
        OleDbCommand excelCom = new OleDbCommand("SELECT * FROM [Sheet1$]", excelCon);
        OleDbDataAdapter excelAdp = new OleDbDataAdapter(excelCom);
        DataSet excelDs = new DataSet();
        excelAdp.Fill(excelDs);
        
        gvSending.DataSource = excelDs.Tables[0];
        gvSending.DataBind();

        excelCon.Close();

推荐答案

，excelCon）;
OleDbDataAdapter excelAdp = new OleDbDataAdapter（excelCom）;
DataSet excelDs = new DataSet（）;
excelAdp.Fill（excelDs）;

gvSending.DataSource = excelDs.Tables [ 0 ];
gvSending。 DataBind（）;

excelCon.Close（）;

", excelCon); OleDbDataAdapter excelAdp = new OleDbDataAdapter(excelCom); DataSet excelDs = new DataSet(); excelAdp.Fill(excelDs); gvSending.DataSource = excelDs.Tables[0]; gvSending.DataBind(); excelCon.Close();

这篇关于如何关闭Microsoft Jet数据库引擎MS Access的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！