1、数据库查询数据导出到文本文件:
string conStr = ConfigurationManager.ConnectionStrings["sql"].ConnectionString;
using (SqlConnection con = new SqlConnection(conStr))
{
string sqlStr = "select empid,empname,empgender,empage,Department.DepName from Employees as el inner join Department on el.DepId=department.DepId";
using (SqlCommand cmd = new SqlCommand(sqlStr, con))
{
con.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
using (StreamWriter sw = new StreamWriter("1.txt"))
{