如何过asp.net把SQLSEVER入到EXECL 如何过asp.net把SQLSEVER入到EXECL 大家帮帮忙 我做毕业设计 老师不帮忙 各位达人HELP ME 先谢谢了 最好把相关代码发一下 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 EXEC master..xp_cmdshell 'bcp 库名.dbo.表名out c:\Temp.xls -c -q -S"servername" -U"sa" -P""' EXEC master..xp_cmdshell 'bcp "SELECT id,name FROM tb" queryout C:\ authors.xls -c -Sservername -Usa -Ppassword' insert into OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:\Temp.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...table1 (A) values (1) 启用外围配置器 EXEC sp_configure 'show advanced options',1 GO reconfigure GO EXEC sp_configure 'Ad Hoc Distributed Queries',1 GO reconfigure GO或查询数据到dataset,再通过gridview绑定dataset,导出excel或遍历dataset导出数据到excel Gridview中的内容导出到Excel建立基本的页面default.aspx<form id="form1" runat="server"><div><asp:GridView ID="GridView1" runat="server"></asp:GridView></div><br/><asp:Button ID="BtnExport" runat="server" OnClick="BtnExport_Click"Text="Export to Excel" /></form> 在default.aspx.cs中,写入如下代码:protected void Page_Load(object sender, EventArgs e){ if (!Page.IsPostBack) { BindData(); }}private void BindData(){ string query = "SELECT * FROM customers"; SqlConnection myConnection = new SqlConnection(ConnectionString); SqlDataAdapter ad = new SqlDataAdapter(query, myConnection); DataSet ds = new DataSet(); ad.Fill(ds, "customers"); GridView1.DataSource = ds; GridView1.DataBind();}public override void VerifyRenderingInServerForm(Control control){ // Confirms that an HtmlForm control is rendered for}protected void Button1_Click(object sender, EventArgs e){ Response.Clear(); Response.AddHeader("content-disposition","attachment;filename=FileName.xls"); Response.Charset = "gb2312"; Response.ContentType = "application/vnd.xls"; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite =new HtmlTextWriter(stringWrite); GridView1.AllowPaging = false; BindData(); GridView1.RenderControl(htmlWrite); Response.Write(stringWrite.ToString()); Response.End(); GridView1.AllowPaging = true; BindData();}protected void paging(object sender,GridViewPageEventArgs e){ GridView1.PageIndex = e.NewPageIndex; BindData();} 1,数据库直接导出excel2.内存表datatable导出excel3.普通网格导出excel楼主要那种 好像Sql server直接有那功能吧。或者查询所有的表,然后用数据源DataTable导入Excel http://www.itwis.com/html/net/aspnet/20080605/1668_2.html 下班前100分急求GridView或许选定那一行的主键值 给一个带父框架(framset)的页面传参,请问子框架里面的页面如何获取传递的参数 asp.net服务器端验证客户端是否存在某个文件 sql语句错误 Repeater里子控件的取值问题 treeview显示的数据没有层次? 求一简单问题算法 请问asp.net数据库连接问题,出错行--70行 ASP.NET中menu控件横向显示时怎样使右边的小箭头指向下? 在线等候?自定义控件问题? 关于回数 asp.net怎么用Activex 控件写一个音乐播放器
queryout C:\ authors.xls -c -Sservername -Usa -Ppassword' insert into OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\Temp.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...table1 (A) values (1)
启用外围配置器
EXEC sp_configure 'show advanced options',1
GO
reconfigure
GO
EXEC sp_configure 'Ad Hoc Distributed Queries',1
GO
reconfigure
GO
或查询数据到dataset,再通过gridview绑定dataset,导出excel
或遍历dataset导出数据到excel
建立基本的页面default.aspx<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</div>
<br/>
<asp:Button ID="BtnExport" runat="server" OnClick="BtnExport_Click"
Text="Export to Excel" />
</form> 在default.aspx.cs中,写入如下代码:protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BindData();
}
}
private void BindData()
{
string query = "SELECT * FROM customers";
SqlConnection myConnection = new SqlConnection(ConnectionString);
SqlDataAdapter ad = new SqlDataAdapter(query, myConnection);
DataSet ds = new DataSet();
ad.Fill(ds, "customers");
GridView1.DataSource = ds;
GridView1.DataBind();
}public override void VerifyRenderingInServerForm(Control control)
{
// Confirms that an HtmlForm control is rendered for
}protected void Button1_Click(object sender, EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition","attachment;filename=FileName.xls");
Response.Charset = "gb2312";
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite =new HtmlTextWriter(stringWrite); GridView1.AllowPaging = false;
BindData();
GridView1.RenderControl(htmlWrite); Response.Write(stringWrite.ToString());
Response.End();
GridView1.AllowPaging = true;
BindData();
}
protected void paging(object sender,GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
BindData();
}
2.内存表datatable导出excel
3.普通网格导出excel楼主要那种