C# SQLSERVER查询数据,返回单个值

static string sqlServer = "server=.;database=*****; uid=sa; pwd=*******";

        public static string refdange()
        {
            //实例化连接通道
            SqlConnection conn = new SqlConnection(sqlServer);
            //准备执行命令的字符串
            string sqlStr = "select Max(ID) from Msgcodedefaultsetting";
            //准备执行命令
            SqlCommand sqlcmd = new SqlCommand(sqlStr, conn);
            //打开通道
            conn.Open();
            //执行命令并返回单个值
            object objstr = sqlcmd.ExecuteScalar();
            //关闭通道
            conn.Close();
            return(objstr.ToString());
        }

C# sql查询数据库返回单个值方法