www.hkvforums.com

How Can I Link or Set the DATA that from database SQL into box?
For example, I want to replace the below '150' number by a result of SQL view/query in SQL server DB.
More or less, looks like VB code function 'DLOOKUP('[filed]','viewoftable','WHERE condition')'.

<div class="small-box bg-info">
  <div class="inner">
    <h3>150</h3>
    <p>New Orders</p>
  </div>
  <div class="icon">
    <i class="fas fa-shopping-cart"></i>
  </div>
  <a href="#" class="small-box-footer">
    More info <i class="fas fa-arrow-circle-right"></i>
  </a>
</div>

Use the ExecuteScalar function to get value from SQL.

Thanks for your reply.
Could you show me a DEMO or Sample codes?
Thanks a lot.

It is simply

ExecuteScalar("SELECT Field FROM Table WHERE ...")

IT WORKS.Thank You Very Much!

@ExecuteScalar("SQL")