把数据库中的内容导出到txt文档中

string sql = ConfigurationManager.ConnectionStrings["strcnn2"].ConnectionString;
        using (SqlConnection sqlcnn = new SqlConnection(sql))
        {
            SqlCommand sqlcmm = sqlcnn.CreateCommand();
            sqlcmm.CommandText = "select * from T_GRDA";
            sqlcnn.Open();
            SqlDataReader reader = sqlcmm.ExecuteReader();
            if (reader.HasRows)//获取SqlDataReader所读取的内容是一行还是多行的
            {
                using (FileStream file = File.Open(@"E:\T_GRDA.txt", FileMode.OpenOrCreate, FileAccess.Write))
                {
                    // FileStream file = File.Open(@"E:\T_GRDA.txt",FileMode.OpenOrCreate,FileAccess.Write  )
                    using (StreamWriter sw = new StreamWriter(file))
                    {
                        string GRBH = "";
                        string NAME = "";
                        string ZJM = "";
                        string XZZ = "";
                        string HJDZ = "";
                        string XZM = "";
                        string CWHM = "";
                        while (reader.Read())
                        {
                            GRBH = reader.GetString(reader.GetOrdinal("GRBH"));
                            NAME = reader.GetString(reader.GetOrdinal("NAME"));
                            ZJM = reader.GetString(reader.GetOrdinal("ZJM"));
                            XZZ = reader.GetString(reader.GetOrdinal("XZZ"));
                            HJDZ = reader.GetString(reader.GetOrdinal("HJDZ"));
                            XZM = reader.GetString(reader.GetOrdinal("XZM"));
                            CWHM = reader.GetString(reader.GetOrdinal("CWHM"));
                            sw.WriteLine(GRBH + "|" + NAME + "|" + ZJM + "|" + XZZ + "|" + HJDZ + "|" + XZM + "|" + CWHM);
                        }
                    }
                }
            }

        }

using (StreamWriter sw = new StreamWriter(file)){}  刚开始using没有写，导致数据库里的内容没有读完全