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

[RobJacko]

\[code\] 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\]Above is my code for my 3-tier \[code\]Data Access Layer\[/code\]. I need to save the above code into an \[code\]XML\[/code\] file. How do I do this?