近日做一些用户数据的整合,需要将一些活动的用户数据导出到txt文件中,将页面的代码复制如下:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.IO;
using BLL;
public partial class ExportData : System.Web.UI.Page
{
private
const string txtPath = @"D:\data\txt";
private
const string txtPostFix = ".txt";
private
const int dataDistance = 5;
private
const int tabDistance = 8;
protected
void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["activityId"] != null)
{
int activityId =
Convert.ToInt32(Request.QueryString["activityId"].ToString());
DataSet dsUsers =
UsersManager.GetUsersByActivityID(activityId);
ExportToTxt(dsUsers);
}
}
}
///
///
把数据文件导入到.txt文件
///
///
public void
ExportToTxt(DataSet ds)
{
if (ds.Tables.Count != 0)
{
string tempFileName = null;
tempFileName = GetTempFileName();
//创建一个.txt文件,文件名用系统时间生成精确到毫秒
FileInfo file = new FileInfo(txtPath + tempFileName +
txtPostFix);
StreamWriter textFile = null;
try
{
textFile = file.CreateText();
}
catch
{
Response.Write("
return;
}
//把Dataset中的数据写入.txt文件中
for (int totaltable = 0; totaltable < ds.Tables.Count;
totaltable++)
{
//统计dataset中当前表的行数
int row = ds.Tables[totaltable].Rows.Count;
//统计dataset中当前表的列数
int column = ds.Tables[totaltable].Columns.Count;