c# 查询表数据导出sql文件

            ArrayList list = new ArrayList();            using (SqlConnection conn = new SqlConnection("server=(local);uid=sa;pwd=sa123456;database=IPVA_Apple"))            {                conn.Open();                using (SqlCommand command = conn.CreateCommand())                {                    command.CommandText = "select * from aspnet_Membership";                    using (SqlDataAdapter adp = new SqlDataAdapter(command))                    {                        DataTable dt = new DataTable();                        adp.Fill(dt);                        foreach (DataRow row in dt.Rows)                        {                            list.Add(row[0].ToString());                        }                    }                }            }            // 创建文件。如果文件存在则覆盖            FileStream fs = File.Open(@"d:\内容.sql", FileMode.Create);            // 创建写入流            StreamWriter wr = new StreamWriter(fs,System.Text.Encoding.UTF8);            // 将ArrayList中的每个项逐一写入文件            for (int i = 0; i < list.Count; i++)            {                wr.WriteLine(list[i]);            }            // 关闭写入流            wr.Flush();            wr.Close();            // 关闭文件            fs.Close();