using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;
using System.IO;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
string sqlstr = ConfigurationManager.ConnectionStrings["sqlconnstring"].ConnectionString;
SqlConnection sqlcnn = new SqlConnection(sqlstr);
SqlCommand sqlcmm = new SqlCommand();
sqlcmm.Connection = sqlcnn;
sqlcmm.CommandText = "select uid,name,power from Users";
FileStream fsMyfile = new FileStream(@"C:\Users\Administrator\Desktop\Users.txt", FileMode.Create, FileAccess.Write);
StreamWriter swMyfile = new StreamWriter(fsMyfile);
sqlcnn.Open();
SqlDataReader reader = sqlcmm.ExecuteReader();
int i=0;
while(i<83)
{
if (reader.Read())
{
swMyfile.WriteLine(reader[0].ToString() + ";" + reader[1].ToString() + ";" + reader[2].ToString()+"\n");
}
i++;
}
sqlcnn.Close();
swMyfile.Flush();
swMyfile.Close();
fsMyfile.Close();
}
}