세상 품기

public partial class Form2 : Form

    {

        public const int SW_SHOWNOACTIVATE = 4;

        [System.Runtime.InteropServices.DllImport("user32.dll")]
        public static extern bool ShowWindow(IntPtr hWnd, int nCmdShow);

        public Form2()

        {
            InitializeComponent();
        }

        public void MyShow()
        {
            ShowWindow(this.Handle, SW_SHOWNOACTIVATE);
        }

    } 

원격디비 연결을 하기 위한 몇가지 방법
1. Openrowset

Syntax
 
OPENROWSET
( { 'provider_name' , { 'datasource' ; 'user_id' ; 'password'
   | 'provider_string' }
   , {   [ catalog. ] [ schema. ] object
       | 'query'
     }
   | BULK 'data_file' ,
       { FORMATFILE = 'format_file_path' [ <bulk_options> ]
       | SINGLE_BLOB | SINGLE_CLOB | SINGLE_NCLOB }
} )

<bulk_options> ::=
   [ , CODEPAGE = { 'ACP' | 'OEM' | 'RAW' | 'code_page' } ]
   [ , ERRORFILE = 'file_name' ]
   [ , FIRSTROW = first_row ]
   [ , LASTROW = last_row ]
   [ , MAXERRORS = maximum_errors ]
   [ , ROWS_PER_BATCH = rows_per_batch ]
   [ , ORDER ( { column [ ASC | DESC ] } [ ,...n ] ) [ UNIQUE ]

>> SQL Server Native Client OLE DB Provider
      SELECT a.*
      FROM OPENROWSET('SQLNCLI',
                                      'Server=Seattle1;
                                      Trusted_Connection=yes;',
                                      'SELECT GroupName, Name, DepartmentID
                                       FROM AdventureWorks2008R2.HumanResources.Department
                                       ORDER BY GroupName, Name') AS a;
 
>> Microsoft OLE DB Provider For Jet
    SELECT CustomerID, CompanyName
    FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
                   'C:\Program Files\Microsoft Office\OFFICE11\SAMPLES\Northwind.mdb';
                   'admin';'',Customers);

>> Inner Join

USE Northwind  ;
GO
SELECT c.*, o.*
FROM Northwind.dbo.Customers AS c
   INNER JOIN OPENROWSET('Microsoft.Jet.OLEDB.4.0',
   'C:\Program Files\Microsoft Office\OFFICE11\SAMPLES\Northwind.mdb';'admin';'', Orders)   
   AS o
   ON c.CustomerID = o.CustomerID ;
GO

>> Bulk insert file data into a varbinary(max) column
USE AdventureWorks2008R2;
GO
CREATE TABLE myTable(FileName nvarchar(60),
  FileType nvarchar(60), Document varbinary(max));
GO

INSERT INTO myTable(FileName, FileType, Document)
   SELECT 'Text1.txt' AS FileName, '.txt' AS FileType, *
   FROM OPENROWSET(BULK N'C:\Text1.txt', SINGLE_BLOB) AS Document;
GO

>> From a txt file

USE AdventureWorks2008R2;
GO
CREATE TABLE myTable(FileName nvarchar(60),
  FileType nvarchar(60), Document varbinary(max));
GO

INSERT INTO myTable(FileName, FileType, Document)
   SELECT 'Text1.txt' AS FileName,
      '.txt' AS FileType,
      * FROM OPENROWSET(BULK N'C:\Text1.txt', SINGLE_BLOB) AS Document;
GO

이런 식으로 해주면 된다~
아래와 같이 미리 설정이 되어있어야한다..