Advertisement
Advertisement
| 05.27.2008 at 01:49PM PDT, ID: 23436319 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: |
Partial Class reports
Inherits System.Web.UI.Page
Protected Sub btnReport_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnReport.Click
txtAA.Text = getAccepting("A")
txtAB.Text = getAccepting("B")
txtAC.Text = getAccepting("C")
txtAD.Text = getAccepting("D")
txtAE.Text = getAccepting("E")
txtAF.Text = getAccepting("F")
txtAG.Text = getAccepting("G")
txtAH.Text = getAccepting("H")
txtAI.Text = getAccepting("I")
End Sub
Public Function getAccepting(ByVal abc)
Dim MyConn
Dim RS
Dim strConn
Dim sql
strConn = "Data Source=DRDBSQLDEV1\DRISQLDEV1; Initial Catalog=DRDEIF1T; Integrated Security=True"
MyConn = CreateObject("ADODB.Connection")
MyConn.ConnectionString = strConn
MyConn.Open()
sql = "Select Count(BIT_Accepting" & abc & ") as A FROM TB_EIF_Main WHERE DTE_InterView between '" & txtBegDate.Text & "' and '" & txtEndDate.Text & "' and BIT_Accepting" & abc & " = 'True'"
RS = MyConn.Execute(sql)
getAccepting = RS("A").Value
RS.close()
MyConn.close()
End Function
End Class
|