Exemplos de SqlDBBroker.ExecuteScalar em C# (CSharp)

Exemplo n.º 1

        public string GetChildMaxOrder(string oid)
        {
            string strSQL = @" SELECT COUNT(1)+1 FROM TBLFUNCTION WHERE functionparentid=@OID ";

            string[] paramNames  = new string[1];
            object[] paramValues = new object[1];

            paramNames[0]  = "OID";
            paramValues[0] = oid;
            SqlDBBroker broker = new SqlDBBroker();

            broker.Open();
            return(broker.ExecuteScalar(strSQL, CommandType.Text, paramNames, paramValues));
        }