同时使用C#IAM通过ASP.NET将Excel数据保存到sql服务器中，同时出现错误 [英] while saving excel data into sql server through asp.net with c# iam getting error

问题描述

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Data.OleDb;

public partial class _Default : System.Web.UI.Page
{
    string strConnection = ConfigurationManager.ConnectionStrings
["EmployeeConnectionString1"].ConnectionString;
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        //Create connection string to Excel work book
        string excelConnectionString =
        @"Provider=Microsoft.Jet.OLEDB.4.0;
        Data Source=C:\Book1.xlsx;
        Extended Properties=""Excel 8.0;HDR=YES;""";
        
        //Create Connection to Excel work book
        OleDbConnection excelConnection =
        new OleDbConnection(excelConnectionString);
        
        //Create OleDbCommand to fetch data from Excel
        OleDbCommand cmd = new OleDbCommand
        ("Select [Deptno],[DeptName],[DeptLoc] from [Book1$]  ", excelConnection);
        if(excelConnection.State==ConnectionState.Closed)
        excelConnection.Open();
        OleDbDataReader dReader;
        dReader = cmd.ExecuteReader();
        
        SqlBulkCopy sqlBulk = new SqlBulkCopy(strConnection);
        sqlBulk.DestinationTableName = "Dept";
        
        sqlBulk.WriteToServer(dReader);
    }
}

我得到的错误--- OleDbException was unhandeled by user,cannot update database or object is read-only

Error i am getting---OleDbException was unhandeled by user,cannot update database or object is read-only

推荐答案

"，excelConnection); 如果(excelConnection.State == ConnectionState.Closed) excelConnection.Open(); OleDbDataReader dReader; dReader = cmd.ExecuteReader(); SqlBulkCopy sqlBulk = 新 SqlBulkCopy(strConnection); sqlBulk.DestinationTableName = " ; sqlBulk.WriteToServer(dReader); } }

", excelConnection); if(excelConnection.State==ConnectionState.Closed) excelConnection.Open(); OleDbDataReader dReader; dReader = cmd.ExecuteReader(); SqlBulkCopy sqlBulk = new SqlBulkCopy(strConnection); sqlBulk.DestinationTableName = "Dept"; sqlBulk.WriteToServer(dReader); } }

我得到的错误--- OleDbException was unhandeled by user,cannot update database or object is read-only

Error i am getting---OleDbException was unhandeled by user,cannot update database or object is read-only

这篇关于同时使用C#IAM通过ASP.NET将Excel数据保存到sql服务器中，同时出现错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！