C# and MySql connection!!

Question

Hello pple? Am a newbie in C sharp but got lot of interest in C#. How to do create a mysql database connection class? Again if I want to call this class say in a form how do i do that? Thank you!!

Tanmay Sarkar · Answer

Try this MySqlConnection connection = new MySqlConnection( SERVER=127.0.0.1:9000 ;DATABASE=Mydatabase;UID=root;PASSWORD=mypassword;pooling=false); MySqlCommand command = connection.CreateCommand(); MySqlDataReader Reader; command.CommandText = select * from mytabel; connection.Open(); Reader = command.ExecuteReader(); while (Reader.Read()) { string thisrow = ; for (int i = 0; i thisrow += Reader.GetValue(i).ToString() + listBox1.Items.Add(thisrow); } connection.Close(); You can use localhost as server then the string will be SERVER=localhost; Thank you! Please mark it as an answer if it help you.

Sam Hobbs · Answer

Install the MySQL Connector/Net if you have not yet done that. Then read the articles that others have already written and look at the relevant samples. Learn about TableAdapters bound forms and other conveniences that Visual Studio provides. Note that you probably need to right-click in the VS toolbox to add the MySQL tools to it. I wrote an article about creation of a database update form without writing any code or at least very little code. You can use it to get started.

Tanmay Sarkar · Answer

I hope you build the class and it's connection ok But your problem is when you write insert query it create an exception. Am I right??? If not then please again put your problem here. If i am write when it is your form inserting is well completed but when it is in your class it get an exception When you are righting a class in the insertion method First connect the db  Second insert your data and finally dispose connection. Try it may be it help you if i get your right problem :) Thank you! Please mark it as an answer if it help you!

Amos Ndungu · Answer

Tanmaythanx aheap! Know supposing i wuld like to create this connection as a class and call it in my forms how do i go about this? for instance i create it as a dBConnect() class and wish to call it in a form called frmUser in the Save buttonhope u get me. Thanx!