Comments by bigyan sahoo (Top 70 by date)

I want to know why we need timestamp value and how can I use timestamp value. Now I am sending current second from server date. SO it is showing same date and time for both qatar and Dubai.

Response I got for Both
<timezoneresponse>
<status>OK
<raw_offset>14400.0000000
<dst_offset>0.0000000
<time_zone_id>Asia/Dubai
<time_zone_name>Gulf Standard Time



<timezoneresponse>
<status>OK
<raw_offset>14400.0000000
<dst_offset>0.0000000
<time_zone_id>Asia/Qatar
<time_zone_name>Gulf Standard Time

I need how to fire drop down change event in jquery. When I select any drop down then I need that value.

Asp with html controls.

try
{
connection.Open();

using (SqlCommand command = new SqlCommand("DownloadEmployee", connection))
{
command.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(command);
DataTable dt = new DataTable();
da.Fill(dt);

//result = new JavaScriptSerializer().Serialize(dt);
result = JsonConvert.SerializeObject(dt);
//result = ser.Serialize(srtData);

}

}
catch (Exception ex)
{

}
finally
{
connection.Close();

}
return result;
}


My Service Part. It return Json Data in correct format.

$.ajax({
type: "POST",
url: "/CommonWebService.asmx/downloadExcel",
contentType: "application/json; charset=utf-8",
dataType: "json",
data: {},
contentType: 'application/json; charset=utf-8',

success: function (data) {
//alert(data);
var dt1 = JSON.parse(JSON.stringify(data))
alert(dt1);

},
error: function () {
////alert(data.d);
alert("xyz..");


}


My Ajax method...


{"d":"[{ \"Vehicle\": \"BMW\", \"Date\": \"30, Jul 2013 09:24 AM\", \"Location\": \"Hauz Khas, Enclave, New Delhi, Delhi, India\", \"Speed\": 42 },
{ \"Vehicle\": \"Honda CBR\", \"Date\": \"30, Jul 2013 12:00 AM\", \"Location\": \"Military Road, West Bengal 734013, India\", \"Speed\": 0 },
{ \"Vehicle\": \"Honda Accord\", \"Date\": \"30, Jul 2013 11:05 AM\", \"Location\": \"DLF Phase IV, Super Mart 1, Gurgaon, Haryana, India\", \"Speed\": 71 }]"}