Prakash Rathod

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 = (epp2ClientPL.EventConfigurationProperties)HttpContext.Current.Session[“EventConfiguration”];
string strZone = tz.AsEnumerable().Where(u => u.DisplayName.Contains(result.EventTitle.Substring(12))).SingleOrDefault().StandardName.ToString();

//set event time zone
TimeZoneInfo destinationTimeZone = TimeZoneInfo.FindSystemTimeZoneById(strZone.ToString());

//convert datetime to event time zone wise
TimeZoneInfo.ConvertTime(date1, destinationTimeZone).ToString(“dd-MM-yyyy hh:mm tt”);

return date1;

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);
Console.WriteLine(timeZone2.DisplayName);
DateTime dtNow = DateTime.Now;
DateTime dtOperationDate = DateTime.Now.AddHours(-1);
Console.WriteLine(“========================================”);

Console.WriteLine(“Local DateTime = ” + dtNow);
Console.WriteLine(“Local Operation Date = ” + dtOperationDate);

try
{
DateTime convertDate = TimeZoneInfo.ConvertTime(dtNow, timeZone1, timeZone2);
DateTime convertOperationDate = TimeZoneInfo.ConvertTime(dtOperationDate, timeZone1, timeZone2);
Console.WriteLine(“Converted DateTime = ” + convertDate.ToString());
Console.WriteLine(“Converted Operation Date = ” + convertOperationDate.ToString());

Console.WriteLine(“Subracted date time = ” + convertDate.Subtract(convertOperationDate).Hours
+ “:” + convertDate.Subtract(convertOperationDate).Minutes + ” hrs ago”);
}
catch(Exception ex)
{
Console.WriteLine( ex.Message.ToString());
}
}
}
}

For More information see following links:

http://msdn.microsoft.com/en-us/library/system.timezoneinfo.local.aspx

http://msdn.microsoft.com/en-us/library/8z6watww.aspx

Aspx Form
Javascript Function For Check validate time inserted or not

function CheckTime(Control) {
var txtBreakdownTime = document.getElementById(“”);
var ddlAMPM = document.getElementById(“”);
if (txtBreakdownTime != null && ddlAMPM != null) {
var BreakdownTime = txtBreakdownTime.value;
var HourNMinute = new Array();
HourNMinute = BreakdownTime.split(‘:’);
if (parseInt(HourNMinute[0]) > 12) {
alert(“Invalid Time Entry.”);
Control.focus();
}
if (parseInt(HourNMinute[1]) > 59) {
alert(“Invalid Time Entry.”);
Control.focus();
}
if (parseInt(HourNMinute[0]) == 12 && parseInt(HourNMinute[1]) > 0 && ddlAMPM.value == “PM”) {
alert(“Invalid Time Entry.”);
ddlAMPM.value = “AM”;
Control.focus();
}
}
——————————————————————

—————————————————————-
CS Page

DateTime StoppedAt;
String Start = txtDate.Text.Trim() + ” ” + txtBreakdownTime.Text.Trim() + “:00 ” + ddlAMPM.Value.Trim();
if (DateTime.TryParse(Start, out StoppedAt) == true)
{
StoppedAt = Convert.ToDateTime(Start);
sl.Add(“StoppedAt”, StoppedAt);
}

Default.aspx.cs page:

Delcare Object
DAL objDal = new DAL();
string SORT_DESC = “Desc”;
string SORT_ASC = “Asc”;

Page Load Event
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BindCountryGrid();

if (!String.IsNullOrEmpty(Request.QueryString[“Result”]))
{
DisplayMessage();
}
}
}

Bind Grid Code
private void BindCountryGrid()
{
DataTable dtCountry = new DataTable();
dtCountry = objDal.GetDataTable(“spGetCountry”);
if (dtCountry != null)
{
if (dtCountry.Rows.Count > 0)
{
dgCountry.DataSource = dtCountry;
dgCountry.DataBind();
ViewState[“dtCountry”] = dtCountry;
}
}
}

Sort the data of Gridview

protected void dgCountry_Sorting(object sender, GridViewSortEventArgs e)
{
if (ViewState[“sortMode”] == null)
{
ViewState[“sortMode”] = SORT_DESC;
}
if (ViewState[“sortMode”] != null)
{
if (Convert.ToString(ViewState[“sortMode”]).Trim().Equals(SORT_ASC))
{
ViewState[“sortMode”] = SORT_DESC;
}
else
{
ViewState[“sortMode”] = SORT_ASC;
}
}

string sortexpr = e.SortExpression;

DataView dvProd = default(DataView);
DataTable dtProd = new DataTable();
dtProd = (DataTable)ViewState[“dtCountry”];

if ((dtProd != null))
{
if (dtProd.Rows.Count > 0)
{
dvProd = dtProd.DefaultView;
dvProd.Sort = sortexpr.Trim() + ” ” + ViewState[“sortMode”];
dgCountry.DataSource = dvProd;
dgCountry.DataBind();
}
}
}

Note : You have to sorting property true of gridview on aspx page.

HtmlGenericControl myload = (HtmlGenericControl)Master.FindControl(“body”);
myload.Attributes.Add(“onload”, “new Accordian(‘basic-accordian’,5,’header_highlight’);”);