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: