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
sydneyguyAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
sydneyguyAuthor Commented:
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
0
 
sydneyguyAuthor Commented:
its also for OLEDB and access not for mysql sorry
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Anurag ThakurConnect With a Mentor Technical ManagerCommented:
http://www.codeproject.com/KB/database/MySQLCsharp.aspx
one more sample from code project but this uses data grid which has been replaced by grid view
0
 
sydneyguyAuthor Commented:
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
0
 
sydneyguyAuthor Commented:
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.
0
 
sydneyguyAuthor Commented:
thanks for the input from both of you have it up and running thanks for the help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.