数据库文件导出

 1  //string[] content=new string[100];//数组一定要new出来，切记，切记！！！
 2         List<string> content=new List<string>();
 3         private void button2_Click(object sender, RoutedEventArgs e)
 4         {
 5             using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connStr"].ConnectionString))
 6             {
 7                 conn.Open();
 8                 using(SqlCommand cmd=new SqlCommand())
 9                 {
10                     cmd.CommandText="select Name,Password from T_Login";
11                     cmd.Connection=conn;
12                     SqlDataAdapter adapter=new SqlDataAdapter(cmd);
13                     DataSet ds=new DataSet();
14                     adapter.Fill(ds);
15                     DataRowCollection rows= ds.Tables[0].Rows;
16                     foreach (DataRow row in rows)
17                     {
18                         //string c = row[0].ToString() + row[1].ToString();
19                         content.Add((string)row[0]+"  "+(string)row[1]);
20                     }
21                 }
22                 File.WriteAllLines("C:/2.txt", content);
23             }
24             MessageBox.Show("导出完毕");
25         }

 

转载于:https://www.cnblogs.com/wangjia2662/archive/2013/03/23/2976607.html