Question coding output problem

likejeewesh

Member
Joined
May 2, 2014
Messages
9
Programming Experience
5-10
my code for getting output but no way
  Try
                Call connection()
                Dim nodaldata As New DataSet
                duties.globalvariable.cmd = New OleDbCommand("SELECT NodalAppoint.session,nodalappoint.zonecode,nodalappoint.distcode,nodalappoint.centrecode,Institutes_Master.Institute_code,Institutes_Master.Institute_Name FROM nodalappoint INNER JOIN institutes_master ON NodalAppoint.centrecode=Institutes_Master.Institute_code  WHERE nodalappoint.session = '" & Trim(xsession) & "'and nodalappoint.zonecode='" & xzone & "' and nodalappoint.distcode='" & xdist & "'", duties.globalvariable.cn)
                Dim adt As New OleDbDataAdapter(duties.globalvariable.cmd)
                adt.Fill(nodaldata, "nodalappoint")
                Dim i As Integer
                For i = 0 To nodaldata.Tables(0).Rows.Count - 1
                    nodalcentre.Items.Add(Trim(nodaldata.Tables(0).Rows(i).Item(4).ToString()) + ", " + Trim(nodaldata.Tables(0).Rows(i).Item(5).ToString()))
                Next
                nodaldata.Dispose()
                adt.Dispose()
                nodalcentre.Focus()
            Catch ex As Exception
                MsgBox(" No results ")
            End Try


debugger junmping directly to catch area i also try this query in access 2007 its giving output help me out
 
Last edited by a moderator:
Look at the exception to see what the problem was. In the Catch block you have access to the Exception object and you can get lots of information from it, including type, Message and StackTrace.
 
problem solved code is ok prob is reserve keyword that why query not giving any result and ex exception does not showing in msg keyword session is doing problem so we use it as [session]
 
Back
Top