通过SQL存储过程也可以实现。网上有资料,自己搜一下。
解决方案 »
- 改变层的设置
- 有关bit类型判定的问题,请高手帮忙解决!!(急需!!在线等!感激不敬!!)
- 推荐一些好的asp.net的学习资料吧
- 关于GridView中的模板列问题?
- ASP.NET初学者的问题(入门教程中的网站是用什么开发环境做的???)
- 我打算做一个网站更新策略控制程序,一直运行在服务器上,用网页远程配置。大家谈论一下思路。
- windows server 2003网站配置 问题,在线等
- .net调试问题..高手请进,谢谢了~~
- 大家对我这样建库有没有什么建议或意见,请指正!
- 如何判断一个从Table中某个值为空值啊?
- 怎么对购物车中的更改购物数量做最大值限制
- 无法将类型“string”隐式转换“PeopleManage.Model.Users
StringWriter tw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);GridView1.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();
你只需要把这里改成
Response.Write("你自己拼接的html字符串");//比如"<table><tr><td>第一行</td></tr>><tr><td>第二行</td></tr>
Response.End();[/
我是想把数据库10000条左右数据写到Excel里,
如果用这种方法,怎么写到html上啊?不懂
我想请问,这个方法比Girdview快吗?我是因为导入Girdview再导出Excel实在太慢了才想直接导出的
http://topic.csdn.net/u/20090317/10/331269bc-d913-443a-abdd-642d858f7d24.html
{ System.Data.OleDb.OleDbConnection OleDb_Conn = new OleDbConnection();
OleDb_Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties='Excel 8.0;HDR=Yes';" + "Data Source=\"" + strPath + "\"";
try
{
OleDb_Conn.Open();
OleDbCommand OleDb_Comm = new OleDbCommand();
OleDb_Comm.Connection = OleDb_Conn; string strCmd;
try
{
strCmd = "drop table [statistic]";
OleDb_Comm.CommandText = strCmd;
OleDb_Comm.ExecuteNonQuery();
}
catch
{
} strCmd = "create Table [statistic](";
foreach (DataColumn dc in dtSource.Columns)
{
strCmd += "[" + dc.ColumnName + "] nchar(50),";
}
strCmd = strCmd.Trim().Substring(0, strCmd.Length - 1);
strCmd += ")";
OleDb_Comm.CommandText = strCmd; OleDb_Comm.ExecuteNonQuery(); foreach (DataRow dr in dtSource.Rows)
{
if (dr.RowState != System.Data.DataRowState.Deleted)
{
strCmd = "insert into [statistic] values(";
foreach (DataColumn dc in dtSource.Columns)
{
strCmd += "'" + dr[dc.ColumnName].ToString() + "',";
} strCmd = strCmd.Substring(0, strCmd.Length - 1);
strCmd += ")"; OleDb_Comm.CommandText = strCmd;
OleDb_Comm.ExecuteNonQuery(); }
}
OleDb_Conn.Close();
}
catch (Exception ex)
{
tool.WarningDialog(ex.Message);
}
finally
{
OleDb_Conn.Close();
}
}以上oledb方法
{
HttpResponse resp;
resp = Page.Response;
resp.ContentEncoding = System.Text.Encoding.GetEncoding("shift_jis");
resp.ContentType = "application/excel";
resp.AppendHeader("Content-Disposition", "attachment;filename=" + FileName); //System.IO.StringWriter stringWrite = new System.IO.StringWriter();
//System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
//table1.RenderControl(htmlWrite);
//resp.Write("Excel出力調査\n");
//resp.Write(stringWrite.ToString());
string iii = "<h1>Excel出力調査</h1>\n";
resp.Write("\n");
string colHeaders = "", ls_item = "";
//定义表对象与行对象,同时用DataSet对其值进行初始化
DataTable dt = ds.Tables[0];
DataRow[] myRow = dt.Select();//可以类似dt.Select("id>10")之形式达到数据筛选目的
int i = 0;
int cl = dt.Columns.Count;
//取得数据表各列标题,各标题之间以t分割,最后一个列标题后加回车符
for (i = 0; i < cl; i++)
{
if (i == (cl - 1))//最后一列,加n
{
colHeaders += dt.Columns[i].Caption.ToString() + "\n";
}
else
{
colHeaders += dt.Columns[i].Caption.ToString() + "\t";
}
}
resp.Write(colHeaders);
//向HTTP输出流中写入取得的数据信息
//逐行处理数据
foreach (DataRow row in myRow)
{
//当前行数据写入HTTP输出流,并且置空ls_item以便下行数据
for (i = 0; i < cl; i++)
{
if (i == (cl - 1))//最后一列,加n
{
ls_item += row[i].ToString() + "\n";
}
else
{
ls_item += row[i].ToString() + "\t";
}
}
resp.Write(ls_item);
ls_item = "";
}
resp.End();
}