nitin singla

In application there is a utility to export data from database to XML file and then import the same in another system. The system is designed using .NET Framework 3.5. The utility fails when trying to export the data around 100000 rows in table. Out of memory exception is raised The code snippet is as follows private void ExportTableAsXml(ref XmlNode rootElement,Hashtable externalParameters) { DataTable result = null; if (commandTypeField == CommandType.StoredProcedure) { } else if (commandTypeField == CommandType.Text) { DataSet resultDataSet = xdo.ExecDataSetSQL(sqlStatementField); if (resultDataSet != null && resultDataSet.Tables.Count > 0) result = resultDataSet.Tables[0]; } XmlNode containerElement = rootElement; if (result != null && result.Rows.Count != 0) { if (containerNameField != string.Empty) containerElement = rootElement.OwnerDocument.CreateElement(containerNameField); if (!ResultIsXml) ConvertTableToXml(ref containerElement, result); else { StringBuilder xmlBuilder = new StringBuilder(); if (result.Columns.Count == 1) { foreach(DataRow row in result.Rows) { if (!row.IsNull(result.Columns[0])) { xmlBuilder.Append(row[0]); }