Could on I get some advice on how to properly write / retrieve, in VB.NET / ASP.NET Page, from SQL.
It's not so much the 'writing' part for SQL that I am worried about. I'm having some trouble retrieving data properly.
I have a routine that runs each time the page is loaded, or an insert is performed (2 button, virtually the same process), post back occurs.
When the page loads
getTheSavedData - could be empty (recordSet)
display 1 Record (recordSet) - that is based upon the getTheSavedData or lack there of
My difficulty is that, my second recordSet isnt getting the parameters expressed from the first recordset. The saved information has an impact on the 2nd recordset / query.
It can more or less be summarized in this Procedure. (excuse the clutter, I've been working with a few things, trying to display it on screen for myself)Private Sub a1TrialData()
Dim a1IDCBDsaved As Integer = 0
Dim a1IDPBDsaved As Integer = 0
Dim a1IDCBDremaining As Integer
Dim a1IDPBDremaining As Integer
Dim SQLCount As String = "SELECT * FROM MER_ASS_QA WHERE U_ID = " & _
Merit3.passVariables.AUIDp & " AND A_Priority = " & _
Merit3.passVariables.aPriorityP & "AND TRIAL_NUM = " & _
View Complete Post