Suggestions for a better way to serialize data from a stored procedure.

Question

0.00/5 (No votes)

See more:

I am creating a service that accepts a stored procedure and user input from an ASP page and is supposed to return the data in XML format back to the page. I am having trouble trying to figure out how to accomplish this. Can anyone suggest a better way to go about this and/or explain the flaw in my method? At first I was returning a string with the method, then I tried to just write an XML document with the results of the stored procedure in an attempt to access the XML file on the ASP page.

I have not been able to find a good example to extrapolate from. Please let me know if more clarification is needed.

Thank you!

Here is the code-behind I have:

public void DataExchange(string storedProcedure, string data)
       {
           string connString = ConfigurationManager.ConnectionStrings["DataExchangeConnString"].ConnectionString;
           //string returnData = "";
           int i = 0;

           SqlParameter dataParameter = new SqlParameter();
           dataParameter.Value = data;
           dataParameter.ParameterName = "@data";

           SqlConnection conn = new SqlConnection(connString);
           SqlCommand cmd = new SqlCommand(storedProcedure, conn);
           SqlDataReader reader = null;

           cmd.CommandType = CommandType.StoredProcedure;
           cmd.Parameters.Add(dataParameter);

           try
           {
               conn.Open();
               reader = cmd.ExecuteReader();
               string FileName = @"..\xmlDOC\returnData.xml";

               SqlDataAdapter objDataAdapter = new SqlDataAdapter(reader.ToString(), connString);
               DataSet objDataSet = new DataSet("Data");
               // Fill DataSet
               objDataAdapter.Fill(objDataSet, "Data");
               // Write DataSet contents to file
               objDataSet.WriteXml(FileName, XmlWriteMode.IgnoreSchema);

               //while (reader.Read())
               //{
               //    for (i = 0; i < reader.FieldCount; i++)
               //    {
               //        returnData += (reader[i] + "|");
               //    }
               //    return returnData;
               //}
               //return false.ToString();
           }
           catch (Exception)
           {
               throw;
           }
           finally
           {
               reader.Close();
               conn.Close();
           }
       }

Posted 4-Dec-12 6:27am

Richard C Bishop

Updated 4-Dec-12 8:34am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Teenustar · Accepted Answer · 2012-12-04T09:07:00

Try this

With Generics

XML

public static string SerializeToXml<T>(T value)
{
    StringWriter writer = new StringWriter(CultureInfo.InvariantCulture);
    XmlSerializer serializer = new XmlSerializer(typeof(T));
    serializer.Serialize(writer, value);
    return write.ToString();
}

Without Generics

public static string SerializeToXml(object value)
{
  StringWriter writer = new StringWriter(CultureInfo.InvariantCulture);
  XmlSerializer serializer = new XmlSerializer(value.GetType());
  serializer.Serialize(writer, value);
  return writer.ToString();
}

To Deserialize

C#

function T Deserialize<T>(string s)
{
    var serializer = new XmlSerializer(typeof(T));
    var stringReader = new StringReader(serializedResults);

    var obj = (T)serializer.Deserialize(stringReader);
    stringReader.Dispose();

    return obj;
}