Solved

Looking for c# project that nicely demonstrates the accessing of a mysql data base and display datagrid with the information

Posted on 2011-09-23
7
243 Views
Last Modified: 2013-12-17
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
0
Comment
Question by:sydneyguy
  • 5
7 Comments
 
LVL 17

Accepted Solution

by:
sonawanekiran earned 250 total points
ID: 36585962
0
 

Author Comment

by:sydneyguy
ID: 36586033
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
 

Author Comment

by:sydneyguy
ID: 36586050
its also for OLEDB and access not for mysql sorry
0
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 
LVL 26

Assisted Solution

by:Anurag Thakur
Anurag Thakur earned 250 total points
ID: 36586400
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
 

Author Comment

by:sydneyguy
ID: 36588242
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
 

Author Comment

by:sydneyguy
ID: 36588530
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
 

Author Closing Comment

by:sydneyguy
ID: 36595781
thanks for the input from both of you have it up and running thanks for the help
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question