How to Link the data to Dashboard box

wangyonggang · Post by **wangyonggang** » Wed Oct 18, 2023 5:02 pm

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>

MichaelG · Post by **MichaelG** » Thu Oct 19, 2023 6:25 am

Use the ExecuteScalar function to get value from SQL.

wangyonggang · Post by **wangyonggang** » Thu Oct 19, 2023 11:05 am

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

MichaelG · Post by **MichaelG** » Fri Oct 20, 2023 6:34 am

It is simply

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

wangyonggang · Post by **wangyonggang** » Fri Oct 20, 2023 5:31 pm

IT WORKS.Thank You Very Much!

@ExecuteScalar("SQL")