Kako proslediti SQL-upit Chartu (dijagramu)?

Imam konekciju sa bazom i SQL-upit koji prosledjujem dataGridu, koji ispisuje rezultate, i to funkcionise.
Taj isti upit treba da prosledim i dijagramu, da bi on iscrtao te iste rezultate, a ne znam kako to da uradim

Kakav dijagram?

Potpis

http://i.imgur.com/V3feW.jpg
http://on.wsj.com/H9yjz6 -- India Graduates Millions, but Too Few Are Fit to Hire

Pa instalirao sam Add-ons Chart u Visual Studio 2008. Izabrao sam spline dijagram. E sad treba da mu prosledim u DataSource SQL-upit. Kada prosledim dataGrid-u, to funkcionise

private void btnPronadji_Click(object sender, EventArgs e)
{

string sqlStr = "select n.mesec, n.minMesecniVod, n.srednjiMesecniVod, n.maxMesecniVod from nivovodostaja n";
sqlStr += " where n.godina = " + tbGodina.Text + " and n.idmesto = " + cbMesto.SelectedValue.ToString();
sqlStr += " and n.idreka = " + cbReka.SelectedValue.ToString();


dataGridView1.DataSource = dm.SqlSelect(sqlStr).Tables[0];
dataGridView1.Refresh();



Pokusavao sam nesto ovako: chart1.DataSource = dm.SqlSelect(sqlStr).Tables[0];
chart1.Refresh();

ali ne ide.

[email protected]

Reci mi ime tog Add-ona(ili daj screenshot)

I jedna preporuka.
nemoj da koristis SQL upite u kodu.
Procitaj ovo

Koristi SQL Parameters ili stored procedure.

Potpis

http://i.imgur.com/V3feW.jpg
http://on.wsj.com/H9yjz6 -- India Graduates Millions, but Too Few Are Fit to Hire

Microsoft Chart Controls Add-on for Microsoft Visual Studio 2008 Setup i
Microsoft Chart Controls for Microsoft .NET Framework 3.5 Setup

To sam instalirao

nemogu da instaliram Microsoft Chart Controls Add-on for Microsoft Visual Studio 2008 Setup
skinuo sam sa MS sajta 630 KB pokrenem instlaciju i kaze mi file corrupt

Potpis

http://i.imgur.com/V3feW.jpg
http://on.wsj.com/H9yjz6 -- India Graduates Millions, but Too Few Are Fit to Hire

Probaj ovo mozda ce ti uspeti
http://www.4guysfromrolla.com/articles/072209-1.aspx

Procitaj deo Binding Database Data to the Chart

Potpis

http://i.imgur.com/V3feW.jpg
http://on.wsj.com/H9yjz6 -- India Graduates Millions, but Too Few Are Fit to Hire