Geek asks and answers

How to format Date in ASP.NET

I launch my Facebook status feed through Yahoo channels and display it / embed it on the page of my own website.

The XML feed contains the date. I want to format the date, but don’t know how to do it. The XML part is the output of the date ... <pubDate>Thu, 14 Jul 2011 20:38:07 +0100</pubDate>and I would like it to display something like 07/14/2011.

Any help is greatly appreciated.

I have C # code ...

protected void Page_Load(object sender, EventArgs e)
    {

        WebRequest MyRssRequest = WebRequest.Create("http://pipes.yahoo.com/pipes/pipe.run?FacebookRssUrl=http%3A%2F%2Fwww.facebook.com%2Ffeeds%2Fpage.php%3Fid%3D456456456456456%26format%3Drss20&_id=456456456456456456464&_render=rss");
        WebResponse MyRssResponse = MyRssRequest.GetResponse();

        Stream MyRssStream = MyRssResponse.GetResponseStream();

        // Load previously created XML Document
        XmlDocument MyRssDocument = new XmlDocument();
        MyRssDocument.Load(MyRssStream);

        XmlNodeList MyRssList = MyRssDocument.SelectNodes("rss/channel/item");

        string sTitle = "";
        string sLink = "";
        string sDescription = "";

        // Iterate/Loop through RSS Feed items
        for (int i = 0; i < 3; i++)
        {
            XmlNode MyRssDetail;

            MyRssDetail = MyRssList.Item(i).SelectSingleNode("title");
            if (MyRssDetail != null)
                sTitle = MyRssDetail.InnerText;
            else
                sTitle = "";

            MyRssDetail = MyRssList.Item(i).SelectSingleNode("link");
            if (MyRssDetail != null)
                sLink = MyRssDetail.InnerText;
            else
                sLink = "";

            MyRssDetail = MyRssList.Item(i).SelectSingleNode("pubDate");
            if (MyRssDetail != null)
                sDescription = MyRssDetail.InnerText;

            else
            {
                sDescription = "";
            }

            // Now generating HTML table rows and cells based on Title,Link & Description
            HtmlTableCell block = new HtmlTableCell();
            block.InnerHtml = "<span style='font-weight:bold'><a href='" + sLink + "' target='new'>"+ sTitle + "</a></span>";
            HtmlTableRow row = new HtmlTableRow();
            row.Cells.Add(block);
            tbl_Feed_Reader.Rows.Add(row);
            HtmlTableCell block_description = new HtmlTableCell();
            block_description.InnerHtml = "<p align='justify'>" + sDescription + "</p>";
            HtmlTableRow row2 = new HtmlTableRow();
            row2.Cells.Add(block_description);
            tbl_Feed_Reader.Rows.Add(row2);
        }
    }
0
source share
5 answers

You can parse it on a DateTime and make it in the specific format you want.

var x = DateTime.Parse(MyRssDetail.InnerText);
//Your date format
sDescription = x.ToString("d MMM yyyy");
0
source

You can save the date using DateTime.Parseor DateTime.ParseExact.

DateTime xmlDateTime = DateTime.Parse(xmlValue);

DateTime.ToString() ( ToShortDateString, ToLongDateString, ToShortTimeString ..)

xmlDateTime.ToShortDateString();
0

I would do something like:

DateTime parsedDate=DateTime.Min;
if(DateTime.TryParse(xmlStringWithDate,ref parsedDate))
{
   //Do something useful with parsedDate since the parse was successful
}
0
source 
String.Format({0:D}, dateToFormat)

I assume you want to make pubDate?

sDescription = String.Format({0:D}, MyRssDetail.InnerText.ToDate())
0
source

You can use String.Format for this:

 sDescription = String.Format("{0:D}", MyRssDetail.InnerText);

Or convert it to a date, then from there:

sDescription = Convert.ToDateTime(MyRssDetail.InnerText).toShortDateString();
0
source

More articles:


All Articles