'Microsoft' 附近有语法异常。字符串 ',[Sheet1$])' 后的引号不完整
'Microsoft' 附近有语法错误。字符串 ',[Sheet1$])' 后的引号不完整
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Linq;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnSend_Click(object sender, EventArgs e)
{
try
{
//获取上传文件的名称
string upName = fupFileSend.FileName;
//获取上传文件的后缀名
//string nameLast = upName.Substring(upName.LastIndexOf("."));
//修改上传文件的名称
string fileName = txtName.Text;
//设置要保存的路径
string path = Server.MapPath("./")+"\\" + fileName;
//将文件保存到指定路径下
fupFileSend.PostedFile.SaveAs(path);
//定义Excel表
string StyleSheet = "Sheet1";
//调用自定义方法LoadData执行将Excel文件中数据导入到SQL Server数据库中
LoadData(StyleSheet);
RegisterStartupScript("true", "<script>alert('上传成功！')</script>");
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
RegisterStartupScript("true", "<script>alert('上传失败！')</script>");
}
}
public SqlConnection con()
{
return new SqlConnection(ConfigurationSettings.AppSettings["strCon"]);
}
public void LoadData(string StyleSheet)
{
//定义连接服务器中的Excel文件
string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" + Server.MapPath("2010级新生基本信息.xls") + ";Extended Properties=Excel 8.0";
//创建一个OleDbConnection链接对象
OleDbConnection myConn = new OleDbConnection(strCon);
myConn.Open(); //打开数据链接，得到一个数据集
DataSet myDataSet = new DataSet(); //创建DataSet对象
string StrSql = "select * from [" + StyleSheet + "$]";
OleDbDataAdapter myCommand = new OleDbDataAdapter(StrSql, myConn);
//添充数据集
myCommand.Fill(myDataSet, "[" + StyleSheet + "$]");
//释放占有的系统资源
myCommand.Dispose();
//创建一个DataTable内存表
DataTable DT = myDataSet.Tables["[" + StyleSheet + "$]"];
myConn.Close();
myCommand.Dispose();
string constr = "Data Source=ANSWER-PC\\SQLEXPRESS;Initial Catalog=";
constr = constr + "xinxi_sql;Integrated Security=True";
SqlConnection conn = new SqlConnection(constr);//建立SQL Server数据库连接
conn.Open();//打开SQL Server数据库连接
//循环读取Excel文件中的数据并添加到SQL Server数据库中
for (int j = 0; j < DT.Rows.Count; j++)
{
string sqlstr = "";
string diqu = DT.Rows[j][0].ToString(); //读取用户姓名
string sname = DT.Rows[j][1].ToString(); //读取考试题目
string ssex = DT.Rows[j][2].ToString(); //读取考试分数
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Linq;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnSend_Click(object sender, EventArgs e)
{
try
{
//获取上传文件的名称
string upName = fupFileSend.FileName;
//获取上传文件的后缀名
//string nameLast = upName.Substring(upName.LastIndexOf("."));
//修改上传文件的名称
string fileName = txtName.Text;
//设置要保存的路径
string path = Server.MapPath("./")+"\\" + fileName;
//将文件保存到指定路径下
fupFileSend.PostedFile.SaveAs(path);
//定义Excel表
string StyleSheet = "Sheet1";
//调用自定义方法LoadData执行将Excel文件中数据导入到SQL Server数据库中
LoadData(StyleSheet);
RegisterStartupScript("true", "<script>alert('上传成功！')</script>");
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
RegisterStartupScript("true", "<script>alert('上传失败！')</script>");
}
}
public SqlConnection con()
{
return new SqlConnection(ConfigurationSettings.AppSettings["strCon"]);
}
public void LoadData(string StyleSheet)
{
//定义连接服务器中的Excel文件
string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" + Server.MapPath("2010级新生基本信息.xls") + ";Extended Properties=Excel 8.0";
//创建一个OleDbConnection链接对象
OleDbConnection myConn = new OleDbConnection(strCon);
myConn.Open(); //打开数据链接，得到一个数据集
DataSet myDataSet = new DataSet(); //创建DataSet对象
string StrSql = "select * from [" + StyleSheet + "$]";
OleDbDataAdapter myCommand = new OleDbDataAdapter(StrSql, myConn);
//添充数据集
myCommand.Fill(myDataSet, "[" + StyleSheet + "$]");
//释放占有的系统资源
myCommand.Dispose();
//创建一个DataTable内存表
DataTable DT = myDataSet.Tables["[" + StyleSheet + "$]"];
myConn.Close();
myCommand.Dispose();
string constr = "Data Source=ANSWER-PC\\SQLEXPRESS;Initial Catalog=";
constr = constr + "xinxi_sql;Integrated Security=True";
SqlConnection conn = new SqlConnection(constr);//建立SQL Server数据库连接
conn.Open();//打开SQL Server数据库连接
//循环读取Excel文件中的数据并添加到SQL Server数据库中
for (int j = 0; j < DT.Rows.Count; j++)
{
string sqlstr = "";
string diqu = DT.Rows[j][0].ToString(); //读取用户姓名
string sname = DT.Rows[j][1].ToString(); //读取考试题目
string ssex = DT.Rows[j][2].ToString(); //读取考试分数