DataSet与XML互转,DataSet读取XML文件

最新推荐文章于 2021-02-23 22:55:03 发布

遗失的思念

最新推荐文章于 2021-02-23 22:55:03 发布

阅读量841

点赞数

文章标签： DataSet与XML互转 DataTable与XML互转

本文链接：https://blog.youkuaiyun.com/LZW891967934/article/details/16867061

版权

#region
    //将DataSet转化为XML
    private string ConvertDataTableToXML(DataSet xmlDS)
    {
        MemoryStream stream = null;
        XmlTextWriter writer = null;
        try
        {
            stream = new MemoryStream();
            writer = new XmlTextWriter(stream, Encoding.Default);
            xmlDS.WriteXml(writer);
            int count = (int)stream.Length;
            byte[] arr = new byte[count];
            stream.Seek(0, SeekOrigin.Begin);
            stream.Read(arr, 0, count);
            UTF8Encoding utf = new UTF8Encoding();
            return utf.GetString(arr).Trim();
        }
        catch
        {
            return String.Empty;
        }
        finally
        {
            if (writer != null) writer.Close();
        }
    }


    //将XML转化为DataDataSet
    private DataSet ConvertXMLToDataSet(string xmlData)
    {
        StringReader stream = null;
        XmlTextReader reader = null;
        try
        {
            DataSet xmlDS = new DataSet();
            stream = new StringReader(xmlData);
            reader = new XmlTextReader(stream);
            xmlDS.ReadXml(reader);
            return xmlDS;
        }
        catch (Exception ex)
        {
            string strTest = ex.Message;
            return null;
        }
        finally
        {
            if (reader != null)
                reader.Close();
        }
    }


    //DataSet读取XML文件
    [WebMethod]
    public DataTable Get_UserInfo()
    {
        DataSet ds = new DataSet();
        string xmlPath = HttpContext.Current.Server.MapPath("userInfo.xml"); //获取xml存储路径
        StreamReader sr = new StreamReader(xmlPath, Encoding.GetEncoding("GB2312"));//转化字符编码
        ds.ReadXml(sr);
        return ds.Tables[0];
    }


    #endregion