How to save Output Data into XML File Microsoft visual Studio 2010

Question

    public AdvertisementDAL selectAdvertisementLocation1(DateTime now, string gender)
    {
        AdvertisementDAL dal = null;
        string sql = "Select * From Advertisement Where @currentDate between StartDate AND EndDate AND TargetAudience = @gender AND Location = 1";
        SqlConnection conn = new SqlConnection(_connStr);
        SqlCommand cmd = new SqlCommand(sql, conn);
        cmd.Parameters.AddWithValue("@currentDate", now);
        cmd.Parameters.AddWithValue("@gender", gender);
        conn.Open();
        SqlDataReader dr = cmd.ExecuteReader();

        while (dr.Read())
        {
            _advertisementID = int.Parse(dr["AdvertisementID"].ToString());
            _location = int.Parse(dr["Location"].ToString());
            _image = dr["Image"].ToString();
            _targetAudience = dr["TargetAudience"].ToString();
            _url = dr["Url"].ToString();
            _onMouseOverText = dr["OnMouseOverText"].ToString();
            dal = new AdvertisementDAL(_advertisementID, _location, _image, _targetAudience,
                _url, _onMouseOverText);
        }
        conn.Close();
        dr.Close();
        dr.Dispose();
        return dal;
    }

Above is my code for my 3-tier Data Access Layer. I need to save the above code into an XML file. How do I do this?

you need to take a look at how to Serialize an Object or how to Serialize data do a good search there are tons of examples out there on the internet — MethodMan, Jan 29 '13 at 03:21
I tried using google. but most of the answer is doing it on 2 tier programming — user1861753, Jan 29 '13 at 03:23
it should not make a difference when you are returning dal in your case.. look at XML Serialization ..Nice Try thou, perhaps you should create a Class of the dal and then google how to serialize Class data.. — MethodMan, Jan 29 '13 at 03:24
Here is a good link [Serialize Objects to XML](http://www.switchonthecode.com/tutorials/csharp-tutorial-serialize-objects-to-a-file) I found it really easy doing a `google` search — MethodMan, Jan 29 '13 at 03:28
unable to do what..? your comments don't make sense.. you mean you don't understand how to build or do XML..? perhaps you need to re think your question.. — MethodMan, Jan 29 '13 at 03:35

score 0 · Accepted Answer · answered Jan 29 '13 at 04:23

<?xml version="1.0" encoding="ISO-8859-1"?>
<code>
  <![CDATA[
public AdvertisementDAL selectAdvertisementLocation1(DateTime now, string gender)
    {
        AdvertisementDAL dal = null;
        string sql = "Select * From Advertisement Where @currentDate between StartDate AND EndDate AND TargetAudience = @gender AND Location = 1";
        SqlConnection conn = new SqlConnection(_connStr);
        SqlCommand cmd = new SqlCommand(sql, conn);
        cmd.Parameters.AddWithValue("@currentDate", now);
        cmd.Parameters.AddWithValue("@gender", gender);
        conn.Open();
        SqlDataReader dr = cmd.ExecuteReader();

        while (dr.Read())
        {
            _advertisementID = int.Parse(dr["AdvertisementID"].ToString());
            _location = int.Parse(dr["Location"].ToString());
            _image = dr["Image"].ToString();
            _targetAudience = dr["TargetAudience"].ToString();
            _url = dr["Url"].ToString();
            _onMouseOverText = dr["OnMouseOverText"].ToString();
            dal = new AdvertisementDAL(_advertisementID, _location, _image, _targetAudience,
                _url, _onMouseOverText);
        }
        conn.Close();
        dr.Close();
        dr.Dispose();
        return dal;
    }
]]>
</code>

Presto.. C# in XML format.

have you tried DataSet ds =new DataSet(); ds.WriteXmlSchema(); — skhurams, Jan 29 '13 at 05:05

score 0 · Answer 2 · edited Jan 29 '13 at 05:09

public AdvertisementDAL selectAdvertisementLocation1(DateTime now, string gender)
    {
        AdvertisementDAL dal = null;
        string sql = "Select * From Advertisement Where @currentDate between StartDate AND EndDate AND TargetAudience = @gender AND Location = 1";
        SqlConnection conn = new SqlConnection(_connStr);
        SqlCommand cmd = new SqlCommand(sql, conn);
        cmd.Parameters.AddWithValue("@currentDate", now);
        cmd.Parameters.AddWithValue("@gender", gender);
        conn.Open();
        SqlDataReader dr = cmd.ExecuteReader();

    while (dr.Read())
    {
        _advertisementID = int.Parse(dr["AdvertisementID"].ToString());
        _location = int.Parse(dr["Location"].ToString());
        _image = dr["Image"].ToString();
        _targetAudience = dr["TargetAudience"].ToString();
        _url = dr["Url"].ToString();
        _onMouseOverText = dr["OnMouseOverText"].ToString();
        dal = new AdvertisementDAL(_advertisementID, _location, _image, _targetAudience,
            _url, _onMouseOverText);
       System.IO.StreamWriter file = new System.IO.StreamWriter(
    @"c:\temp\SerializationOverview.xml"); //rmb to create the file
writer.Serialize(file, dal);
file.Close();
    }
    conn.Close();
    dr.Close();
    dr.Dispose();
    return dal;
}

How to save Output Data into XML File Microsoft visual Studio 2010

2 Answers2