Conversion of dataset to xml format

Question

Hi I am getting the data in dataset i.e only one record but that one record should display in below format. I want the dataset data in below format. Kindly help me as early as possible. Here action data Org data persData are the custom tags. Other tags came from column names of the table. 01102014 C1 55655655 99999999 3308 9 BWSU 99 CDT 1 Uattestsecond Kishor 1 12091989 IN 0

Francis · Answer

Here action data Org data persData are the custom tags. Since you need to include the custom tags also. So i would suggest you can manually loop thru the datatable and construct the XML string as you desired. Hope this helps!

satya repaka · Answer

Even though I have given full permissions its not working.. please help me yar

Francis · Answer

Please help me how to give permissions to that folder which is on other server. Please help me asap. Try this url a detailed guidance available: https://technet.microsoft.com/en-in/library/cc754344.aspx

satya repaka · Answer

Hi Francis  Please help me how to give permissions to that folder which is on other server. Please help me asap. Thanks & Regards Satya

Francis · Answer

The reason for the error is you didn't have proper permission to write the file on that location. So give appropriate permission for that folder/path. Then try !

satya repaka · Answer

Hi Francis The error is getting as : Message: Access to the path '\CIVUGBASFCFS\HRDumps\SAPDump\Export\IT2001\EmpDetailsSAPReport_MPR311014145010_685.xml' is denied. Stack trace: at System.IO.__Error.WinIOError(Int32 errorCode String maybeFullPath) at System.IO.FileStream.Init(String path FileMode mode FileAccess access Int32 rights Boolean useRights FileShare share Int32 bufferSize FileOptions options SECURITY_ATTRIBUTES secAttrs String msgPath Boolean bFromProxy) at System.IO.FileStream..ctor(String path FileMode mode FileAccess access FileShare share Int32 bufferSize FileOptions options String msgPath Boolean bFromProxy) at System.IO.FileStream..ctor(String path FileMode mode FileAccess access FileShare share) at RMS3.CommanMethods.SendNotificationMailToHRASWithSAPReport(String MandateCode Int64 CDT_ID String Process) Here \CIVUGBASFCFS\HRDumps\SAPDump\Export\IT2001 is the path to save the file on the other server but error is getting above

Francis · Answer

XDocument xdoc = XDocument.Parse(xml); xdoc.Save(strFileName); After writing this two lines getting error as Access to the path is denied. Seems that necessary permission is not given for that location. Give all (read/write) permission for that location and try to execute the program again! :) Hope that will solve your problem! If not try to refer the below url: http://stackoverflow.com/questions/5158894/c-sharp-write-to-xml-error Let me know your problem solved or not! :)

Ravi Patel · Answer

Hi Satya check this link http://stackoverflow.com/questions/19724297/asp-net-getting-the-error-access-to-the-path-is-denied-while-trying-to-upload i hope this will help you

satya repaka · Answer

Hi Francis After writing all the custom tags i stored in one variable and after I have written as Here xml is final result. XDocument xdoc = XDocument.Parse(xml); xdoc.Save(strFileName); After writing this two lines getting error as Access to the path is denied. Please help me asap.

satya repaka · Answer

Hi Francis After writing all the custom tags i stored in one variable and after I have written as Here xml is final result. XDocument xdoc = XDocument.Parse(xml); xdoc.Save(strFileName); After writing this two lines getting error as Access to the path is denied. Please help me asap.

Francis · Answer

How you have written if(i==5){ .........} and if(i==20){.......} I assume that your datatable contains the columns in an order. That's why i count it and use that count to insert the Custom tags.

satya repaka · Answer

Hi Francis How you have written if(i==5){ .........} and if(i==20){.......}

satya repaka · Answer

Hi Francis How to bind the final return xml to the xml file. PLease help me

Mukesh Kumar · Answer

Hi Here is the code which show how to create xml node through loop. http://www.codeproject.com/Articles/24375/Working-with-XML http://stackoverflow.com/questions/13168491/xml-in-foreach-loop-from-dataset-in-c-sharp thanks

satya repaka · Answer

Hi Can u write the code how to loop thru the datatable and construct new xml tags

Jignesh Trivedi · Answer

Hi Using DataSet.WriteXml method can help you to convert dataset to xml string Please refer https://msdn.microsoft.com/en-us/library/hb27k0tf(v=vs.110).aspx https://msdn.microsoft.com/en-us/library/ms233698.aspx hope this will help you.

Ravi Patel · Answer

Hi Satya try this DataSet ds = new DataSet(); SqlCommand cmd = new SqlCommand(select * from usersInfo con); SqlDataAdapter da=new SqlDataAdapter(cmd); da.Fill(ds); string str = ds.GetXml(); i hope this will help you

Mukesh Kumar · Answer

Hi You can simply do as following. string xmlData = northwindDataSet.GetXml(); Hope this will help you. thanks