ASP.NET 2.0中直接將Access數(shù)據(jù)庫導入到Excel文件中 收藏
<!--StartFragment--><%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
protected void Button1_Click(object sender, EventArgs e)
{
string sql;
string connstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\ASPNET20Book.mdb;Persist Security Info=True";
System.Data.OleDb.OleDbConnection cn = new System.Data.OleDb.OleDbConnection(connstr);
System.Data.OleDb.OleDbCommand cmd;
cn.Open();
//先得到記錄數(shù)目：
sql = "select Count(*) From Paging";
cmd = new System.Data.OleDb.OleDbCommand(sql, cn);
int RecordCount = (int)cmd.ExecuteScalar();
// TODO：計算Sheet數(shù)目，進行記錄分段，將不同的數(shù)據(jù)段導入到不同的Sheet（Sheet數(shù)目不知道有沒有限制：（）
// TODO：文件名，Sheet名字的存在檢測略
//每個Sheet只能最多保存65536條記錄。
sql = @"select top 65535 * into [Excel 8.0;database=" + Server.MapPath(".") + @"\ASPNET20Book.xls].[Sheet1] from Paging";
cmd = new System.Data.OleDb.OleDbCommand(sql, cn);
cmd.ExecuteNonQuery();
cn.Close();
cn.Dispose();
cn = null;
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>直接將Access數(shù)據(jù)庫導入到Excel文件</title>
</head>
<body>
<form id="form1" runat="server">
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="到處數(shù)據(jù)" />
</form>
</body>
</html>
本文來自CSDN博客，轉載請標明出處：http://blog.csdn.net/lxs5i5j/archive/2007/06/27/1668419.aspx
