how to Browse MySQL data in C#

Question

1.00/5 (1 vote)

See more:

hey, i want to view/browse my datas form MYSQL using this buttons begin(>>), previous(<), next(>), last(>>) whenever i clicked the last button it will goes to the end of the Data in MYSQL for example. and when the next button is clicked then it will browse the next data.. thanks for answering. GODBLESS!! :))

my form

My Google+ forum[^]

Posted 24-Sep-13 21:54pm

black_diamond

Updated 25-Sep-13 1:58am

Dholakiya Ankit

v5

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Alexander Dymshyts · Answer 1 · 2013-09-24T22:32:00

Solution 1

Here is an example. Next time try to use google before asking questions, which have a lot of answers in the internet.

Posted 24-Sep-13 22:32pm

Alexander Dymshyts

Comments

Rick van Woudenberg 25-Sep-13 4:45am

I complete agree.

Rick van Woudenberg · Answer 2 · 2013-09-24T22:43:00

Hey Black Diamond,

This is actually pretty straight forward SQL programming. There are several ways to go about it and I think the reason why you don't have much anwsers yet, is because yoú don't have a specific question about one topic or control, but rather you ask people to write the entire program for you. I'd suggest you read this article first :

Connect C# to MySQL[^]

It will explain the basics of MySQL database querying and also has a few great methods for you to use which will come in very handy. In a nutshell :

* If the amount of data that you'd like to search is not a whole lot, just select everything from the database an chuck it into a datatable. That way you spare valuable socket time from your resources.
* assign an event to each button and set the action accordingly. For example, if you press the forward button then an integer value will be increased by one, which is use in de datatable.Select method or looping through the datatable rows, using the foreach iteration. The double forward button could have a selection statement attached to it, such as

DataRow row = datatable.Rows[datatable.Rows.Count - 1];

This will return the last row in the table and can be used to fill in the form.

If keeping connections open is not a problem, you could of course query directly to the database. Again, you'd need a reference point to construct your SQL queries to ensure a proper result back.

I hope this short anwser to an extensive question will get you going. Cheers !