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: 
			
		
	
								
								
									
	
		
			
		
		
	
	
	
		
			
		
		
	
								
							
							 
	 
 
		 
 
		 
 
		 
 
		