数据库中有Users表,表中有username,password,email三个字段,下面是针对这张表进行操作的
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection conn = new SqlConnection(constr))
{
using (SqlCommand cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText = "select * from Users";
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
//File类的Open方法用来打开一个文件,第一个参数是文件的路径,第二个参数是个枚举类型,这里表示若此文件存在就打开,若不存在则创建,第三个参数也是枚举类型,表示打开文件后要进行的操作是“写”
using (FileStream stream = File.Open(@"c:\a.txt", FileMode.OpenOrCreate, FileAccess.Write))
{
//使用上面创建的流的对象作为参数创建一个StreamWriter对象,此对象专门用来向文件写入数据
using (StreamWriter sw = new StreamWriter(stream))
{
string username = string.Empty;
string password = string.Empty;
string email = string.Empty;
while (reader.Read())
{
username = reader.GetString(reader.GetOrdinal("username"));
password = reader.GetString(reader.GetOrdinal("password"));
email = reader.GetString(reader.GetOrdinal("email"));
//使用StreamWriter的WriteLine方法向记事本中写入数据
sw.WriteLine(username+"|"+ password+"|"+email);
}
}
}
}
}
}