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

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:-

);

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.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bineeshcp Viswanath7y ago
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 Viswanath7y ago
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 Shekar7y ago
please drop ur query here
Bineeshcp Viswanath7y ago
Dear Madan,

The query not working in my code. When I used this, the query output became blank.
Madan Shekar7y ago
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.