By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,627 Members | 1,870 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,627 IT Pros & Developers. It's quick & easy.

1.Create chart 2.copy from microsoft office

P: 6
First, i wish to create line chart, pie chart and bar chart using vb.net of visual studio 2005.
Second question is i wish to copy a few data into datagridview from microsoft office tools such as access or excel using shortcut key 'ctrl+C' and 'ctrl+V'.
Any suggested code to do the 2 functions above without installing additional tools?
Apr 21 '10 #1
Share this Question
Share on Google+
5 Replies


Expert 100+
P: 210
Show us what you have done so far? Asking the question by stating I want to..... isnt the right way to ask.

My suggestion to you is use google to do some research and then implement what you have learned from your research and then when you run in to an error post your question.
Apr 21 '10 #2

P: 6
@semomaniz
actually my friends suggested me to refer this link:
http://www.codeproject.com/KB/GDI/2DAnimatedCharts.aspx
but i dont really understand what the included source code.

second question:
Expand|Select|Wrap|Line Numbers
  1. Dim cn1 As New OleDbConnection
  2.             Dim cm1 As New OleDbCommand
  3.             Dim da1 As New OleDbDataAdapter
  4.             Dim strConnectionString = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & link)
  5.             cn1 = New OleDb.OleDbConnection(strConnectionString)
  6.             cn1.Open()
  7.             cm1.CommandText = "Select * from data"
  8.             cm1.Connection = cn1
  9.             da1.SelectCommand = cm1
  10.             da1.Fill(ds, "data")
  11.             Me.DataGridView1.DataSource = ds.Tables("data")
  12.             cn.Close()
link is openfile dialog and when i select a database of ms access, it get error of 'unrecognize database'
Apr 21 '10 #3

Expert 100+
P: 210
you need to revise line 4. There is not datasource provided.
Apr 22 '10 #4

Expert 100+
P: 210
Also there are various ways of creating charts. Here is the link

http://lmgtfy.com/?q=charts+with+vb.net
Apr 22 '10 #5

Frinavale
Expert Mod 5K+
P: 9,731
What does the variable "link" contain on line 4?
Apr 30 '10 #6

Post your reply

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