Hi to all,
pls convert the following asp.net vb code to asp.net c#
Response.Clear()
Response.ContentType = "application/rss+xml"
Dim objX As New XmlTextWriter(Response.OutputStream, Encoding.UTF8)
objX.WriteStartDocument()
objX.WriteStartElement("urlset")
objX.WriteAttributeString("xmlns", "http://www.google.com/schemas/sitemap/0.84")
Dim oCmd As New SqlClient.SqlCommand("SELECT * FROM pages ORDER BY date_updated DESC", sqlConn)
Dim oRdr As SqlClient.SqlDataReader = oCmd.ExecuteReader
If oRdr.HasRows Then
While oRdr.Read
objX.WriteStartElement("url")
objX.WriteElementString("loc", "http://www.yoursite.com/Pages.aspx?pageid=" & oRdr("page_id"))
objX.WriteElementString("priority", "0.7")
objX.WriteEndElement() 'URL
End While
End If
oRdr.Close()
oCmd.Dispose()
objX.WriteEndElement() 'URLset
objX.WriteEndDocument()
objX.Flush()
objX.Close()
Response.End()
|
| Author: Arun Rajan 04 Aug 2008 | Member Level: Gold | Rating:  Points: 2 |
visit http://labs.developerfusion.co.uk/convert/vb-to-csharp.aspx
there are many other such tools online that will make your job easy!
|
| Author: Santhanakrishnan 04 Aug 2008 | Member Level: Silver | Rating: Points: 0 |
thank u.
SanthanaM
|
| Author: Sujith S 05 Aug 2008 | Member Level: Silver | Rating: Points: 6 |
{
Response.Clear();
Response.ContentType = "application/rss+xml";
XmlTextWriter objX = new XmlTextWriter(Response.OutputStream, Encoding.UTF8);
objX.WriteStartDocument();
objX.WriteStartElement("urlset");
objX.WriteAttributeString("xmlns", "http://www.google.com/schemas/sitemap/0.84");
SqlClient.SqlCommand oCmd = new SqlClient.SqlCommand("SELECT * FROM pages ORDER BY date_updated DESC", sqlConn);
SqlClient.SqlDataReader oRdr = oCmd.ExecuteReader;
if (oRdr.HasRows) {
while (oRdr.Read) {
objX.WriteStartElement("url");
objX.WriteElementString("loc", "http://www.yoursite.com/Pages.aspx?pageid=" + oRdr("page_id"));
objX.WriteElementString("priority", "0.7");
objX.WriteEndElement();
//URL
}
}
oRdr.Close();
oCmd.Dispose();
objX.WriteEndElement();
//URLset
objX.WriteEndDocument();
objX.Flush();
objX.Close();
Response.End();
}
|
| Author: Ashok 05 Aug 2008 | Member Level: Gold | Rating: Points: 6 |
The equivalent C# coding is given below.....
{
Response.Clear();
Response.ContentType = "application/rss+xml";
XmlTextWriter objX = new XmlTextWriter(Response.OutputStream, Encoding.UTF8);
objX.WriteStartDocument();
objX.WriteStartElement("urlset");
objX.WriteAttributeString("xmlns", "http://www.google.com/schemas/sitemap/0.84");
SqlClient.SqlCommand oCmd = new SqlClient.SqlCommand("SELECT * FROM pages ORDER BY date_updated DESC", sqlConn);
SqlClient.SqlDataReader oRdr = oCmd.ExecuteReader;
if (oRdr.HasRows) {
while (oRdr.Read) {
objX.WriteStartElement("url");
objX.WriteElementString("loc", "http://www.yoursite.com/Pages.aspx?pageid=" + oRdr("page_id"));
objX.WriteElementString("priority", "0.7");
objX.WriteEndElement();
//URL
}
}
oRdr.Close();
oCmd.Dispose();
objX.WriteEndElement();
//URLset
objX.WriteEndDocument();
objX.Flush();
objX.Close();
Response.End();
}
|