Question Cheking Inventory Balance before allowing Issue order

[Jmekubo]

Hi Guys,

I need help on vb.net code to check the inventory value for an item in SQL Inventory table,

if it is >0, then

one is allowed to proceed to create issue order
else

warning message that item is out of stock.

Your input will be appreciated.

 

[jmcilhinney]

Query the table to get the count value for that row, calling ExecuteScalar to return a single value. If that value is zero then there's no stock, otherwise there is. Look here for some examples of using ADO.NET, including calling ExecuteScalar:

Retrieving and Saving Data in Databases