在导入数据库之前如何查看XML数据 [英] how to view XML data before importing into the database

问题描述

protected void btnimport_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=TNVKP_8;Integrated Security=True");
        DataSet reportData = new DataSet();
        //reportData.ReadXml(Server.MapPath(FileUpload1.ToString()));
        //reportData.ReadXml(Server.MapPath(FileUpload1.FileName.ToString()));
        reportData.ReadXml(Server.MapPath(FileUpload1.FileName));
        string filename = System.IO.Path.GetExtension(FileUpload1.FileName.ToString());
        string filenames = System.IO.Path.GetFullPath(FileUpload1.FileName.ToString());
        Response.Write(FileUpload1.FileName);
        //reportData.ReadXml(Server.MapPath(filenames.ToString()));
        SqlBulkCopy sbc = new SqlBulkCopy(con);
        sbc.DestinationTableName = "employee";
        sbc.ColumnMappings.Add("TALLY_REC_ID_CODE", "empid");
        sbc.ColumnMappings.Add("CLUSTER_ID", "empname");

        sbc.ColumnMappings.Add("UNIT_TYPE", "empaddress");
        sbc.ColumnMappings.Add("VPRC_ID", "empcity");
        sbc.ColumnMappings.Add("SHG_ID", "empstate");

        sbc.ColumnMappings.Add("PIP_NO", "empzip");
        sbc.ColumnMappings.Add("NAME_OF_THE_MEMBER", "emplic");
        sbc.ColumnMappings.Add("TYPE_OF_LOAN", "empstatus");

        sbc.ColumnMappings.Add("PRINCIPAL", "empp");
        sbc.ColumnMappings.Add("INTEREST", "empi");
        con.Open();
        sbc.WriteToServer(reportData.Tables[0]);
        con.Close();
        lblmsg.Text = "Records inserted successfully";
}

上面的编码我已经使用c#
将数据导入sql 在插入之前，我想借助查看按钮查看xml数据
所以为此发布解决方案
在此先感谢

the above coding i have used to import data into sql in c#
before going to insert i want to view the xml data with the help of view button
so post solution for this
Thanks in advance

推荐答案

阅读本文，希望对您有所帮助
http://www.c-sharpcorner.com/UploadFile/mahesh/ReadWriteXML [ ^ ]

Read this article, hope it helps
http://www.c-sharpcorner.com/UploadFile/mahesh/ReadWriteXML[^]

这篇关于在导入数据库之前如何查看XML数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！