Hi,

I am a beginner in asp.net.

I want to make line graph in my webpage getting data from sql database.

My database has two column that i have to use one is average and other is time. I have to keep time in x axis and average in y axis. Time is saving in db like that ( 2021-05-20 3:15pm) first i have to split this column in date and time separately and then use that time on my x axis of graph.

Secondly the graph working is like that when 24 hours’ time is complete it shows next date once. Like we should get for which date this data is displaying on graph. 

I am very thankful if someone can help me by completing my task.