MSChart

[shvonne]

i want to bind MSChart to a recordset fields call Quantity(Y axis) and Year(X axis).....

how should i specify the datasrc, datafield, dataMember and dataFormatAs?????

[Lothar Haensler]

I just created a table in SQLserver like this:
create table lahtest3( year int, quantity int)
go
insert into lahtest3 values( 1984, 5)
insert into lahtest3 values( 1985, 6)
insert into lahtest3 values( 1986, 4)

then I added a data environment to my vb 6 project
and added a command that is based on the following sql statement
select convert(varchar(10),year), quantity from lahtest3
It is important that the year is a character field! Otherwise the mschart control tries to be smart and interprets it in a way that creates crazy graphs.

Then I simply set Datasource to dataenvironment1 and Datamember to Command1.
And, without writing a single line of code I got a "nice" chart.

[shvonne]

hai lothar...

thanks for the solution.. but when i tried it out at visual interdev, it keeps telling me that putting either dataEnviroment1 or connection1 or command1 or recordset1 as datasource is 'invalid property value'... do u have any idea about it?

[Lothar Haensler]

Thanks for telling us, that you do that in an HTML page using interdev. Of course you cannot use the dataenvironment in an HTML page.

[shvonne]

but in interdev, u can add dataenvironment too as what u did in visual basic... adding a data connection and data command is the same way we can do in visual basic...

sorry for the confusion just now...

[Lothar Haensler]

>but in interdev, u can add dataenvironment too as what u did in visual basic

sure, that may work in server-side ASP processing, but I doubt that it will work in client-side HTMLpages.

[shvonne]

ic.. then do u have any other suggestion???

oh ya, about the ADO problem that i post past few days, do u have any further idea about my doubt?

thanks again

[Lothar Haensler]

1 suggestion: in your ASP (if you use one) you could create client-side JScript code for manipulating the ms chart properties.
may be there is an ActiveX Control that can be bound to an RDS object.
>oh ya, about the ADO problem that i post past few days, do u have any further idea about my doubt?
I don't remember.

[shvonne]

ic.. thanks...

can u please check again.. there is a question call "ADO in ASP" posted by anonymous at 22/8....

[Lothar Haensler]

>can u please check again.. there is a question call "ADO in ASP" posted by anonymous at 22/8....
I think, I've answered that one. You need to create an application in IIS. If Interdev doesn't do it for you, do it manually.
Or: don't use application vars if you use them only for connection strings. Use in include file instead. That's how I do it in my apps.

[shvonne]

ic.. thanks for all

[vinodbhagat]

I have a problem

How do i call a sub procedure using RDS .. i know using ADo to call a sub procedure from oracle .. i am stuck to call a sub procedure using RDS .. pls reply .. it is urgent ..U can reply mr directly to vinodb@akshay.co.in
or vinod_bhagat@yahoo.com

Positive answer expected and appritiated..
Vinod

Sorry .. I want to know that Can I use MSChart in VC ++;
if yes .. how ?