Breaking News

Editors Picks

Tuesday, November 29, 2011

String Format for DateTime [C#]

String Format for DateTime [C#]

// create date time 2008-03-09 16:05:07.123
DateTime dt = new DateTime(2008, 3, 9, 16, 5, 7, 123);

String.Format("{0:y yy yyy yyyy}", dt);  // "8 08 008 2008"   year
String.Format("{0:M MM MMM MMMM}", dt);  // "3 03 Mar March"  month
String.Format("{0:d dd ddd dddd}", dt);  // "9 09 Sun Sunday" day
String.Format("{0:h hh H HH}", dt);  // "4 04 16 16"      hour 12/24
String.Format("{0:m mm}", dt);  // "5 05"            minute
String.Format("{0:s ss}", dt);  // "7 07"            second
String.Format("{0:f ff fff ffff}", dt);  // "1 12 123 1230"   sec.fraction
String.Format("{0:F FF FFF FFFF}", dt);  // "1 12 123 123"    without zeroes
String.Format("{0:t tt}", dt);  // "P PM"            A.M. or P.M.
String.Format("{0:z zz zzz}", dt);  // "-6 -06 -06:00"   time zone
// date separator culture is "."
String.Format("{0:d/M/yyyy HH:mm:ss}", dt); // "9/3/2008 16:05:07"
String.Format("{0:d/M/yyyy HH:mm:ss}", dt); // "9.3.2008 16:05:07"

// month/day numbers without/with leading zeroes
String.Format("{0:M/d/yyyy}", dt);            // "3/9/2011"
String.Format("{0:MM/dd/yyyy}", dt);          // "13/09/2011"

// day/month names
String.Format("{0:ddd, MMM d, yyyy}", dt);    // "Sun, Mar 9, 2011"
String.Format("{0:dddd, MMMM d, yyyy}", dt);  // "Sunday, March 9, 2011"

// two/four digit year
String.Format("{0:MM/dd/yy}", dt);            // "13/09/11"
String.Format("{0:MM/dd/yyyy}", dt);          // "13/09/2011"
//standard format specifiers
String.Format("{0:t}", dt);  // "4:05 PM"                         ShortTime
String.Format("{0:d}", dt);  // "13/9/2011"                        ShortDate
String.Format("{0:T}", dt);  // "4:05:07 PM"                      LongTime
String.Format("{0:D}", dt);  // "Sunday, March 09, 2011"          LongDate
String.Format("{0:f}", dt);  // "Sunday, March 09, 2011 4:05 PM"  LongDate+ShortTime
String.Format("{0:F}", dt);  // "Sunday, March 09, 2011 4:05:07 PM" FullDateTime
String.Format("{0:g}", dt);  // "3/9/2011 4:05 PM"                ShortDate+ShortTime
String.Format("{0:G}", dt);  // "3/9/2011 4:05:07 PM"             ShortDate+LongTime
String.Format("{0:m}", dt);  // "March 11"                        MonthDay
String.Format("{0:y}", dt);  // "March, 2011"                     YearMonth
String.Format("{0:r}", dt);  // "Sun, 09 Mar 2011 16:05:07 GMT"   RFC1123
String.Format("{0:s}", dt);  // "2011-03-09T16:05:07"             SortableDateTime
String.Format("{0:u}", dt);  // "2011-03-09 16:05:07Z"            UniversalSortableDateTime

 

Read more ...

How to convert a string to a date - .NET sample code

How to convert a string to a date - .NET sample code

public string GetAnalysisTimeDuration(string strFromDate, string strToDate)
{
string strDuration = "";
try
{
DateTime dateStart = Convert.ToDateTime(strFromDate);
DateTime dateEnd = Convert.ToDateTime(strToDate);
if (dateStart.Year != dateEnd.Year)
strDuration = String.Format("{0:MMM d,yyyy}", dateStart) + " - " + String.Format("{0:MMM d,yyyy}", dateEnd);
else
strDuration = String.Format("{0:MMM d}", dateStart) + " - " + String.Format("{0:MMM d,yyyy}", dateEnd);
}
catch (Exception ex)
{

}
return strDuration;
}

 

 

Read more ...

export to excel in asp.net from dataset or datatable

export to excel in asp.net from dataset or datatable


public void ExportToExcel(DataSet dataset, string DestFileName)
{
if (System.IO.File.Exists(DestFileName))
{
System.IO.File.Delete(DestFileName);
}
Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook excelWorkBook = default(Microsoft.Office.Interop.Excel.Workbook);
excelWorkBook = excelApp.Workbooks.Add(Type.Missing);
int sheetIndex = 0;
int col = 0;
int row = 0;
Microsoft.Office.Interop.Excel.Worksheet excelSheet = default(Microsoft.Office.Interop.Excel.Worksheet);
foreach (System.Data.DataTable dt1 in dataset.Tables)
{
sheetIndex += 1;
object[,] rawData = new object[dt1.Rows.Count + 1, dt1.Columns.Count];
for (col = 0; col <= dt1.Columns.Count - 1; col++)
{
rawData[0, col] = dt1.Columns[col].ColumnName;
}
for (col = 0; col <= dt1.Columns.Count - 1; col++)
{
for (row = 0; row <= dt1.Rows.Count - 1; row++)
{
rawData[row + 1, col] = dt1.Rows[row].ItemArray[col];
}
}
string finalColLetter = string.Empty;
string colCharset = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";
int colCharsetLen = colCharset.Length;
if (dt1.Columns.Count > colCharsetLen)
{
finalColLetter = colCharset.Substring((dt1.Columns.Count - 1) / colCharsetLen - 1, 1);
}
finalColLetter += colCharset.Substring((dt1.Columns.Count - 1) % colCharsetLen, 1);
excelSheet = (Microsoft.Office.Interop.Excel.Worksheet)excelWorkBook.Worksheets.get_Item(sheetIndex);
excelSheet.Name = dt1.TableName;
string excelRange = string.Format("A1:{0}{1}", finalColLetter, dt1.Rows.Count + 1);
excelSheet.get_Range(excelRange, Type.Missing).Value2 = rawData;

//int colcount = excelSheet.Cells.CurrentRegion.Columns.Count;
string excelRange1 = string.Format("A1:{0}{1}", finalColLetter, 1);
excelSheet.get_Range(excelRange1, Type.Missing).Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Blue);
excelSheet.get_Range(excelRange1, Type.Missing).Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.White);
excelSheet.get_Range(excelRange1, Type.Missing).Font.Bold = true;
excelSheet = null;
}
string e = System.IO.Path.GetExtension(DestFileName);
if (e == ".csv")
{
excelWorkBook.SaveAs(DestFileName, Microsoft.Office.Interop.Excel.XlFileFormat.xlCSVMSDOS, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing);
}
else if (e == ".xls")
{
excelWorkBook.SaveAs(DestFileName, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing);
}

GC.Collect();
GC.WaitForPendingFinalizers();
excelWorkBook.Close(true, Type.Missing, Type.Missing);
Marshal.FinalReleaseComObject(excelWorkBook);
excelApp.Quit();
Marshal.FinalReleaseComObject(excelApp);
}




Read more ...

Contact Us

Name

Email *

Message *