Month: July 2010

DateTime date1 = Convert.ToDateTime(“15-03-2010 3:30:00 AM”); //start day of daylighttime //DateTime date1 = Convert.ToDateTime(“07-11-2010 3:30:00 AM”); //DateTime date1 = Convert.ToDateTime(“08-11-2010 3:30:00 AM”); // end day of daylighttime //set local timezone TimeZoneInfo sourceTimeZone = TimeZoneInfo.Local; //get system timezones list System.Collections.ObjectModel.ReadOnlyCollection timeZone = TimeZoneInfo.GetSystemTimeZones(); List tz = timeZone.ToList(); //get event time zone standard name epp2ClientPL.EventConfigurationProperties result = …

string strSort = “OperationDate Desc”; DataView dvTemp = dtEventHistory.DefaultView; dvTemp.Sort = strSort; IEnumerable dtRow = dvTemp.ToTable().AsEnumerable().Take(20); DataTable dtTemp = dtEventHistory.Clone(); foreach (DataRow dr in dtRow) { dtTemp.ImportRow(dr); } dvHistory = dtTemp.DefaultView;

DataTable dtCopy = table.Copy(); it will create “dtCopy” datatable with the records from “table”, DataTable dtClone = table.Clone(); it will create “dtClone” datatable without any records. it only copy structure of “table” datatable. DataTable dtCopy = dataViewTable.ToTable().copy(); it will create “dtCopy” datatablw with records only contains in DataView.

From DataSet DataTable dtStates = dsStates.Tables[0].DefaultView.ToTable(true, “state”); From DataTable DataTable dtResult = dtTemp.DefaultView.ToTable(true, “HistoryDate”); From DataView DataTable dtResult = dtView.ToTable(true, “HistoryDate”); true or false returns do u want to distict row or not. history date: is a column name

//Get the Collection of System’s Time Zones. System.Collections.ObjectModel.ReadOnlyCollection timeZone = TimeZoneInfo.GetSystemTimeZones(); //Convert time zone collection to LIST List tz = timeZone.ToList(); string strZone=””; try { strZone = tz.AsEnumerable().Where(u => u.DisplayName == “(UTC+01:00) West Central Africa”).SingleOrDefault().StandardName.ToString(); } catch (Exception ex) { Console.WriteLine(ex.Message.ToString()); } TimeZoneInfo timeZone1 = TimeZoneInfo.Local; TimeZoneInfo timeZone2 = TimeZoneInfo.FindSystemTimeZoneById(strZone.ToString()); Console.WriteLine(“================= Time Zone =============”); Console.WriteLine(timeZone1.DisplayName); …