Eli Posted February 24, 2008 Report Share Posted February 24, 2008 Hello all Could anybody explain to me how i create a chart making a database connection wih asp Thanks Quote Link to comment Share on other sites More sharing options...
maximop Posted February 25, 2008 Report Share Posted February 25, 2008 Once you create and open the connection, you need to set the chart's DataType so ChartFX and properly populate the data, and then pass your result set to the chart. You can do something like the following: ' Database code Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open Application("CfxIEConn") Set RS = Conn.Execute("SELECT ClosingDate,Sales,Projected From CIEDemoSales") ' Specify how SQL fields are used Chart.DataType(0) = CDT_XVALUE Chart.DataType(1) = CDT_VALUE Chart.DataType(2) = CDT_VALUE Chart.AdoResultset RS For more information, please refer to the samples provided on our support website for ChartFX Internet 5.5: http://support.softwarefx.com/SupportDocTree.aspx?Prod=CfxIE&Type=P Quote Link to comment Share on other sites More sharing options...
yadelisa Posted February 25, 2008 Report Share Posted February 25, 2008 Thank you Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.