Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
first problem is the code below code able to convert xml to database, but the root <template id="21000"> must be remove. but i am not able to remove it. Public Sub Read_XML_File() Dim ds As New DataSet 'Read File to Data Set ds.ReadXml("t_info_dir.xml") Dim TableCounter As Integer = 0 Dim dr As DataRow Dim dataTableXml As Data.DataTable Dim sqlCmd As String = "" Dim ColCounter As Integer = 0 For TableCounter = 0 To ds.Tables.Count - 1 dataTableXml = ds.Tables(TableCounter) For Each dr In dataTableXml.Rows sqlCmd = "" sqlCmd = "insert into [" & dataTableXml.TableName & "] (" For i As Integer = 0 To dataTableXml.Columns.Count - 1 sqlCmd = sqlCmd + dataTableXml.Columns(i).ColumnName.ToString() + "," Next sqlCmd = sqlCmd.Substring(0, sqlCmd.Length - 1) + ") values (" For x As Integer = 0 To dataTableXml.Columns.Count - 1 Dim d As System.DateTime Dim isDate As Boolean If (DateTime.TryParse(dr(x).ToString(), d)) Then 'Checks If the Column is of Type Date isDate = True Else isDate = False End If If (isDate) Then sqlCmd = sqlCmd + "'" + Format(CDate(d.ToString), "dd/MMM/yyyy") + "'," ElseIf InStr(dr(x).ToString, "'", CompareMethod.Text) <> 0 Then sqlCmd = sqlCmd + "'" + dr(x).ToString().Replace("'", "''") + "'," Else sqlCmd = sqlCmd + "'" + dr(x) + "'," End If Next sqlCmd = sqlCmd.Substring(0, sqlCmd.Length - 1) + ");" 'Now Insert Query is prepared 'Run This query; Record will be inserted Next Next End Sub another problem is the xml file have multiple screenshot and multiple child, this will duplicate the field, that also create error to insert to database. anyone expert guru pls help with the best solution and advice. thank!!!