Comments by Hidhoud1991 (Top 34 by date)

I did as below but same error: The process cannot access the file 'C:\inetpub\wwwroot\XXXXX\App_Data\XML\Setting.xml' because it is being used by another process.

Public Class XMlFileLock
Private Shared xmlfilename As String
Private Shared xml As New System.Xml.XmlDocument()
Shared Sub New()
xmlfilename = System.Web.Hosting.HostingEnvironment.MapPath("App_Data\XML\Setting.xml")
xml.Load(xmlfilename)
End Sub
Public Shared Sub SetSettingStsXML()
Dim XXXNodeAs System.Xml.XmlNodeList = xml.SelectNodes("descendant::XXX_Status[X_status ='Active']")
Dim XXXNode As New List(Of String)
For Each SerNod As System.Xml.XmlNode In XXXNode
......
Next
If xxID.Count > 0 Then
........
End If

Dim activexxDt As DataTable =.......
activexxDt.TableName = "XXXX_Status"

activexxDt.WriteXml(XmlFilename, XmlWriteMode.WriteSchema, True)
End Sub
End Class

Called by: XMlFileLock.SetSettingStsXML() from every running thread

they will exceed the 900 byte allowed for index size

if u r inserting a row you put N before the text so how can that be done in insert into select

its not a coding issue, i don't know where the problem persists, its with the android application or with the web-service that is sending the push notification.