Link to home
Start Free TrialLog in
Avatar of sydneyguy
sydneyguyFlag for Australia

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
ASKER CERTIFIED SOLUTION
Avatar of Kiran Sonawane
Kiran Sonawane
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sydneyguy

ASKER

thanks already had the one, but thanks for the help so far i was looking for a ziped up project ready to run if possible as i want to just plug it in and go instead of building and fidgiting around with it
its also for OLEDB and access not for mysql sorry
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
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.
thanks for the input from both of you have it up and running thanks for the help