sydneyguy
asked on
Looking for c# project that nicely demonstrates the accessing of a mysql data base and display datagrid with the information
Hi experts i am looking for a nice zipped up file that i can load up for best practice to access a mysql DB and using odbc and display the data in a nice data grid to show me the best way to do it please
it would be going into visual studios 2005
it would be going into visual studios 2005
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
its also for OLEDB and access not for mysql sorry
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
yea already had a play with that i have actually built one from scratch but run into a
Could not retrieve schema information for table or view
something to do with an extra " .. " in the sql line because something does not talk between visual studios and the odbc driver mysql odbc 3.51 and mysql odbc 5.1
do you know any thing about this problem
Could not retrieve schema information for table or view
something to do with an extra " .. " in the sql line because something does not talk between visual studios and the odbc driver mysql odbc 3.51 and mysql odbc 5.1
do you know any thing about this problem
ASKER
here is the solution, and bingo it works like a dream
Here's how I solved this problem.
- Add a new datasource like normal and select the tables you want.
- When you get the message box telling you "One or more error(s) occured while processing the database object(s)..." click ok.
- In the 'Data Sources' window, right-click your data set and select "Edit Dataset with Designer". You should see a box for each table containing an entry at the bottom with the text "Fill,GetData()"
- Right-click on "Fill,GetData()" and select "Configure..."
- In the large edit box it should say "SELECT * FROM `<database>`..`<table>`" Its those double periods that are the problem. Delete one of them so it says "SELECT * FROM `<database>`.`<table>`"
- Press the "Finish" button
- You should now see all the columns of your table.
- Repeat for the rest of your tables.
You should now be able to use your dataset as you please.
Here's how I solved this problem.
- Add a new datasource like normal and select the tables you want.
- When you get the message box telling you "One or more error(s) occured while processing the database object(s)..." click ok.
- In the 'Data Sources' window, right-click your data set and select "Edit Dataset with Designer". You should see a box for each table containing an entry at the bottom with the text "Fill,GetData()"
- Right-click on "Fill,GetData()" and select "Configure..."
- In the large edit box it should say "SELECT * FROM `<database>`..`<table>`" Its those double periods that are the problem. Delete one of them so it says "SELECT * FROM `<database>`.`<table>`"
- Press the "Finish" button
- You should now see all the columns of your table.
- Repeat for the rest of your tables.
You should now be able to use your dataset as you please.
ASKER
thanks for the input from both of you have it up and running thanks for the help
ASKER