同时使用C#IAM通过ASP.NET将Excel数据保存到sql服务器中,同时出现错误 [英] while saving excel data into sql server through asp.net with c# iam getting error
本文介绍了同时使用C#IAM通过ASP.NET将Excel数据保存到sql服务器中,同时出现错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
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屋!
查看全文