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 ...