How to get Convert Json datetime value in asp.net c#

Question

Dear All, I have a issue in connecting sql table value into signalr json query. I am loading two value from table - descr(nvarchar) and uploadDate(DateTime). I want to display date value in "dd/MM/yyyy format. Please help me on this. The value from descr is loading perfectly by using below query:- "text/javascript" > function getData() { var $tbl = $( '#NotificationUL' ); //tbl var $Count = $( '#NotificationCount' ); $.ajax({ url: 'wfrmUserPanel.aspx/GetData' , contentType: "application/json; charset=utf-8" , dataType: "json" , type: "POST" , success: function (data) { debugger ; if (data.d.length > 0) { var newdata = data.d; // Count = data.rows.Count; $tbl.empty(); //$tbl.append(' Description '); var rows = []; for ( var i = 0; i rows.push( ' ' + newdata[i].Description + ' Date: ' + newdata[i].UploadDate + ' ' ); } $tbl.append(rows.join( '' )); } } }); } And the c# code I wrote to trigger this function is given below:- [WebMethod] public static IEnumerable GetData() { SqlDataReader reader = null ; try { using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings[ "DataBase" ].ConnectionString)) { connection.Open(); //using (SqlCommand command = new SqlCommand(@"SELECT [Description] FROM [dbo].[tblActionDetaills]", connection)) //{ using (SqlCommand command = new SqlCommand( "SELECT Description,UploadDate FROM tblActionDetaills WHERE IsRead=0 AND VID='" + 1 + "' Order By UploadDate DESC" , connection)) { // Make sure the command object does not already have // a notification object associated with it. command.Notification = null ; SqlDependency.Start(ConfigurationManager.ConnectionStrings[ "DataBase" ].ConnectionString); SqlDependency dependency = new SqlDependency(command); dependency.OnChange += new OnChangeEventHandler(dependency_OnChange); if (connection.State == ConnectionState.Closed) connection.Open(); using (reader = command.ExecuteReader()) return reader.Cast () .Select(x => new Products() { Description = x.GetString(0), UploadDate = x.GetDateTime(1) }).ToList(); } } } I have attached a file where you can see how the value displaying in the web page. Please find that file.

Bineeshcp Viswanath · Answer

Dear All, I myself solved the issue. Here is what I did:- Changed sqlCommand :- SELECT Description,cast(Convert(varchar(20),UploadDate,103) as nvarchar(20)) as dd FROM tblActionDetaills WHERE IsRead=0 AND VID='" + 1 + "' Order By UploadDate DESC and changed the data type datetime into string in class :- public DateTime UploadDate { get; set; } into --> public string dd { get; set; }

Bineeshcp Viswanath · Answer

SQL Command :- SqlCommand command = new SqlCommand("SELECT Description,UploadDate FROM tblActionDetaills WHERE IsRead=0 AND VID='" + 1 + "' Order By UploadDate DESC", connection) Output :- Description UploadDate New Normal Action 2019-04-17 12:57:08.000 I added Javascript as attachment. it is screenshot of javascript query.

Madan Shekar · Answer

please drop ur query here

Bineeshcp Viswanath · Answer

Dear Madan, The query not working in my code. When I used this, the query output became blank.

Madan Shekar · Answer

better solution do it in query level only example select CONVERT (varchar(10), getdate(), 103) AS [converted_date_as_you_wanted] If it helps mark as answer.