도도의 초록누리

Sub UploadFromExcelToSQL()

Dim adoCN As ADODB.Connection
Dim sConnString As String
Dim sSQL As String
Dim lRow As Long, lCol As Long

sConnString = "Provider=sqloledb;Server=servername;Database=NORTHWIND;User Id=xx;Password=password"

Set adoCN = CreateObject("ADODB.Connection")

'adoCN.Open sConnString

'Assumes that you have Field1, Field2 and Field3 in columns A, B and C
'For this example we can assume that the data exists on Sheet1, with a header on row
'1 and data in rows 2-11
'Also assume that the fields are defined as character (e.g. varchar or char)
'Text values must be enclosed in apostrophes whereas numeric values should not.


For lRow = 2 To 11

    sSQL = "INSERT INTO YOUR_TABLE (FIELD1, FIELD2, FIELD3) " & _
            " VALUES (" & _
            "'" & Sheet1.Cells(lRow, 1) & "', " & _
            "'" & Sheet1.Cells(lRow, 2) & "', " & _
            "'" & Sheet1.Cells(lRow, 3) & "')"
       
    adoCN.Execute sSQL
   
       
Next lRow

adoCN.Close

Set adoCN = Nothing
 
End Sub

cd c:\

bcdboot c:\windows /s c: /l ko-kr

(BCDboot)

bootsect /nt60 c:

(Bootsect)

private void Form2_Load(object sender, EventArgs e)
{
            int i;

            /// 배치 장소
            c_area.Items.Add("본사");
            c_area.Items.Add("영업지사");
            c_area.Items.Add("개발");

            /// 배치 부서
            c_department.Items.Add("사무실");
            c_department.Items.Add("생산");
            c_department.Items.Add("설계");
            c_department.Items.Add("출하");
            c_department.Items.Add("회의실");
            c_department.Items.Add("사장실");

            /// 자산 구분
            c_asset.Items.Add("소유");
            c_asset.Items.Add("임대");

            /// 자산 형태
            c_type.Items.Add("데스크탑");
            c_type.Items.Add("노트북");
            c_type.Items.Add("넷북");
            c_type.Items.Add("타블렛노트");
           
            // 전산장비 정보 가져오기

            // 1. CPU 정보 가져오기
            ManagementObjectSearcher MS2 = new ManagementObjectSearcher("Select * from Win32_Processor");
            foreach (ManagementObject MO in MS2.Get())
            {
                c_CPU.Text = MO["Name"].ToString();
            }
            // 2. RAM 정보 가져오기
            ulong a = new Microsoft.VisualBasic.Devices.ComputerInfo().TotalPhysicalMemory / 1024 / 1024;
            string b = a.ToString() + "MB";
            c_RAM.Text = b;
            // 3. M/B 정보 가져오기
            MS2 = new ManagementObjectSearcher("Select * from Win32_BaseBoard");
            foreach (ManagementObject MO in MS2.Get())
            {
                c_MB.Text = MO["Product"].ToString();
            }
            // 4. VGA 정보 가져오기
            MS2 = new ManagementObjectSearcher("Select * from Win32_DisplayConfiguration");
            foreach (ManagementObject MO in MS2.Get())
            {
                c_VGA.Text = MO["Description"].ToString();
            }
            // 5. HDD 정보 가져오기

            List<HardDrive> hdCollection = new List<HardDrive>();
            ManagementObjectSearcher searcher = new ManagementObjectSearcher("SELECT * FROM Win32_DiskDrive");

            foreach (ManagementObject wmi_HD in searcher.Get())
            { 
               HardDrive hd = new HardDrive();
               hd.Model = wmi_HD["Model"].ToString();
               hd.Type = wmi_HD["InterfaceType"].ToString();
               hdCollection.Add(hd);
            }
            searcher = new ManagementObjectSearcher("SELECT * FROM Win32_PhysicalMedia");
            int ii = 0;
            foreach (ManagementObject wmi_HD in searcher.Get())
            {
                if (ii >= hdCollection.Count)
                {
                    break;
                }
           
                HardDrive hd = (HardDrive)hdCollection[ii];
                // get the hardware serial no.

                if (wmi_HD["SerialNumber"] == null)
                    hd.SerialNo = "None";
                else
                    hd.SerialNo = wmi_HD["SerialNumber"].ToString().Trim();

                ++ii;
            }

            c_HDD_1.Text = hdCollection[0].Model.ToString();
            c_HDD_Type_1.Text = hdCollection[0].Type.ToString();
            if (hdCollection.Count < 1)
            {
                c_HDD_2.Text = hdCollection[1].Model.ToString();
                c_HDD_Type_2.Text = hdCollection[1].Type.ToString();
            }
        }

// 하드 정보담는 공간
        public class HardDrive
        {
            private string model = null;
            private string type = null;
            private string serialNo = null;
            public string Model
            {
                get { return model; }
                set { model = value; }
            }
            public string Type
            {
                get { return type; }
                set { type = value; }
            }
            public string SerialNo
            {
                get { return serialNo; }
                set { serialNo = value; }
            }
        }