How to make a connection with excel sheet. when data is coming too fast.

Question

0.00/5 (No votes)

See more:

How to make connection with excel sheet while data is coming very speedily(a cell change value 1-3 times in a second)?

I am making a application for trading system, where data is coming via source in excel sheet. I have to show this data into grid. But when I make connection, it break due to rapid data. How can I make a connection continuously.

Posted 25-Apr-11 22:46pm

vishalGtm

Updated 25-Apr-11 22:55pm

Sandeep Mewara

v2

Add a Solution

Comments

Sandeep Mewara 26-Apr-11 4:56am

Not clear on what you mean by "it breaks due to rapid data"? how do you know?

In general, connections are generally not closed until specifically done. How can you say it's connection based?

vishalGtm 4-May-11 2:40am

dear sandeep plz follow this link
http://my.hamp.in/Mobile/Records.aspx

you see there some changing in gridview
same changes happening in excel sheet when i make connection with timer of interval 1000 than connection break after some time
how can i continue connection without break.
or have other idea to read and display every change data in gridview.

Imran S Mohamed 27-Apr-11 22:45pm

This is just a suggetion, but could you not just add a label or editbox from the forms windows and then update that through the built-in vb editor by reading a file which you then update from the outside? Again just a work-around.

vishalGtm 4-May-11 2:40am

dear imran
plz follow this link
http://my.hamp.in/Mobile/Records.aspx

you see there some changing in gridview
same changes happening in excel sheet when i make connection with timer of interval 1000 than connection break after some time
how can i continue connection without break.
or have other idea to read and display every change data in gridview.

Maciej Los 13-Jun-11 13:18pm

Trading system based on excel file? Excel file is not database, a specially when tousends of data are adding and updating many times in a second. I think, you should replace excel file with database file (MS SQL Server, etc.).

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)