c# mysql print some ting on screen

Using the MySqlConnector, which I assume you have since you say you can connect, you would simple create a connection object and a command object and execute your query:

using (MySqlConnection con = new MySqlConnection("your_connection_string"))
{
    using (MySqlCommand cmd = new MySqlCommand("select count(*)  from a where colum a like 1", con))
    {
        int count = (int)cmd.ExecuteScalar();

        textBox1.Text = count.ToString();
    }
}

Select allOpen in new window

Hi kaufmed

if i want to print in console application how can i do it

Thank

In a console app, based on my earlier code:

Console.WriteLine(totalAsText);

Chris Bray

Instead of

textBox1.Text = count.ToString();

Select allOpen in new window

you would use:

Console.WriteLine(count.ToString());

Select allOpen in new window

and instead of

MessageBox.Show(ex.ToString());

Select allOpen in new window

you would use:

Console.WriteLine(ex.ToString());

Select allOpen in new window