public string GetDataStringXml(DataSet objToXML)
{
StringBuilder strXml = new StringBuilder();
strXml.Append("='1.0'='utf-8'");
strXml.Append("<" + objToXML.DataSetName + ">");
foreach (DataRow dataRow in objToXML.Tables[0].Rows)
{
strXml.Append("<" + objToXML.Tables[0].TableName + ">");
foreach (DataColumn dataColumn in objToXML.Tables[0].Columns)
{
if (dataRow[dataColumn].ToString() == "")
{
strXml.Append("<" + dataColumn.ColumnName + ">" +
GetDefault(dataColumn.DataType) +
"</" + dataColumn.ColumnName + ">");
}
else
{
strXml.Append("<" + dataColumn.ColumnName + ">" +
dataRow[dataColumn] +
"</" + dataColumn.ColumnName + ">");
}
}
strXml.Append("</" + objToXML.Tables[0].TableName + ">");
}
strXml.Append("</" + objToXML.DataSetName + ">");
return strXml.ToString();
}
Solved it myself..Created this function which adds the default value for the column if its empty and keeps the count of rows constant.