C#

private bool isConnected(){    
bool rVal = false;    
//an alternate way to refresh the connected status of the sock.    
try    
{        
bool blcking = sock.Blocking;        
try        
{            
byte[] junk = new byte[2];            
sock.Blocking = false;            
sock.Send(junk, 1, 0, SocketFlags.None);                                     
rVal = sock.Connected;        
}        
finally        
{            
sock.Blocking = blcking;           
}    
}    
catch (SocketException e)    
{        
rVal = e.SocketErrorCode == SocketError.WouldBlock;    
}    
return rVal;
}

private void Form2_Load(object sender, System.EventArgs e)
{
      try
      {			
	   myCon.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp\sample_as400.mdb";
 	   myCon.Open();
	   string sqlQuery = "Select * from table_as400";
           myAdp = new OleDbDataAdapter(sqlQuery, myCon);

	   OleDbCommandBuilder myBldr = new OleDbCommandBuilder(myAdp);
	   myAdp.Fill(myTable);					
      }
      catch (OleDbException exceptionObject)
      {
	   MessageBox.Show(exceptionObject.Message, "PIN_PROJECT");
      }
}

		
private void btnReport_Click(object sender, System.EventArgs e)
{
	// Create a CrystalReport1 object
	CLIENT_REPORT myReport = new  CLIENT_REPORT();

	// Set the DataSource of the report
	myReport.SetDataSource(myAdp);

	// Set the Report Source to ReportView 
	crystalReportViewer1.ReportSource = myReport;
}