[  DataObjectMethod ( DataObjectMethodType.Select ) ]
public static DataTable GetEmployee ( int EmployeeID ) {
   if ( !_initialized ) { Initialize ( ); }

   SqlConnection conn = new SqlConnection ( _connectionString );
   SqlDataAdapter da = new SqlDataAdapter ( 
      "SELECT EmployeeID, LastName, FirstName, Address, City, Region, PostalCode FROM Employees " +
      "WHERE EmployeeID = @EmployeeID", conn ); 
   da.SelectCommand.Parameters.Add ( "@EmployeeID", SqlDbType.Int ).Value = EmployeeID;

   DataSet ds = new DataSet ( ); 

   try {
      conn.Open ( );
      da.Fill ( ds, "Employees" );
   }
   catch ( SqlException e ) {
      // Handle exception.
   }
   finally {
      conn.Close ( );
   }

   if ( ds.Tables [ "Employees" ]  != null )
      return ds.Tables [ "Employees" ] ;

   return null;
}

<DataObjectMethod ( DataObjectMethodType.Select ) > _
Public Shared Function GetEmployee ( EmployeeID As Integer ) As DataTable

  If Not _initialized Then Initialize ( )

  Dim conn As SqlConnection  = New SqlConnection ( _connectionString )
  Dim da  As SqlDataAdapter  = _
    New SqlDataAdapter ( "SELECT EmployeeID, LastName, FirstName, Address, City, Region, PostalCode FROM Employees WHERE EmployeeID = @EmployeeID", conn ) 
  da.SelectCommand.Parameters.Add ( "@EmployeeID", SqlDbType.Int ).Value = EmployeeID

  Dim ds As DataSet =  New DataSet ( ) 

  Try   
    conn.Open ( )
    da.Fill ( ds, "Employees" )
  Catch e As SqlException
    ’ Handle exception.
  Finally
    conn.Close ( )
  End Try

  If ds.Tables ( "Employees" ) IsNot Nothing Then _
    Return ds.Tables ( "Employees" )

  Return Nothing
End Function