Dim sqlDATE As String = " Select DVLPER.MANUFACTURERESULTS.WORKWARD" & _ " From (Select Max(DVLPER.MANUFACTURERESULTS.RESULTINPUTNO) As MAX1" & _ " From(DVLPER.MANUFACTURERESULTS)" & _ " Where DVLPER.MANUFACTURERESULTS.JOBNO = '404001039232') DB1 Inner Join" & _ " DVLPER.MANUFACTURERESULTS On DB1.MAX1 =" & _ " DVLPER.MANUFACTURERESULTS.RESULTINPUTNO" Dim loc1 As DataTable = OracleDbLib.OracleDbBase.BuildDataTable(sqlDATE) GridView2.DataSource = loc1 GridView2.DataBind()
Me.lblLoc.Text = loc1.Rows[0][0].toString();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)