Dim loDataSet As DataSet = New DataSet loDataSet.Tables.Add("Temp") loDataSet.Tables(0).Columns.Add("Claim_No", GetType(System.String)) loDataSet.Tables(0).Columns.Add("Supplement", GetType(System.String))Then, I scan the main dataset and take the required data in the dataset that was created manually:
For lnCounter = 1 To toDataProvider.nCount loRow = toDataProvider.oDataView(lnCounter - 1).Row loRow2 = loDataSet.Tables(0).NewRow loRow2("Claim_No") = Trim(loRow("No_Claim")) loRow2("Supplement") = Trim(loRow("Supplement")) NextThen, I do the export.
loDataSet.WriteXml(oApp.cHttpFat + lcFile, XmlWriteMode.IgnoreSchema)