How to save xml url into sqlserver database by asp.net

Rajveer singh

hi all,

I have a xml url ,hit this url open data in xml format now save this data into sqlserver table how please Help for this question.

Thanks

Rajveer Singh

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Anil Kumar11y ago
Accepted answer
File is looking like the output of the web service.. If it is so then you can access it using the proxy class in you client application

OR

use "http://www.beansoftware.com/ASP.NET-FAQ/Read-Page-HTML.aspx" to simply get the source of the file and save it in sql..

Rajveer singh11y ago

ok sir , But i face problem

System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a send. ---> System.IO.IOException: Received an unexpected EOF or 0 bytes from the transport stream.    at System.Net.FixedSizeReader.ReadPacket(Byte[] buffer, Int32 offset, Int32 count)    at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, AsyncProtocolRequest asyncRequest)    at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)    at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)    at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)    at System.Net.Security.SslState.ForceAuthentication(Boolean receiveFirst, Byte[] buffer, AsyncProtocolRequest asyncRequest)    at System.Net.Security.SslState.ProcessAuthentication(LazyAsyncResult lazyResult)    at System.Net.TlsStream.CallProcessAuthentication(Object state)    at System.Threading.ExecutionContext.runTryCode(Object userData)    at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)    at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)    at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)    at System.Net.TlsStream.ProcessAuthentication(LazyAsyncResult result)    at System.Net.TlsStream.Write(Byte[] buffer, Int32 offset, Int32 size)    at System.Net.PooledStream.Write(Byte[] buffer, Int32 offset, Int32 size)    at System.Net.ConnectStream.WriteHeaders(Boolean async)    --- End of inner exception stack trace ---    at System.Net.HttpWebRequest.GetResponse()    at Service.SAVERTI() in c:\Users\Administrator\Desktop\RTISERVICES\App_Code\Service.cs:line 49

Rajveer singh11y ago
This Url:-http://rtionline.gov.in/webservice/website_display.php?servicecode=sfIMQjFojvyPFNy5y4u4JbrzHY9kOikC3%2F7wv1eUWLU%3D&un=Oe9nk14AhqGUGGSPv%2Fnjcb7epVva7cauUx21oOYROBw%3D&pd=HlOIa%2B%2BDDBa6ncUlpce6ehhIxvrx19iNqAlGx7gLNNYPP9NDjD2qGHUG7MuZjzAiufiiMEVt6hy5legUphkXRw%3D%3D

and hit this url open data xml formate:-
1
MOIAB/R/2015/00208
nil
Information, Education and Communication stategy on infant and young child feeding
19/02/2015
Physically reply
https://rtionline.gov.in/webservice/viewpdf_request.php?reg=Rn%2BdzLm8DVyUZzgl29pm%2FY2l9w8792uqFsA5M6E%2BP7E%3D
https://rtionline.gov.in/webservice/viewpdf_reply.php?regId=Rn%2BdzLm8DVyUZzgl29pm%2FY2l9w8792uqFsA5M6E%2BP7E%3D
nil
nil
nil
nil
nil
nil
Anil Kumar11y ago
Can you share the sample xml data which you want to save in sql?
Rajveer singh11y ago
But sir data come from Http url ,please i Request u please share code for this ,Please

Thanks

Rajveer Singh
Anil Kumar11y ago
Sql provides "XML" data type to store xml data. You can create a table in sql server with xml data type column and use it to store your xml data.

Example :
CREATE TABLE XmlTest(
ID int NOT NULL,
XmlDesc xml NOT NULL)
GO

Rest process in your c# code is same as you save data for other data formats

Please mark this solution as accepted if it solves the purpose