c# mysql

MySqlConnection ,  MySqlDataReader, MySqlCommand

how can w know what those function mean and what they do if i want to write some thing to mysql databate such as update I can put sql statement to  MySqlCommand or not
private void button1_Click(object sender, EventArgs e)
        {
            string MyConString = "SERVER=localhost;" +
                "DATABASE=registration;" +
                "UID=root;" +
                "PASSWORD='';";
            MySqlConnection connection = new MySqlConnection(MyConString);
            MySqlCommand command = connection.CreateCommand();
            MySqlDataReader Reader;
            command.CommandText = "select * from teera";
            connection.Open();
            Reader = command.ExecuteReader();
            while (Reader.Read())
            {
                string thisrow = "";
                for (int i = 0; i < Reader.FieldCount; i++)
                    thisrow += Reader.GetValue(i).ToString() + ",";
                listBox1.Items.Add(thisrow);
                System.IO.File.AppendAllText(@"C:\file.txt", "thisrow");

Open in new window

teeraAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
käµfm³d 👽Connect With a Mentor Commented:
>>  MySqlConnection ,  MySqlDataReader, MySqlCommand

Those are classes, not functions. You can follow-up with the documentation to see what they do and what is available with each:  http://dev.mysql.com/doc/refman/5.1/en/connector-net-ref-mysqlclient.html

In short, MySqlConnection represents a connection to a MySql database, MySqlCommand is a class that is used to pass queries to the database using a given MySqlConnection, and MySqlDataReader is a class used to read the results of a selection query processed by a given SqlCommand object.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.