Thursday 22 August 2019

How to create XML from DataTable in C#?




public void CreateFromDataTableXML()
        {
            string FileName = "";
            DataTable mDataTable = new DataTable();
            mDataTable = null;//Assign Data From DataBase
            if (mDataTable != null && mDataTable.Rows.Count > 0)
            {

                mDataTable.TableName = "EmployeeDetails";
                string Path = @"\\ServerPath\EmployeeXML\";
                DataSet mDataSet = new DataSet();
                mDataSet.Tables.Add(mDataTable);
                try
                {
                    FileName =  "Employee_" + DateTime.Now.ToString("dd-MMM-yyyy-hhsstt").ToString();
                    mDataSet.WriteXml(Path + FileName + ".xml");
                }
                catch
                {
                    FileName = String.Empty;
                }
                if (!string.IsNullOrWhiteSpace(FileName))
                {
                    //Add Your Business Logic Here
                }
            }
        }

No comments:

Post a Comment