Create real time chart

saifullah khan

15y4.5k.NET

I have five cols in database, open,high,low,close,time. i want to create a real time candlestick chart that takes time from database and show it on x axis, and also shows the open high low and close values of that particular time. the chart also updates it self after every 2 seconds.how is it possible.

5 Replies

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

Praveen Kumar15y ago
Accepted answer
Table:

CREATE TABLE [dbo].[chart](
[id] [int] NOT NULL,
[open1] [int] NULL,
[high1] [int] NULL,
[low1] [int] NULL,
[close1] [int] NULL,
[time1] [date] NULL
) ON [PRIMARY]

ASPX Page:

Height="318px" Width="756px">

YValueMembers="high1" Label="High">

YValueMembers="low1" Label="Low">

YValueMembers="close1" Label="Close">

ConnectionString="<%$ ConnectionStrings:MCNConnectionString %>"
SelectCommand="SELECT * FROM [chart]">

.cs File

protected void Timer1_Tick(object sender, EventArgs e)
{
up1.Update();
}
Suthish Nair15y ago
If you are using Update Panels always wrap all the related controls inside Update Panel itself to avoid full post back..

For better idea, check this thread
saifullah khan15y ago
sir u are the great sir. great great great.
saifullah khan15y ago
sir web applications
Praveen Kumar15y ago
Windows or Web application?