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
241 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
Comment Utility
0
 

Author Comment

by:sydneyguy
Comment Utility
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
Comment Utility
its also for OLEDB and access not for mysql sorry
0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 26

Assisted Solution

by:Anurag Thakur
Anurag Thakur earned 250 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
thanks for the input from both of you have it up and running thanks for the help
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to use and create keystrokes in Netbeans IDE 8.0 for Windows.

763 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now