DataObject data=new DataObject();fileExcel = txtFileName.Text + ".xls";
filePath = Server.MapPath(@"Web\ExcelFile");
fileName = filePath + "\\" + fileExcel;
objFileStream = new FileStream(fileName, FileMode.OpenOrCreate, FileAccess.Write);
objStreamWriter = new StreamWriter(objFileStream);
string sSQL="SELECT * FROM V_DeliveryQuery ORDER BY OrderId";
SqlRataReader dr=data.RunSQL(sSQL);
strLine = "";
for (int i = 0; i <= dr.FieldCount-1; i++)
{
strLine = strLine + dr.GetName(i).ToString() + Convert.ToChar(9);
}
objStreamWriter.WriteLine(strLine);
strLine = "";
while (dr.Read())
{
for (int i = 0; i <= dr.FieldCount-1; i++)
{
strLine = strLine + dr.GetValue(i).ToString() + Convert.ToChar(9);
}
objStreamWriter.WriteLine(strLine);
strLine="";
}
filePath = Server.MapPath(@"Web\ExcelFile");
fileName = filePath + "\\" + fileExcel;
objFileStream = new FileStream(fileName, FileMode.OpenOrCreate, FileAccess.Write);
objStreamWriter = new StreamWriter(objFileStream);
string sSQL="SELECT * FROM V_DeliveryQuery ORDER BY OrderId";
SqlRataReader dr=data.RunSQL(sSQL);
strLine = "";
for (int i = 0; i <= dr.FieldCount-1; i++)
{
strLine = strLine + dr.GetName(i).ToString() + Convert.ToChar(9);
}
objStreamWriter.WriteLine(strLine);
strLine = "";
while (dr.Read())
{
for (int i = 0; i <= dr.FieldCount-1; i++)
{
strLine = strLine + dr.GetValue(i).ToString() + Convert.ToChar(9);
}
objStreamWriter.WriteLine(strLine);
strLine="";
}
解决方案 »
- 大家觉得加一个数据验证层有必要吗?
- 求助,关于截取字符串的问题
- 求解以下是什么意思?如何配合aspnetpager分页控件来实现分页呢?最好可以弄个例子。万分感谢!
- 只有3分了,请大家谅解,问一个动态textbox的问题
- 水晶报表的权限问题,大家进来帮下忙
- 求一个正则表达式
- 错误信息是未将对象设置到引用实例,相同的操作为什么有的机器可以成功有些就不行??
- 请问"SELECT * FROM 新闻 WHERE id='"+Request["id"]+"'";怎么转化成存储类型???
- 请问C#如何编写把本地读卡器读取的内容返回给页面的ActiveX控件。或是还有什么其它的解决方案可以实现这样的需求。谢谢
- 关于datagrid中checkbox的问题?
- 怎么样向ASP中一样输出一个字段?
- 有关Request.Form问题?
http://www.c-sharpcorner.com/Database/SqltoExcelDataTransferLC.asp
objStreamWriter = new StreamWriter(objFileStream,System.Text.Encoding.GetEncoding("gb2312"));