likejeewesh
Member
- Joined
- May 2, 2014
- Messages
- 9
- Programming Experience
- 5-10
my code for getting output but no way
debugger junmping directly to catch area i also try this query in access 2007 its giving output help me out
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: