62,046
社区成员
发帖
与我相关
我的任务
分享
protected void Button2_Click(object sender, EventArgs e)
{
if (this.File1.PostedFile.FileName.Length != 0)
{
ArrayList b = this.ExcelSheetName(this.File1.PostedFile.FileName);
this.ExcelDataSource(this.File1.PostedFile.FileName, b[0].ToString());
}
else
{
Response.Write("<script>alert('你还没有选择要上传的文件!')</script>");
}
}
public ArrayList ExcelSheetName(string filepath)
{
ArrayList al = new ArrayList();
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
DataTable sheetNames = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
conn.Close();
foreach (DataRow dr in sheetNames.Rows)
{
al.Add(dr[2]);
}
return al;
}
public void ExcelDataSource(string filepath, string sheetname)
{
string sql = null;
try
{
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties=Excel 8.0;");
OleDbCommand comm = new OleDbCommand("select * from [" + sheetname + "]", conn);
conn.Open();
OleDbDataReader odr = comm.ExecuteReader();
int i = 0;
while (odr.Read())
{
i++;
// 插入语句
SqlConnection sqlconn = dbclass.dbcon();
sqlconn.Open();
dbclass.dboperate(sql, sqlconn);
sqlconn.Close();
}
odr.Close();
conn.Close();
}
catch (Exception ee)
{
Response.Write(sql);
Response.Write(ee.Message);
}
}