I'm using amCharts (http://www.amcharts.com
amCharts (and other flash charting controls) require csv or xml files to read in data (why can't they access sql directly?). I was originally going to use shell bcp from the code behind page, but that would require an install on many users' computers. My question is...
What is the fastest way to do this?
1) vb.net code to query sql server, then run a loop to create the csv file
2) sql stored procedure using bcp/xp_cmdshell
3) some other way?
Any examples I can look at?