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
248 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.

732 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