------=_NextPart_001_0003_01C1E70C.1A937620
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi !
 
I need to display data from selected number of lines from a large csv fil
e into MSChart control using ADO data control. At the moment I have the C
ommandType property ADODC set as cmdTable and the RecordSource property o
f ADODC set as the csv file name. Also I am using the following string as
 connection string 
 
Provider=3DMSDASQL.1;Persist Security Info=3DFalse;Mode=3DRead;Extended P
roperties=3D"DBQ=3DC:\FlowComp\Trends;DefaultDir=3DC:\FlowComp\Trends;Dri
ver=3D{Microsoft Text Driver (*.txt; *.csv)};DriverId=3D27;Extensions=3DN
one,asc,csv,tab,txt;FIL=3Dtext;FILEDSN=3DC:\FlowComp\Trends\Trends.dsn;Ma
xBufferSize=3D2048;MaxScanRows=3D50;PageTimeout=3D5;SafeTransactions=3D0;
Threads=3D3;UID=3Dadmin;UserCommitSync=3DYes;";Initial Catalog=3DC:\FlowC
omp\Trends
 
This displays all the data from the csv file on the chart. I want to be a
ble to scroll through the data from the csv file 50 rows at a time. Can a
nybody help ?
 
Cheers !
 
YashGet more from the Web.  FREE MSN Explorer download : http://explorer.
msn.com