class MSQL
    {
        public string login;
        public string password;
        private string aut;
        public void conection()
        {
            string CommandText = "select name from new_table where name='" + login +"AND password='"+ password + "'";
            string Connect = "Database=new_schema;Data Source=localhost;User Id=root;Password=root";
            MySqlConnection myConnect = new MySqlConnection(Connect);
            myConnect.Open();
            MySqlCommand myCommnd = new MySqlCommand(CommandText, myConnect);
               string aut = myCommnd.ExecuteScalar().ToString();
            myConnect.Close();
            if (aut != "")
            {
                MessageBox.Show("ok");
            }
            else
            {
                MessageBox.Show("error");
            }
        }

    }

class MSQL
{
    public string login;
    public string password;
    private string aut;
    public void conection()
    {
        string CommandText = "SELECT name FROM new_table WHERE name='" + login +"'AND password='"+ password + "'";
        string Connect = "server=localhost;username=root;database=new_schema;password=root";
        MySqlConnection myConnect = new MySqlConnection(Connect);
        myConnect.Open();
        MySqlCommand myCommnd = new MySqlCommand(CommandText, myConnect);
       try
{
        string aut = myCommnd.ExecuteScalar().ToString();
        MessageBow.Show(aut);
        myConnect.Close();
}
        catch (Exception ex)
         {
          MessageBox.Show("Ошибка у нас такая:    " + ex.Message);
         }