There is an unclosed Literal on Line 1

Trips · Jun 24, 2008

Hi,
I have the following function in C#,

----------------------

public string grabIFTMBF(clsMessage msg)
{
StreamReader ssReader = null;
SqlConnection sql = null;
SqlCommand sCommand = null;
SqlParameter sParameter = null;
XmlTextWriter xWriter = null;
XmlReader xmlReader = null;
try

{
sql = new SqlConnection(Properties.Settings.Default.ConnectionString);
sCommand = new SqlCommand(msg.msg_OutProcedure, sql);
sCommand.CommandType = System.Data.CommandType.StoredProcedure;
sql.Open();
xmlReader = sCommand.ExecuteXmlReader();
sql.Close();
Console.WriteLine(xmlReader.ReadOuterXml());
XmlWriterSettings xSettings = new XmlWriterSettings();
xSettings.Indent = true;
XPathDocument xp = new XPathDocument(xmlReader, XmlSpace.Preserve);
XPathNavigator xn = xp.CreateNavigator();
XmlDocument xd = new XmlDocument();
XmlNode root = xd.CreateElement("root");
root.InnerXml = xn.OuterXml;
xd.AppendChild(root);
string interMediate = Path.Combine(Properties.Settings.Default.IFTMBF_Process, msg.msg_Type + ".xml");
xd.Save(interMediate);
xmlReader.Close();

msg.msg_OutXML = interMediate;
return interMediate;
}
catch (Exception ex)
{
if (sql != null)
{
if (sql.State == ConnectionState.Open || sql.State == ConnectionState.Broken) { sql.Close(); }
sql = null;
}
if (ssReader != null) { ssReader = null; }
if (sCommand != null) { sCommand = null; }
if (sParameter != null) { sParameter = null; }
if (xWriter != null) { xWriter = null; }
clsErrorHandler.logErrorEvent("Couldnt grab data from Stored Procedure", "ERROR", "Check Stored Procedure in SQL Query Analyzer");
clsLog.writeToLog("|==? Error # clsDataAccess 002 -- ");
clsLog.writeToLog("|==? Problem: " + ex.Message);
return "";
}
finally

{
if (ssReader != null) { ssReader = null; }
if (sql != null) { sql.Close(); sql = null; }
if (sCommand != null) { sCommand = null; }
if (sParameter != null) { sParameter = null; }
if (xWriter != null) { xWriter = null; }
}
}


------------------------------

It returns the following error...

<font color="#000000 I dont know what is going wrong...I am getting XML RAW from SQL Server 2000. But it is returning the aforementioned error. There is no error in the Stored Procedure... It is returning values properly in the Query Analyzer. 


View the full article

There is an unclosed Literal on Line 1

Trips

Well-known member