数据库操作类没有封装
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Data.SqlClient; using System.IO; namespace 导出数据 { class Program { static void Main(string[] args) { string str = "Data Source=LENOVO-PC;Initial Catalog=MyDatabase;Integrated Security=True"; using (SqlConnection sco=new SqlConnection(str)) { string sql = "select *from Users"; using (SqlCommand scd=new SqlCommand(sql,sco)) { sco.Open(); using (SqlDataReader sdr=scd.ExecuteReader()) { if (sdr.HasRows) { using (StreamWriter sw=new StreamWriter("1.txt")) { sw.WriteLine("{0},{1}",sdr.GetName(0),sdr.GetName(1)); while (sdr.Read()) { sw.WriteLine("{0},{1}",sdr["logName"],sdr["logPassWord"]); }//end while } } } sco.Close(); } } Console.WriteLine("导出数据成功！"); Console.ReadKey(); } } }