Do you have Windows 7 64Bit and you are trying to install SQL Server 2008 Management Tools and cannot?

{Programming} & Life has the long answer at this link

Here is the short answer from the same site.

FIX – INSTALL BACKWARDS!

So that’s the logic, install everything backwards:

First the SQLManagementStudio_x64_ENU.exe to install your tools, and then SQLEXPR_x64_ENU.exe to install your database services. Or perhaps if you are happy with an all in one package, go for this guy – Microsoft® SQL Server® 2008 Express with Tools it’ll probably save you a lifetime of headaches. Don’t try to be tricky like me and get separate installs.

Here are two variations of looping through rows in Oracle PL/SQL.  The FOR structure reduces the amount of code, in either case is it more perference than anything else.

---------------------------------- 
--Cursor - For Loop
----------------------------------    
for i in (select constraint_name, table_name
          from all_constraints
          where constraint_type = 'R'
          and owner = lv_owner
          and status = 'ENABLED')  
  LOOP
  execute immediate 'alter table ' || i.table_name ||
                    ' disable constraint ' || i.constraint_name || '';
end loop;

----------------------------------
--Cursor - For each record
----------------------------------     
declare cursor csr is    
          select constraint_name, table_name
                    from all_constraints
                    where constraint_type = 'R'
                    and owner = lv_owner
                    and status = 'ENABLED';
                    
 begin
   for rcd in csr
    loop          
     execute immediate 'alter table ' || rcd.table_name ||
                       ' disable constraint ' || rcd.constraint_name || '';
    
    end loop;
  end;

This example will load a list box of documents from a network share. It will then allow the user to select the file to print from the browser.

1. Create a class that contains the name of the file and full path and file name. This will later be used to add to a generic list.

2. Create a method that will read all the sub-directories and file names to load to a list box.

3. When the user selects an item from the list render open the document (example a PDF) in from the browser.

For an example of how to render an object (PDF, Word, ZIP...) to the browser for opening see this post.

Code snippet attached.

Get_Network_Files.cs (2.69 kb)