protected void Button1_Click(object sender, EventArgs e)
{
Server.ScriptTimeout = 100;
string path = this.Server.MapPath("1.xls");
SqlConnection conn = new SqlConnection("Data Source=192.168.1.150;Initial Catalog=WebDiskDB;User ID=sa;Password=aypostlxj");
conn.Open();
//SqlBulkCopy倒入数据
SqlBulkCopy bulkCopy = new SqlBulkCopy(conn);
bulkCopy.BulkCopyTimeout = 200;
bulkCopy.DestinationTableName = "dbo.ok2";
bulkCopy.WriteToServer(UploadExcelData(path, "Sheet1").Tables[0]);
bulkCopy.Close();
conn.Close();
}
public DataSet UploadExcelData(string FileName, string SheetName)
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FileName + ";Extended Properties=/"Excel 8.0;HDR=YES;IMEX=1/";";
OleDbConnection conn = new OleDbConnection(strConn);
string strExcel = "select * from [Sheet1$]";
OleDbDataAdapter XlsCommand = null;
DataSet ds = new DataSet();
try
{
conn.Open();
XlsCommand = new OleDbDataAdapter(strExcel, strConn);
XlsCommand.Fill(ds, "sheet1");
}
catch (Exception ex)
{
Response.Write("错误!:" + ex.Message.ToString());
}
finally
{
conn.Close();
conn.Dispose();
}
return ds;
}