Article Category

분류 전체보기 (157)
공지사항 (1)
Open Source (38)
DataBase (5)
Web (11)
멀티미디어 (1)
MS (24)
Util (4)
기타 (0)
취미 (23)

Notice

Recent Article

Recent Comment

Recent Trackback

DataSet을 이용한 Data 추가 예제

| MS/C# 2009. 1. 24. 19:13
Posted by Lㅓ부ㄹI

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
/*
 
DataBase
 
Address Table
 
id number,
 
name varchar 20
 
addr varchar 40
 
*/
 
  
 
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.OracleClient;;;
 
 
namespace Tran_01
{
    public class OleDbParamTest
    {
        public static void Main()
        {
            OracleConnection conn = new OracleConnection();
            try
            {
                conn.ConnectionString =
                              "Data Source=XE;" +
                              "User id=;" +
                              "Password=;";
                conn.Open();
                Console.WriteLine(conn.State);
                Console.WriteLine(conn.ServerVersion);
                Console.WriteLine(conn.Site);
                Console.WriteLine("nn");
                OracleDataAdapter Oadt = new OracleDataAdapter("select * from Address", conn);
                DataSet ds = new DataSet("MyAddress");
                Oadt.Fill(ds, "Address");
                conn.Close();
                DataTable table = ds.Tables[0];
                Console.WriteLine("Row Count : " + table.Columns.Count);
                Print(table);
                DataRow row = table.NewRow();
                row["id"] = "8";
                row["name"] = "Uncle";
                row["addr"] = "Ameria";
                table.Rows.Add(row);
 
                conn.Open();
                OracleCommand Ocmd = new OracleCommand();
                string strSql = "Insert into address(id,name,addr) values(:pid,:pname,:paddr)";
                Oadt.InsertCommand = new OracleCommand(strSql, conn);
                Oadt.InsertCommand.Parameters.Add("pid", OracleType.Number, 0, "id");
                Oadt.InsertCommand.Parameters.Add("pname", OracleType.VarChar, 20, "name");
                Oadt.InsertCommand.Parameters.Add("paddr", OracleType.VarChar, 40, "addr");
 
                Oadt.Update(ds, "Address");
                conn.Close();
                Console.WriteLine("Insert that ..");
                Print(table);
            }
            catch (OracleException ErrMssg)
            {
                Console.WriteLine(ErrMssg.Message);
                Console.WriteLine("에러 확인");
            }
            finally
            {
                conn.Close();
            }
        }
        public static void Print(DataTable table)
        {
            DataRowCollection rows = table.Rows;
            foreach (DataRow dr in rows)
            {
                for (int i = 0; i < table.Columns.Count; i++)
                    Console.Write(dr[i] + "t");
                Console.WriteLine();
            }
        }
    }
}
And
prev | 1 | ··· | 154 | 155 | 156 | 157 | next

티스토리툴바