dataset with wizard could not get column information

[zy_430l]

hi, im a newbie in using vb2008 and mysql server 5.1.

i tried creating a dataset using the myodbc driver 5.1 (which im sure is correctly typed in because that is the exact same connection string i used for data manipulation within my app.

now, im stuck. i cannot generate any reports because the dataset i created can not return any field information w/c is confusing because it displays the names of the tables from the database.

is there any way i can import all the data i need to my reports programatically??

any suggestions and ideas will be highly appreciated. thanks in advance. :)

[CodeWord]

if you are getting an empty dataset (with the field names from the database table), then it sounds like there are simply no records that satisfy the constraints of your query.

... and to answer your question, "YES", you can programmatically pull back data to fill your reports.

[zy_430l]

as i was about to pull my hair off i found this link.

http://www.vbmysql.com/articles/vbnet-mysql/myodbc-connector/creating-reports

what i needed to do was just to directly create table adapters from my not so functional datasets and then connect it to my mysql database. modified my connection string a bit and its AOK! thanks for looking into this sir.

[tomason]

I have just wrote an article on "code project", it's about exporting data from database. In it, I discuss how to choose columns from a data set. you can read it on:
http://www.codeproject.com/KB/cs/Excel_PDF_Word_ExportWiz.aspx
And I use a free component, you can visit here for more information:
http://www.e-iceblue.com/Introduce/free-dataexport-component.html