greenapple.Conner.scalar C# (CSharp) Метод

        public string scalar(string sqlstr)
        {
            string se = "";
            try
            {
                if (conn.State == ConnectionState.Open)
                { }
                else
                    conn.Open();

                comm = conn.CreateCommand();
                comm.CommandText = sqlstr;
                se = Convert.ToString(comm.ExecuteScalar());
                conn.Close();
            }
            catch(Exception ex)
            {
                MessageBox.Show(ex.Message + "\nSQL:" + sqlstr);
            }
            return se;
        }