1.Create chart 2.copy from microsoft office

[lauclaw]

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?

[semomaniz]

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.

[lauclaw]

@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:

Dim cn1 As New OleDbConnection
            Dim cm1 As New OleDbCommand
            Dim da1 As New OleDbDataAdapter
            Dim strConnectionString = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & link)
            cn1 = New OleDb.OleDbConnection(strConnectionString)
            cn1.Open()
            cm1.CommandText = "Select * from data"
            cm1.Connection = cn1
            da1.SelectCommand = cm1
            da1.Fill(ds, "data")
            Me.DataGridView1.DataSource = ds.Tables("data")
            cn.Close()

link is openfile dialog and when i select a database of ms access, it get error of 'unrecognize database'

[semomaniz]

you need to revise line 4. There is not datasource provided.

[semomaniz]

Also there are various ways of creating charts. Here is the link

http://lmgtfy.com/?q=charts+with+vb.net

[Frinavale]

What does the variable "link" contain on line 4?