473,326 Members | 2,133 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Need Chart Example Program

Hello Friends & My Brothers
I Need Chart Example Program In Vb Plz Send Me
- Jpezhil
Thanking U(For U'r Reply)
Sep 22 '06 #1
1 3392
add a MSChart control in ur application by
project->components->microsoft chart control
put a char in the form and
here i changed the name of chart control to cht and i use the able


With cht
.RowCount = 0
.ColumnCount = 0

If cmbName.ListIndex = -1 Then
sql = "Select Code,StockQty,(PrPrice * StockQty) As val from MstItem Where stockqty > 0 and void =0"
Else
sql = "Select Code,StockQty,(PrPrice * StockQty) As val from MstItem Where stockqty > 0 and void =0 and catcode='" & cmbName & "'"
End If

If RS.State Then RS.Close
RS.Open sql, CON, 1, 3
If RS.RecordCount < 1 Then
MsgBox "There is no item.", vbInformation, "Data not found"
If RS.State Then RS.Close
Exit Sub
End If

.RowCount = 1
.ColumnCount = RS.RecordCount
For I = 1 To RS.RecordCount
.Column = I
.ColumnLabel = RS("code")
.Data = RS("StockQty")
' RS.MoveNext
Next I
.AllowDynamicRotation = True
If RS.State Then RS.Close

End With
Sep 23 '06 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: David Goldsmith | last post by:
Is there software that will take C++ source and generate from it a flow chart? Thanks! DG
30
by: nephish | last post by:
Hey there, i have tried about every graphing package for python i can get to work on my system. gnuplot, pychart, biggles, gdchart, etc.. (cant get matplot to work) so far, they all are working...
9
by: Patrick.O.Ige | last post by:
I have a code below and its a PIE & BAR CHART. The values now are all static but I want to be able to pull the values from a database. Can you guys give me some ideas to do this? Thanks ...
2
by: Anil | last post by:
Hello, I am using VS2005 Beta2 and I have added a Simple Line-Graph chart to a ReportViewer control. I can click on the chart and alter for example the Minimum and Maximum scale values of the...
1
by: Robin Tucker | last post by:
Heres and interesting problem: I have a VB.NET program that creates reports via. Word Automation. This all works fine. What I want to do as part of this report generation process is to embed a...
7
by: vbnetdev | last post by:
My boss wants this done in a day. I would be happy with a week! Anyway, I have a dataset filled with data and need to populate an MS word chart with it when writing a report. Any tutorials or...
5
by: Kuna | last post by:
Hi All, I am trying to create a gantt chart in php by getting data from database. I am using WindowsXp OS and having php-4 and my-sql DB. I have installed the JPGRAPH package to my system and...
0
by: c0dergirl | last post by:
This c# program allows you to select multiple items from a listbox. For each selected item, a worksheet is created in the workbook with some information. Right now I create a chart that plots some...
3
by: Sandy911 | last post by:
I´ve never used charts in Access. Somehow I managed to format well shaped charts in Excel but I can´t find the way to understand how to create a report in Access that produces a bar or a pie chart...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.