Basically for normal select queries from my database I have no problems as I would put the following and then bind it to a controller to display the iteam, however now I am trying to query sum of a field from the database, but I think it should be different as It's giving a Nullable value:
SELECT SUM(PointsRedeemed) AS tAward
WHERE (BusinessId = ?) AND (CardNo = ?)
Dim TransactionTableApt As New LoyaltyDataSetTableAdapters.TransactionTableAdapter TransactionTableApt.ScalartTotal(Login.lblHiddenBusId.Text, lblCardNo1.Text) lblPurValue.Text = LoyaltyDataSet.Card.Rows(0)("CustomerId")
Can anyone help by tellling what I am doing wrong?