Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
Private Function chargelimitreached() As Boolean 'matt added function Dim MySQL As String = "select SUM(damount) from tblHistory where dtdate between DATEADD(DAY,-14,getdate()) and GETDATE() and lDeviceNumber in (6,7) and dIDNumber = " & campusglobals.campusID Dim limitreached As Boolean = False Dim dr As OleDbDataReader = MainDataAccess.getDatareader(MySQL, "iAmecsAdvanced") MsgBox(dr(0).ToString) If (dr.HasRows) Then If (Not IsDBNull(dr(0))) Then If dr(0) > 100 Then limitreached = True End If End If End If dr.Close() Return limitreached End Function
|change colour of repeater control in asp.net c#||7||30|
|Explain Unit of Work pattern||2||27|
|VB.Net application which runs on one machine crashes on another although OS is excalty the same||6||19|
|ASP.net markup problem with table alignment||2||11|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
23 Experts available now in Live!