asked on
dsGetFieldPoints.SelectParameters["trackID"].DefaultValue = trkID;
var fieldPts = dsGetFieldPoints.Select(DataSourceSelectArguments.Empty) as DataView;
var fieldPtMarkers = new List<FieldPoint>();
foreach (DataRowView pt in fieldPts)
{
FieldPoint fp = new FieldPoint();
fp.locDate = (string)pt["locDate"];
fieldPtMarkers.Add(fp);
}
JavaScriptSerializer js = new JavaScriptSerializer();
var fieldPtsJson = js.Serialize(fieldPtMarkers);
var fieldPtsJsonFinal = "{\"fieldPoints\": " + fieldPtsJson + "}";
ClientScript.RegisterStartupScript(this.GetType(), "Google Maps Initialization and Add Pts",
string.Format("initializeMap({0}, {1});", photosJson, fieldPtsJsonFinal), true);
var fDate = new Date(fMarker.locDate);
fDate.toDateString()
I get this Mon 6/14/1914. So I'm using a With clause in my t-sql statement and I try this....With fieldPts AS
(SELECT
CAST(ISNULL(fp1.Loc_Date, '') AS DATE) AS locDate....)
SELECT
CAST(fp.locDate AS NVARCHAR) AS locDate....
In the JSON output the date looks like this "2014-06-15", but when I use the javascript it looks like this Sat 6/14/2014. So I try not converting it back to nvarchar....With fieldPts AS
(SELECT
CAST(ISNULL(fp1.Loc_Date, '') AS DATE) AS locDate....)
SELECT
fp.locDate....
fp.locDate = (DateTime)pt["locDate"];
the JSON output looks like this "\/Date(1402808400000)\/" and the javascript produces undefined Invalid Date.convert(date, CAST(ISNULL(fp1.Loc_Date, '') AS DATE), 112) AS locDate
but it doesn't seem to work since I always get the same format of 2014-06-15. What can I do now? Thanks
ASKER
With fieldPts AS
(SELECT
convert(char(10),fp1.Loc_Date,101) AS locDate,....)
SELECT
fp.locDate....
Asp.netfp.locDate = (string)pt["locDate"];
the date in the JSON output is "6/15/14 " but when I use the javascript...var fDate = new Date(fMarker.locDate);
fDate.toDateString()
I get this Mon Jun 15 1914. convert(char(10),fp1.Loc_Date,102) AS locDate,
it should give me 2014.06.15 but when I run the stored procedure I still get 6/15/14.
ASKER
ASKER
convert(varchar,cast(fp1.Loc_Date as date),101) AS locDate
And it worked. Thanks sammy!
The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications
TRUSTED BY
Open in new window
See if this is any help to you.