Accessing SharePoint List through windows application

We have a project requirement to create a .Net windows application to update a remote SharePoint list.

We tried making a SharePoint connection in server explorer and found that we need to have MOSS installed in our local system for that, but it is not feasible to have MOSS installed in local systems.

 

Alternatively, we added a service reference of the SharePoint site to the solution.

When you add a service reference to a project, the WCF Data Services support can inspect the target site and build a DataContext class that exposes a property for each list in the site.

Hence, using the object of that DataContext class we tried accessing the SharePoint as below:

 

 

 

We are receiving the attached exception while fetching the list data in foreach loop.

 

Please suggest as to how we can connect to the SharePoint site to fetch and update the lists data.

We are able to access the site and list in internet explorer.

 

Exception is Below:

 

System.Net.WebException was unhandled


Message=The underlying connection was closed: An unexpected error occurred on a receive.


Source=System


StackTrace:


at System.Net.HttpWebRequest.GetResponse()


at System.Data.Services.Client.QueryResult.Execute()


at System.Data.Services.Client.DataServiceRequest.Execute[TElement](DataServiceContext context, QueryComponents queryComponents)


at System.Data.Services.Client.DataServiceQuery`1.Execute()


at System.Data.Services.Client.DataServiceQuery`1.GetEnumerator()


at ITPOS.Form1.button1_Click(Object sender, EventArgs e) in D:\ITPOS\ITPOS\ITPOS\Form1.cs:line 31


at System.Windows.Forms.Control.OnClick(EventArgs e)


at System.Windows.Forms.Button.OnClick(EventArgs e)


at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)


at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)


at System.Windows.Forms.Control.WndProc(Message& m)


at System.Windows.Forms.ButtonBase.WndProc(Message& m)


at System.Windows.Forms.Button.WndProc(Message& m)


at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)


at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)


at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)


at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)


at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)


at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)


at System.Windows.Forms.Application.Run(Form mainForm)


at ITPOS.Program.Main() in D:\ITPOS\ITPOS\ITPOS\Program.cs:line 23


at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)


at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)


at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()


at System.Threading.ThreadHelper.ThreadStart_Context(Object state)


at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx)


at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)


at System.Threading.ThreadHelper.ThreadStart()


InnerException: System.IO.IOException


Message=Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.


Source=System


StackTrace:

at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)

at System.Net.FixedSizeReader.ReadPacket(Byte[] buffer, Int32 offset, Int32 count)

at System.Net.Security._SslStream.StartFrameHeader(Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest)

at System.Net.Security._SslStream.StartReading(Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest)

at System.Net.Security._SslStream.ProcessRead(Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest)

at System.Net.TlsStream.Read(Byte[] buffer, Int32 offset, Int32 size)

at System.Net.PooledStream.Read(Byte[] buffer, Int32 offset, Int32 size)

at System.Net.Connection.SyncRead(HttpWebRequest request, Boolean userRetrievedStream, Boolean probeRead)

InnerException: System.Net.Sockets.SocketException

Message=An existing connection was forcibly closed by the remote host

Source=System

ErrorCode=10054

NativeErrorCode=10054

StackTrace:

at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)

at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)

InnerException: