VS_chapter10
|
|
|
- 미소 안
- 6 years ago
- Views:
Transcription
1 Part. Chapter 10 ActiveX Data Objects.NET(ADO.NET).NET, ADO.NET..NET ADO(ActiveX Data Objects). ADO. ADO,. ADO,.NET ADO.NET... ADO.NET ADO Connection DataReader Command DataAdapter DataSet DataView DataSet 330
2 .NET (FCL) System.Data ( )..NET ADO. ADO,. ADO.NET., ADO ADO.NET. ADO ADO.NET. 10 Chapter...,,. ADO.NET. System.Data.SqlClient : SQL Server 7.0 SQL Server System.Data.OleDb : SQL Server (OLE DB). OLE DB, Microsoft Access, Excel, dbase. System.Data.Odbc : ODBC, 331
3 ODBC ODBC (DSN). ODBC. System.Data.OracleClient :. SqlClient OleDb.,,,. (System.Data.SqlClient System.Data.OleDb)., System.Data.SqlClient Connection System.Data.SqlClient.SqlConnection, OleDb System.Data.OleDb.OleDbConnection.. (SQL Server OleDb ). ADO 10.1 ADO ADO.NET. 332
4 , ADO.NET ADO.,.,. Connection,, Open. Command ADO. (Select), (Insert), (Update), (Delete) SQL Command. ADO.NET Command Parameters,. DataReader. ADO ForwardOnly., DataReader. 10 Chapter DataAdapter ADO.NET, ADO. DataAdapter, DataSet. DataAdapter. DataAdapter InsertCommand, UpdateCommand, SelectCommand, DeleteCommand. DataAdapter. DataSet ADO. DataSet,. DataSet, extensible markeup language(xml), XML. DataSet DataAdapter, DataAdapter Connection Command, DataSet. 333
5 . ADO.NET... (,,, ),. ADO. ADO.NET DataAdapter DataSet. (,, ).,,... DataSet. (rule), (constraint), (relationship). XML ADO.NET. XML. XML ADO.NET. ADO. NET XML. ADO.NET XML 334
6 ,. XML.NET,. Visual Studio.NET FCL., [ 10.2] ADO.NET DataReader, DataAdapter, DataSet 10 Chapter 335
7 [ 10.2]. Visual Basic 6 ASP.,..NET.., ( ).. DataSet DataAdapter. DataReader 11.,. ADO.NET Connection. SQL Server SqlConnection (System.Data.SqlClient ) Connection, OLE DB OleDbConnection (System.Data.OleDb ) Connection.,,, (connection string)., SQL Server.. 336
8 OleDbConnection Microsoft Access.NET SDK (MSDE) SQL Server ID SQL Server ' System.Data.OleDb.OleDbConnection ' Dim stroledb As String = _ "Provider=Microsoft.Jet.OLEDB.4.0; " _ & "Data Source=..\Northwind.mdb" Dim cnoledb As New OleDbConnection() cnoledb.connectionstring = stroledb cnoledb.open() 10 Chapter ' System.Data.SqlClient.SqlConnection ' MSDE SDK Dim strmsde As String = _ "Server=(local)\NetSDK;DataBase=Northwind; " _ & "Integrated Security=SSPI" Dim cnmsde As New SqlConnection() cnmsde.connectionstring = strmsde cnmsde.open() ' System.Data.SqlClient.SqlConnection ' SQL Server Dim strsql As String = _ "Server=localhost;DataBase=Northwind;" & _ "Integrated Security=SSPI" Dim cnsql As New SqlConnection() cnsql.connectionstring = strsql cnsql.open() ' ID ' System.Data.SqlClient.SqlConnection ' SQL Server Dim strsql1 As String = _ 337
9 "Server=localhost;DataBase=Northwind;" & _ "uid=sa;pwd=password" Dim cnsql1 As New SqlConnection() cnsql1.connectionstring = strsql1 cnsql1.open() // System.Data.OleDb.OleDbConnection // string stroledb; stroledb Source=..\Northwind.mdb" OleDbConnection cnoledb = new OleDbConnection(); cnoledb.connectionstring = stroledb; cnoledb.open(); // System.Data.SqlClient.SqlConnection // MSDE SDK string strmsde; strmsde Security=SSPI" SqlConnection cnmsde = new SqlConnection(); cnmsde.connectionstring = strmsde; cnmsde.open(); // System.Data.SqlClient.SqlConnection // SQL Server string strsql; strsql Security=SSPI" SqlConnection cnsql = new SqlConnection(); cnsql.connectionstring = strsql; cnsql.open(); // ID // System.Data.SqlClient.SqlConnection // SQL Server string strsql1; strsql1 = 338
10 @"Server=localhost;DataBase=Northwind;uid=sa;pwd="; SqlConnection cnsql1 = new SqlConnection(); cnsql1.connectionstring = strsql1; cnsql1.open();, OleDbConnection SqlConnection., SQL Server ( localhost),, ID. OleDbConnection, OLE DB, OLE DB. OLE DB. Access. Oracle SQL Server 6.5, SQL Server 7.0 SQL Server Chapter [ 10.1] SqlConnection OleDbConnection. 339
11 SqlConnection OleDbConnection ( ) (overload), Connection., Visual Basic.NET (, ). Dim cn as New SqlConnection("Server=localhost;DataBase=Northwind;" _ & "uid=sa;pwd=password"),. 340
12 Command SQL, SQL SQL (stored procedure). SqlCommand Command SQL Server, OleDbComand Command OLE DB. Command. Connection CreateCommand SqlCommand OleDbCommand (Command ) Connection Command SQL Command. [ 10.2] SqlCommand OleDbCommand Command. 10 Chapter 341
13 Command SQL Command Text, [ 10.3] SQL. Command,. ExecuteReader, DataReader.. DataReader. SqlDataReader OleDbDataReader.,. [ 10.1]., Command, DataReader. 342
14 Dim cn As New SqlConnection( _ "Server=(local)\NetSDK;DataBase=pubs;" _ & "Integrated Security=SSPI") ' SqlDataReader. Dim dr As SqlDataReader ' SqlCommand Dim cmd As New SqlCommand ' CommandText SQL Select, ' Connection SqlConnection ( ) cn. With cmd.commandtext = "Select au_lname, au_fname from Authors".Connection = cn End With 10 Chapter ' Connection. cn.open() ' Command ExecuteReader. dr = cmd.executereader(commandbehavior.closeconnection) Dim strname As String ' DataReader Read. While dr.read ' ListBox1. strname = dr("au_lname") & ", " & dr("au_fname") ListBox1.Items.Add(strName) End While ' Connection. cn.close() SqlConnection cn = new SqlConnection (@"Server=(local)\NetSDK;DataBase=pubs;Integrated 343
15 Security=SSPI"); // SqlDataReader. SqlDataReader dr; // SqlCommand SqlCommand cmd = new SqlCommand(); // CommandText SQL Select, // Connection SqlConnection ( ) cn. cmd.commandtext = "Select au_lname, au_fname from Authors"; cmd.connection = cn; // Connection. cn.open(); // Command ExecuteReader. dr = cmd.executereader(commandbehavior.closeconnection); string strname; // DataReader Read. while (dr.read()) { // listbox1. strname = dr.getstring(0) + ", " + dr.getstring(1); listbox1.items.add(strname); } // Connection. cn.close(); ExecuteReader, DataReader Read.,. While. Read False, While. DataReader 344
16 .. Visual Basic.NET. Do Until dr.read = False '. Loop [ 10.1] Visual Basic.NET C#, DataReader Read. Visual Basic.NET, C# GetString., 0, 1.,. [ 10.4] SqlDataReader. 10 Chapter 345
17 SQL Server OLE DB.. Visual Studio.NET DataReader. (DataReader ). C#, GetString. Visual Basic.NET string., System.Convert.. Insert, Update, Delete SQL ExecuteNonQuery. [ 10.2]. Sub DoNonQuery() Dim cn As New SqlConnection( _ "Server=(local)\NetSDK;DataBase=pubs;" _ & "Integrated Security=SSPI") Dim cmd As New SqlCommand With cmd.commandtext = "Delete from Authors where au_lname = 'Smith ".Connection = cn.commandtype = CommandType.Text End With Try cn.open() cmd.executenonquery() Catch ex As Exception MessageBox.Show(ex.Message) Finally 346
18 If cn.state = ConnectionState.Open Then cn.close() End If End Try End Sub private void DoNonQuery() { SqlConnection cn = new SqlConnection (@"Server=(local)\NetSDK;DataBase=pubs;Integrated Security=SSPI"); SqlCommand cmd = new SqlCommand(); cmd.commandtext = "Delete from Authors where au_lname = 'Smith " cmd.connection = cn; cmd.commandtype = CommandType.Text ; 10 Chapter } try { cn.open(); cmd.executenonquery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (cn.state == ConnectionState.Open) { cn.close(); } } [ 10.2] [ 10.1]. Connection Command, SQL., SQL. Insert, Update, Delete SQL,, 347
19 . ExecuteNonQuery. ExecuteReader. Connection State, connection close. Try ~ Catch, connection., connection close Finally close. Connection, Command, DataReader.., C# Visual Basic.NET. DataAccess_vb(Visual Basic.NET) DataAccess_cs(C#). DataAccess. Form1 ([ 10.3] ). 1. TabControl.. Dock : Fill TabPages: TabPage. TabPage. Text ( TabPage ). TabPage1 Text: Readers and Adapters TabPage2 Text: DataGrid Binding TabPage3 Text: Simple Data Entry TabPage. 2. Form1 TabPage1 Button.. 348
20 Button1: Text: Using a DataReader Name: UseDataReader Button2: Text: Using a DataSet Name: UseDataSet Button3: Text: Show Checked Items Name: ShowCheckedItems Button4: Text: DataBind with DataSet Name: DataBindWithDataSet 3. ListBox TabPage1. 4. CheckedListBox TabPage1. 5. ComboBox TabPage1. 10 Chapter 6. 3 Label TabPage1. [ 10.3]. (TabPage2, TabPage3).,,. [ 10.3] [ 10.1].,. 349
21 ,. TabPage1, UseDataReader_Click. [ 10.3] ( )., Form1 Imports using.. Visual Basic.NET,. Imports System.Data.SqlClient Imports System.Text C#,. using System.Data.SqlClient; using System.Text; Private Sub UseDataReader_Click(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles UseDataReader.Click ListBox1.Items.Clear() Dim cn As New SqlConnection( _ "Server=(local)\NetSDK;DataBase=pubs;" _ & "Integrated Security=SSPI") ' SqlDataReader. Dim dr As SqlDataReader ' SqlCommand. Dim cmd As New SqlCommand() ' CommandText SQL Select, ' Connection SqlConnection. With cmd.commandtext = "Select au_lname, au_fname from Authors".Connection = cn End With 350
22 ' Connection open. cn.open() ' Command ExecuteReader. dr = cmd.executereader(commandbehavior.closeconnection) Dim strname As String ' DataReader Read ListBox1. While dr.read strname = dr("au_lname") & ", " & dr("au_fname") ListBox1.Items.Add(strName) End While End Sub private void UseDataReader_Click(object sender, System.EventArgs e) { 10 Chapter listbox1.items.clear(); SqlConnection cn = newsqlconnection(@"server=(local)\netsdk;database=pubs; Integrated Security=SSPI"); // SqlDataReader. SqlDataReader dr; // SqlCommand. SqlCommand cmd = new SqlCommand(); // CommandText SQL Select, // Connection SqlConnection. cmd.commandtext = "Select au_lname, au_fname from Authors"; cmd.connection = cn; // Connection open. cn.open(); // Command ExecuteReader. 351
23 dr = cmd.executereader(commandbehavior.closeconnection); string strname; // DataReader Read ListBox1. while (dr.read()) { strname = dr.getstring(0) + ", " + dr.getstring(1); listbox1.items.add(strname); } } ListBox1 SelectedIndexChanged. Button Click, ListBox, ListBox1, SelectedIndexChanged. [ 10.4] ( ). Private Sub ListBox1_SelectedIndexChanged _ (ByVal sender As System.Object, _ ByVal e As System.EventArgs) _ Handles ListBox1.SelectedIndexChanged ' ListBox1 Label1. Label1.Text = "ListBox1_SelectedIndexChanged" ' ListBox1 Label2. Label2.Text = ListBox1.Items(ListBox1.SelectedIndex) ' ListBox1 Label3. Label3.Text = ListBox1.SelectedIndex End Sub private void listbox1_selectedindexchanged(object sender, 352
24 System.EventArgs e) { // listbox1 Label1. label1.text = "ListBox1_SelectedIndexChanged"; // listbox1 Label2. label2.text = listbox1.text; } // listbox1 Label3. label3.text =listbox1.selectedindex.tostring(); [ 10.4] ListBox, ListBox.. 10 Chapter,. F5. Form1,. ListBox. ListBox Label. [ 10.4]. 353
25 DataReader.,,. DataReader, DataSet. DataSet. [ 10.2] DataSet. DataSet. DataTable. DataSet DataAdapter., DataSet DataAdapter. DataAdapter, Fill Update. Command SQL (Select ) Fill DataSet DataTable. DataAdapter Command,. Command SQL. SQL Server SqlDataAdapter, OleDb OleDbDataAdapter.. SqlDataAdapter, Command, DataSet Authors. cn Connection. ' SqlDataAdapter. Dim da As SqlDataAdapter = New SqlDataAdapter() ' Connection Command. Dim cmd As New SqlCommand("Select * from Authors", cn) 354
26 ' SelectCommand Command. da.selectcommand = cmd ' SqlDataAdapter DataSet. Dim ds As DataSet = New DataSet() ' Command DataSet Fill method. da.fill(ds, "Authors") // SqlDataAdapter. SqlDataAdapter da = new SqlDataAdapter(); // Connection Command. SqlCommand cmd = new SqlCommand("Select * from Authors", cn); // SelectCommand Command. da.selectcommand = cmd; 10 Chapter // SqlDataAdapter DataSet. DataSet ds = new DataSet(); // Command DataSet Fill method. da.fill(ds, "Authors"); DataAdapter Fill., Command SQL (Select ) (row) DataSet. connection open open open. close. 11, DataAdapter Update DataSet Insert, Update, Delete. DataAdapter, InsertCommand, UpdateCommand, DeleteCommand. SQL,., (batch). 355
27 DataAdapter, DataAdapter SQL. Visual Basic.NET, SqlDataAdapter SQL (Select) Connection. Dim da As SqlDataAdapter = New SqlDataAdapter("Select * from Customers", cn ) DataSet DataAdapter. DataAccess.. DataAdapter, SQL Server CheckedListBox1. Form1 [ 10.5] UseDataSet_Click ( ). Private Sub UseDataSet_Click(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles UseDataSet.Click ' CheckedListBox. CheckedListBox1.Items.Clear() 356
28 ' Connection. Dim cn As New SqlConnection( _ "Server=(local)\NetSDK;DataBase=pubs;" _ & "Integrated Security=SSPI") ' SqlDataAdapter. ' SQL Connection. Dim da As SqlDataAdapter = New SqlDataAdapter _ ("SELECT au_id, au_lname + ', ' + au_fname As FullName FROM Authors", cn) ' DataSet. Dim ds As DataSet = New DataSet("Authors") da.fill(ds, "Authors") ' DataRow. Dim dr As DataRow 10 Chapter ' DataSet ' CheckedListBox. For Each dr In ds.tables("authors").rows CheckedListBox1.Items.Add(dr("FullName")) Next End Sub private void UseDataSet_Click(object sender, System.EventArgs e) { // checkedlistbox. checkedlistbox1.items.clear(); // Connection. SqlConnection cn = new SqlConnection(@"Server=(local)\NetSDK;DataBase=pubs; Integrated Security=SSPI"); // SqlDataAdapter. // SQL Connection. SqlDataAdapter da = new SqlDataAdapter("SELECT au_id, au_lname + ', ' + au_fname 357
29 As FullName FROM Authors", cn); // DataSet SqlDataAdapter. DataSet ds = new DataSet("Authors"); da.fill(ds, "Authors"); } // DataSet // CheckedListBox. foreach (DataRow dr in ds.tables["authors"].rows) { checkedlistbox1.items.add(dr["fullname"]); } CheckedListBox1 SelectedIndexChanged. ListBox1_SelectedIndexChanged,. CheckedListBox GetItemChecked., Form1 CheckedListBox1, SelectedIndex Changed [ 10.6] ( ). Private Sub CheckedListBox1_SelectedIndexChanged _ (ByVal sender As System.Object, _ ByVal e As System.EventArgs) _ HandlesCheckedListBox1.SelectedIndexChanged ' CheckedListBox1 Label1. Label1.Text = "CheckedListBox1_SelectedIndexChanged" ' CheckedListBox1 Label2. Label2.Text = CheckedListBox1.Items(CheckedListBox1.SelectedIndex) ' CheckedListBox1. Label3.Text = "Checked = " & CheckedListBox1.GetItemChecked _ (CheckedListBox1.SelectedIndex) 358
30 End Sub private void checkedlistbox1_selectedindexchanged(object sender, System.EventArgs e) { // checkedlistbox1 Label1. label1.text = "CheckedListBox1_SelectedIndexChanged"; // checkedlistbox1 Label2. label2.text = checkedlistbox1.text; // checkedlistbox1. label3.text = "Checked = " + checkedlistbox1.getitemchecked(checkedlistbox1.selectedindex); } 10 Chapter F5 [ 10.5]. [ 10.5] UseDataSet_Click SqlDataAdapter. SQL Select Connection. DataSet, SqlDataAdapter Fill ( ). Fill DataTable, 359
31 Authors. DataTable, ( ) DataSet. DataSet DataTable., DataSet, DataTable. DataSet DataTable,. (For ~ Each ) DataTable DataRow (DataRow ). DataRow. [ 10.5] FullName CheckedListBox., DataSet. DataSet DataTable. DataTable SQL, 16,777,216 (row) ( ). DataRow DataTable, DataTable. DataSet DataTable DataRow. [ 10.6]. 360
32 DataSet.. Visual Basic 6. Visual Studio.NET. Visual Basic Chapter,.,, XML,.,.,,.,.. (DisplayMember ValueMember ) 11 Visual Studio.NET Visual Studio.NET. ADO.NET ComboBox DataGrid DataSet. 361
33 , (simple) (complex). DataSet, DataSource DataSet.., List Grid. TextBox. DataBindings (Control ), Add DataSet. ' Connection. Dim cn As New SqlConnection( _ "Server=(local)\NetSDK;DataBase=northwind;" _ & "Integrated Security=SSPI") ' SqlDataAdapter. ' SQL Connection. Dim da As SqlDataAdapter = New SqlDataAdapter _ ("SELECT * from Customers", cn) ' DataSet. Dim ds As DataSet = New DataSet("Customers") ' DataSet Fill. da.fill(ds, "Customers") ' TextBox DataBinding. TextBox2.DataBindings.Add("Text", ds.tables("customers"), "CompanyName") TextBox3.DataBindings.Add("Text", ds.tables("customers"), "Address") TextBox4.DataBindings.Add("Text", ds.tables("customers"), "City") 362
34 // Connection. SqlConnection cn = new SqlConnection(@"Server=(local)\NetSDK;DataBase=northwind;Integrate d Security=SSPI"); // SqlDataAdapter. // SQL Connection. SqlDataAdapter adp = new SqlDataAdapter("SELECT * from Customers", cn); // DataSet. DataSet ds = new DataSet("Customers"); // DataSet Fill. adp.fill(ds, "Customers"); 10 Chapter // TextBox DataBinding. textbox2.databindings.add("text", ds.tables["customers"], "CompanyName"); textbox3.databindings.add("text", ds.tables["customers"], "Address"); textbox4.databindings.add("text", ds.tables["customers"], "City"); DataAccess, ComboBox DataGrid. ComboBox DisplayMember ValueMember. DisplayMember ComboBox (DataSet ), ValueMember ( primary ). Authors primary au_id, ValueMember au_id.,. Form1, BindWithDataSet_Click [ 10.7] ( ). 363
35 Private Sub BindWithDataSet_Click(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles BindWithDataSet.Click Dimcn As New SqlConnection( _ "Server=(local)\NetSDK;DataBase=pubs;" _ & "Integrated Security=SSPI") Dimda As SqlDataAdapter = New SqlDataAdapter _ ("SELECT au_id, au_lname + ', ' + au_fname As FullName FROM Authors", cn) Dimds As DataSet = New DataSet("Authors") da.fill(ds, "Authors") With ComboBox1 ' ComboBox DataSource ' DataSet Authors DataTable..DataSource = ds.tables("authors") ' ComboBox DisplayMember DataSet FullName..DisplayMember = "FullName" ' ComboBox ValueMember au_id (DataTable primary )..ValueMember = "au_id" End With End Sub private void BindWithDataSet_Click(object sender, System.EventArgs e) { combobox1.items.clear(); SqlConnection cn = 364
36 new Security=SSPI"); SqlDataAdapter da = new SqlDataAdapter("SELECT au_id, au_lname + ', ' + au_fname As FullName FROM Authors", cn); DataSet ds = new DataSet("Authors"); da.fill(ds, "Authors"); // combobox DataSource // DataSet Authors DataTable. combobox1.datasource = ds.tables["authors"]; // combobox DisplayMember DataSet FullName. combobox1.displaymember = "FullName"; 10 Chapter } // combobox ValueMember au_id (DataTable primary ). combobox1.valuemember = "au_id"; [ 10.5] [ 10.6] ListBox, ListBox Label. DataSet. [ 10.7] (ComboBox).,. ComboBox? [ 10.8]. ComboBox1 SelectedIndexChanged Label. ComboBox1 ( ). Visual Basic.NET C#., ComboBox. 365
37 Private Sub ComboBox1_SelectedIndexChanged( _ ByVal sender As Object, _ ByVal e As System.EventArgs) _ Handles ComboBox1.SelectedIndexChanged ' ComboBox1 Label1. Label1.Text = "ComboBox1_SelectedIndexChanged DataBound" ' ComboBox1 Label2. Label2.Text = ComboBox1.Text ' ComboBox1. Dimitm As DataRowView itm = ComboBox1.SelectedItem Label3.Text = CType(itm("au_id"), String) End Sub F5, [ 10.7]. 366
38 , DisplayMember Authors DataTable FullName ComboBox1. ComboBox1 SelectedIndexChanged ValueMember au_id. DataAccess, DataGrid DataSet., DataGrid ComboBox TabPage2.. 1., (DataGrid Binding) TabPage2. 10 Chapter 2. ComboBox TabPage2. 3. DataGrid TabPage2. [ 10.8]. DataSet DataGrid. ComboBox
39 DataGrid Binding DataGrid, TabControl1 TabIndexChanged. TabControl1, TabControl1_TabIndexChanged [ 10.9] ( ). TabControl. Northwind Orders DataGrid. Private Sub TabControl1_TabIndexChanged _ (ByVal sender As Object, _ ByVal e As System.EventArgs) _ Handles TabControl1.SelectedIndexChanged '. ', DataGrid. ' 0 1. IfTabControl1.SelectedTab.TabIndex = 1 Then ' Connection. Dim cn As New SqlConnection( _ "Server=(local)\NetSDK;DataBase=northwind;" _ & "Integrated Security=SSPI") ' SqlDataAdapter. ' SQL Connection. Dim da As SqlDataAdapter = New SqlDataAdapter _ ("SELECT * from Orders", cn) ' SqlDataAdapter ' DataSet. Dim ds As DataSet = New DataSet("Orders") ' Fill DataSet. da.fill(ds) ' DataSet 368
40 ' DataGrid DataSource. DataGrid1.DataSource = dv End If End Sub private void tabcontrol1_tabindexchanged(object sendert, System.EventArgs e) { //. //, DataGrid. if(tabcontrol1.selectedtab.text == "DataGrid Binding") { // Connection. SqlConnection cn = new SqlConnection(@"Server=(local)\NetSDK;DataBase=northwind; Integrated Security=SSPI"); 10 Chapter // SqlDataAdapter. // SQL Connection. SqlDataAdapter da = new SqlDataAdapter("SELECT * from Orders", cn); // SqlDataAdapter // DataSet. DataSet ds = new DataSet("Orders"); // Fill DataSet. da.fill(ds); // DataSet // DataGrid DataSource. datagrid1.datasource = ds; } } 369
![SqlDataAdapter. Connection Command, DataAdapter Fill. [ 10.9], DataGrid DataSource DataSet. F5.](/docs-images/82/85434226/images/41-0.jpg "[ 10.9]., DataGrid SQL Server.,.,. Summary ADO.NET. FCL,. ADO.NET.,. ADO.NET,., DataReader. 370")
41 SqlDataAdapter. Connection Command, DataAdapter Fill. [ 10.9], DataGrid DataSource DataSet. F5. [ 10.9]., DataGrid SQL Server.,.,. Summary ADO.NET. FCL,. ADO.NET.,. ADO.NET,., DataReader. 370
42 DataSet DataAdapter. 11 Visual Studio.NET ADO.NET. Q & A Q A DataReader., IList IListSource (System.ComponentModel ). DataReader unbuffered,.,. 10 Chapter Q A,.. connection open,, close. DataReader..NET DataReader. DataSet.. Select, Insert, Update, Delete SQL. SQL. 371
43 Qui z 1. DataReader DataAdapter SQL ADO.NET? 2. DataReader.? 3. SqlDataAdapter OleDataAdapter.,? 4. DataAdapter Connection.,? 5..NET Label, DataGrid, TextBox DataSet XML.,? 6.? Exercises 1. DataAccess TabPage1 ShowCheckedItems.., CheckedListBox 372
44 . GetItemChecked. Visual Studio.NET (SDK ). 2. DataAccess TabPage2 ComboBox. ComboBox. Northwind Customers TabPage2 ComboBox2 DataGrid CustomerID ComboBox2 CustomerID DataGrid., Form1 DataView dv. Public Class Form1 Inherits System.Windows.Forms.Form Private dv As DataView 10 Chapter public class Form1 : System.Windows.Forms.Form { private DataView dv; DataView Form1, Form1. Load_Customers. BindWithDataSet_ Click.,., Pubs Authors Northwind Customers. Load_Customers. Northwind Connection. Customers SQL Select SqlDataAdapter. SqlDataAdapter Fill, DataSet DataTable Customers. 373
45 ComboBox2 DataSet. ComboBox2 ValueMember CustomerID. ComboBox2 DisplayMember CustomerID. ComboBox2 SelectedIndexChanged, DataView RowFilter DataView, DataView DataGrid. SelectedIndexChanged. Private Sub ComboBox2_SelectedIndexChanged(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles ComboBox2.SelectedIndexChanged ' DataView RowFilter. dv.rowfilter = "CustomerID Like '" & ComboBox2.Text & "% " ' DataGrid DataView. DataGrid1.DataSource = dv End Sub private void combobox2_selectedindexchanged(object sender, System.EventArgs e) { // DataView RowFilter. dv.rowfilter = "CustomerID Like '" + combobox2.text + "% "; } // DataGrid DataView. datagrid1.datasource = dv;, TabControl1_TabIndexChanged., DataGrid DataSet DataView.. 374
46 dv = New DataView(ds.Tables(0), "", "", DataViewRowState.OriginalRows) ' DataSet ' DataGrid DataSource. DataGrid1.DataSource = dv SDK DataView., DataView DataSet. [ 10.10]. 10 Chapter 375
(Microsoft PowerPoint - ADONET [\310\243\310\257 \270\360\265\345])
![(Microsoft PowerPoint - ADONET [\310\243\310\257 \270\360\265\345])](/thumbs/86/93386720.jpg "(Microsoft PowerPoint - ADONET [\310\243\310\257 \270\360\265\345])")
- 1 - ADO.NET & XML & LINQ 이현정 hjyi@hotmail.com MCT/MCSD/MCAD/MCSD.NET - 2-20장데이터베이스와 ADO.NET 데이터베이스에대하여 관계형데이터베이스의기본적인구조 SQL(Structured Query Langauge) DBMS ADO.NET ADO.NET의구성 System.Data Data Provider
한국 컴퓨터그래픽스(디지털컨텐츠)의 현황과 미래 위기인가? 기회인가?
Chapter 14 ADO.NET 학습목표 ADO.NET 은데이터베이스사용의편의를위해, MS 사가만든표준데이터베이스인터페이스이다. 프로그램을한다는것에있어서빠질수없는부분이데이터베이스부분이다. ADO.NET 의 C# 에서활용을학습하도록한다. 2 ADO.NET 의개요 ADO.NET.NET 에서데이터베이스조작에관련된.NET 클래스들의집합 다양한방법으로데이터베이스를검색,
ALTIBASE 사용자가이드 Templete
Real Alternative DBMS ALTIBASE, Since 1999 WINDOWS ADO.NET 환경의 ALTIBASE 개발가이드 2010. 09 Copyright c 2000~2013 ALTBASE Corporation. All Rights Reserved. Document Control Change Record Date Author Change
Microsoft PowerPoint - CSharp-12-데이터베이스
12 장. ADO.NET ADO.NET 개요 데이터공급자데이터베이스연결 (Connection) 데이터베이스조작 (Command) 데이터읽기 (DataReader) DataTable, DataColumn, DataRow 클래스 DataAdapter 클래스와 DataSet 클래스 순천향대학교컴퓨터학부이상정 1 ADO.NET 개요 순천향대학교컴퓨터학부이상정 2 ADO.NET
Microsoft PowerPoint - 07-C#-13-ADO.ppt [호환 모드]
![Microsoft PowerPoint - 07-C#-13-ADO.ppt [호환 모드]](/thumbs/64/51905050.jpg "Microsoft PowerPoint - 07-C#-13-ADO.ppt [호환 모드]")
데이터베이스기초 ADO.NET MS Access 데이터베이스만들기 DataAdapter 클래스예 Connection, Command 클래스예 DataReader 클래스예레코드추가예레코드수정예레코드삭제예 순천향대학교컴퓨터학부이상정 1 데이터베이스기초 순천향대학교컴퓨터학부이상정 2 데이터베이스용어 필드 (field) 가장작은단위의의미있는데이터표현 교수이름, 학번등
10.ppt
: SQL. SQL Plus. JDBC. SQL >> SQL create table : CREATE TABLE ( ( ), ( ),.. ) SQL >> SQL create table : id username dept birth email id username dept birth email CREATE TABLE member ( id NUMBER NOT NULL
untitled
A Leader of Enterprise e-business Solution FORCS Co., LTD 1 OZ Application Getting Started (ver 5.1) 2 FORCS Co., LTD A Leader of Enterprise e-business Solution FORCS Co., LTD 3 OZ Application Getting
ALTIBASE 사용자가이드 Templete
Real Alternative DBMS ALTIBASE, Since 1999 WINDOWS 환경의 ALTIBASE ODBC 개발가이드 2010. 09 Copyright c 2000~2013 ALTBASE Corporation. All Rights Reserved. Document Control Change Record Date Author Change Reference
untitled
A Leader of Enterprise e-business Solution FORCS Co., LTD 1 OZ Application Getting Started 2 FORCS Co., LTD A Leader of Enterprise e-business Solution FORCS Co., LTD 3 OZ Application Getting Started 'OZ
<성진수의 C# 활용 2>
< 성진수의 C# 활용 2> 이문서의저작권은저에게있슴당..^^ ** MS SQL to XML ** 이번에는 MS_SQL 2000 과 XML과의관계를좀알아보겠습니다. 우선요즘 DBMS들이 XML과의호환성을놓이는데주력을하고있습니다. 그이유는 XML이이제는자료공유의표준화되었기때문입니다. 웹에서도그렇고모든자료를 XML형식으로주고받는추세이다보니 DBMS 또한 XML을지원해야겠지요..
untitled
A Leader of Enterprise e-business Solution FORCS Co., LTD 1 OZ Application Designer Getting Started 2 FORCS Co., LTD A Leader of Enterprise e-business Solution FORCS Co., LTD 3 OZ Application Designer
untitled
A Leader of Enterprise e-business Solution FORCS Co., LTD 1 OZ Application Designer Getting Started 2 FORCS Co., LTD A Leader of Enterprise e-business Solution FORCS Co., LTD 3 OZ Application Designer
초보자를 위한 ADO 21일 완성
ADO 21, 21 Sams Teach Yourself ADO 2.5 in 21 Days., 21., 2 1 ADO., ADO.? ADO 21 (VB, VBA, VB ), ADO. 3 (Week). 1, 2, COM+ 3.. HTML,. 3 (week), ADO. 24 1 - ADO OLE DB SQL, UDA(Universal Data Access) ADO.,,
3ÆÄÆ®-11
Chapter 11 Chapter 12 Chapter 13 Chapter 14 Chapter 15 Chapter 16 Chapter 17 C # N e t w o r k P r o g r a m m i n g Part 3 _ chapter 11 ICMP >>> 430 Chapter 11 _ 1 431 Part 3 _ 432 Chapter 11 _ N o t
3ÆÄÆ®-14
chapter 14 HTTP >>> 535 Part 3 _ 1 L i Sting using System; using System.Net; using System.Text; class DownloadDataTest public static void Main (string[] argv) WebClient wc = new WebClient(); byte[] response
untitled
OZ User Data Store Manual OZ User Data Store Manual,,,,, DataAction,, Http Request.. DLL DLL lib launch.cfg. // lib OZUDSSample_Csharp.dll, OZUDSSample_VBNET.dll lib. // config assembly.properties OZUDSSample_Csharp.dll,
PART 1 CHAPTER 1 Chapter 1 Note 4 Part 1 5 Chapter 1 AcctNum = Table ("Customer").Cells("AccountNumber") AcctNum = Customer.AccountNumber Note 6 RecordSet RecordSet Part 1 Note 7 Chapter 1 01:
chapter4
Basic Netw rk 1. ก ก ก 2. 3. ก ก 4. ก 2 1. 2. 3. 4. ก 5. ก 6. ก ก 7. ก 3 ก ก ก ก (Mainframe) ก ก ก ก (Terminal) ก ก ก ก ก ก ก ก 4 ก (Dumb Terminal) ก ก ก ก Mainframe ก CPU ก ก ก ก 5 ก ก ก ก ก ก ก ก ก ก
untitled
PowerBuilder 連 Microsoft SQL Server database PB10.0 PB9.0 若 Microsoft SQL Server 料 database Profile MSS 料 (Microsoft SQL Server database interface) 行了 PB10.0 了 Sybase 不 Microsoft 料 了 SQL Server 料 PB10.0
Connection 8 22 UniSQLConnection / / 9 3 UniSQL OID SET
135-080 679-4 13 02-3430-1200 1 2 11 2 12 2 2 8 21 Connection 8 22 UniSQLConnection 8 23 8 24 / / 9 3 UniSQL 11 31 OID 11 311 11 312 14 313 16 314 17 32 SET 19 321 20 322 23 323 24 33 GLO 26 331 GLO 26
초보자를 위한 ASP.NET 21일 완성
ASP.NET 21!!.! 21 ( day 2 ), Active Server Pages.NET (Web-based program -ming framework).,... ASP.NET. ASP. NET Active Server Pages ( ASP ),. ASP.NET,, ( ),.,.,, ASP.NET.? ASP.NET.. (, ).,. HTML. 24 ASP.
03. ADO 닷넷 ADO 닷넷이란? ADO(ActiveX Data Objects) 의닷넷버전 비연결방식 (Discected Mdel) 제공 데이터베이스와연결후필요한데이터를가져온후에, 접속을바로끊고나서도데이터를계속해서처리할수있는방법이필요 자원을계속많이확보가능 자료의처리
03. ADO 닷넷 탄생배경 인터넷환경에가장적합한기술필요 통합적으로관리할수있는기술이필요 더많은양의데이터를더빠르게서비스할수있는인터넷응용프로그램필요성대두 ' 데이터저장소 개념의필요 어느한컴퓨터에의존하는것이아니라여러다른장소에서언제든서비스받도록되어야함 데이터가어디에있던어떻게저장되어있던동일한인터페이스로개발필요 XML 을지원 표준화된자료전달방식의필요 03. ADO 닷넷
Visual Basic 반복문
학습목표 반복문 For Next문, For Each Next문 Do Loop문, While End While문 구구단작성기로익히는반복문 2 5.1 반복문 5.2 구구단작성기로익히는반복문 3 반복문 주어진조건이만족하는동안또는주어진조건이만족할때까지일정구간의실행문을반복하기위해사용 For Next For Each Next Do Loop While Wend 4 For
NoSQL
MongoDB Daum Communications NoSQL Using Java Java VM, GC Low Scalability Using C Write speed Auto Sharding High Scalability Using Erlang Read/Update MapReduce R/U MR Cassandra Good Very Good MongoDB Good
FileMaker 15 ODBC 및 JDBC 설명서
FileMaker 15 ODBC JDBC 2004-2016 FileMaker, Inc.. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker Go FileMaker, Inc.. FileMaker WebDirect FileMaker, Inc... FileMaker.
FileMaker ODBC 및 JDBC 가이드
FileMaker ODBC JDBC 2004-2019 FileMaker, Inc.. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker, FileMaker Cloud, FileMaker Go FileMaker, Inc.. FileMaker WebDirect FileMaker,
FileMaker ODBC and JDBC Guide
FileMaker 13 5 5 5 6 6 6 7 7 8 8 8 8 9 9 10 10 11 11 12 12 12 12 12 12 13 13 14 14 16 16 18 4 19 19 20 20 21 21 21 23 23 23 23 25 26 26 26 26 27 28 28 28 28 29 31 31 32 33 33 33 33 34 34 35 35 35 36 1
02 C h a p t e r Java
02 C h a p t e r Java Bioinformatics in J a va,, 2 1,,,, C++, Python, (Java),,, (http://wwwbiojavaorg),, 13, 3D GUI,,, (Java programming language) (Sun Microsystems) 1995 1990 (green project) TV 22 CHAPTER
초보자를 위한 C# 21일 완성
C# 21., 21 C#., 2 ~ 3 21. 2 ~ 3 21.,. 1~ 2 (, ), C#.,,.,., 21..,.,,, 3. A..,,.,.. Q&A.. 24 C#,.NET.,.,.,. Visual C# Visual Studio.NET,..,. CD., www. TeachYour sel f CSharp. com., ( )., C#.. C# 1, 1. WEEK
(Humphery Kim) RAD Studio : h=p://tech.devgear.co.kr/ : h=p://blog.hjf.pe.kr/ Facebook : h=p://d.com/hjfactory :
#2 (RAD STUDIO) In www.devgear.co.kr 2016.05.18 (Humphery Kim) RAD Studio : h=p://tech.devgear.co.kr/ : h=p://blog.hjf.pe.kr/ Facebook : h=p://d.com/hjfactory : hskim@embarcadero.kr 3! 1 - RAD, 2-3 - 4
@OneToOne(cascade = = "addr_id") private Addr addr; public Emp(String ename, Addr addr) { this.ename = ename; this.a
1 대 1 단방향, 주테이블에외래키실습 http://ojcedu.com, http://ojc.asia STS -> Spring Stater Project name : onetoone-1 SQL : JPA, MySQL 선택 http://ojc.asia/bbs/board.php?bo_table=lecspring&wr_id=524 ( 마리아 DB 설치는위 URL
Microsoft PowerPoint - 04-UDP Programming.ppt
Chapter 4. UDP Dongwon Jeong djeong@kunsan.ac.kr http://ist.kunsan.ac.kr/ Dept. of Informatics & Statistics 목차 UDP 1 1 UDP 개념 자바 UDP 프로그램작성 클라이언트와서버모두 DatagramSocket 클래스로생성 상호간통신은 DatagramPacket 클래스를이용하여
학습목표 함수프로시저, 서브프로시저의의미를안다. 매개변수전달방식을학습한다. 함수를이용한프로그래밍한다. 2
학습목표 함수프로시저, 서브프로시저의의미를안다. 매개변수전달방식을학습한다. 함수를이용한프로그래밍한다. 2 6.1 함수프로시저 6.2 서브프로시저 6.3 매개변수의전달방식 6.4 함수를이용한프로그래밍 3 프로시저 (Procedure) 프로시저 (Procedure) 란무엇인가? 논리적으로묶여있는하나의처리단위 내장프로시저 이벤트프로시저, 속성프로시저, 메서드, 비주얼베이직내장함수등
DocsPin_Korean.pages
Unity Localize Script Service, Page 1 Unity Localize Script Service Introduction Application Game. Unity. Google Drive Unity.. Application Game. -? ( ) -? -?.. 준비사항 Google Drive. Google Drive.,.. - Google
학습목표 배열에대해서안다. 언어통합질의 (LINQ) 에대해서안다. 2
학습목표 배열에대해서안다. 언어통합질의 (LINQ) 에대해서안다. 2 7.1 배열 7.2 언어통합질의 (LINQ) 3 배열 - 필요성 100 명의이름과국어, 영어, 수학과목에대한각각의합계와평균계산을위한프로그램? name_1 name_2 name_100 kuk_1 kuk_2 kuk_100? young_1 4 배열 -? name_1 name_2 name_100
UNIST_교원 홈페이지 관리자_Manual_V1.0
Manual created by metapresso V 1.0 3Fl, Dongin Bldg, 246-3 Nonhyun-dong, Kangnam-gu, Seoul, Korea, 135-889 Tel: (02)518-7770 / Fax: (02)547-7739 / Mail: contact@metabrain.com / http://www.metabrain.com
C++Builder ADO Programming (5) - ADO Transaction, Errors
C++Builder ADO Programming (5) - ADO Transaction, Errors Collections, Connection Events 지난번 강의에서 우리의 레밍은 TADOConnection의 여러 가지 속성들과 메소드들을 익히고 그것을 사용해서 SQL 문도 실행시키고 저장 프로시저도 호출해 보았다. 그것은 그것 나름대로의 한 방법이며
thesis
( Design and Implementation of a Generalized Management Information Repository Service for Network and System Management ) ssp@nile nile.postech.ac..ac.kr DPE Lab. 1997 12 16 GMIRS GMIRS GMIRS prototype
歯JavaExceptionHandling.PDF
(2001 3 ) from Yongwoo s Park Java Exception Handling Programming from Yongwoo s Park 1 Java Exception Handling Programming from Yongwoo s Park 2 1 4 11 4 4 try/catch 5 try/catch/finally 9 11 12 13 13
13 주차 - MDI, Exception, WebBrowser, RichTextBox, AlarmProgram 대림대학 년도 1 학기홍명덕
13 주차 - MDI, Exception, WebBrowser, RichTextBox, AlarmProgram 대림대학 - 2011 년도 1 학기홍명덕 (myungduk.hong@gmail.com) MDI(Multiple Document Interface) 응용프로그램은하나의응용프로그램에서동시에여러개의문서로작업할수있도록인터페이스를제공하는응용프로그램문서 (document)
rmi_박준용_final.PDF
(RMI) - JSTORM http://wwwjstormpekr (RMI)- Document title: Document file name: Revision number: Issued by: Document Information (RMI)- rmi finaldoc Issue Date: Status:
1
1 1....6 1.1...6 2. Java Architecture...7 2.1 2SDK(Software Development Kit)...8 2.2 JRE(Java Runtime Environment)...9 2.3 (Java Virtual Machine, JVM)...10 2.4 JVM...11 2.5 (runtime)jvm...12 2.5.1 2.5.2
Interstage5 SOAP서비스 설정 가이드
Interstage 5 Application Server ( Solaris ) SOAP Service Internet Sample Test SOAP Server Application SOAP Client Application CORBA/SOAP Server Gateway CORBA/SOAP Gateway Client INTERSTAGE SOAP Service
PowerPoint 프레젠테이션
@ Lesson 2... ( ). ( ). @ vs. logic data method variable behavior attribute method field Flow (Type), ( ) member @ () : C program Method A ( ) Method B ( ) Method C () program : Java, C++, C# data @ Program
歯처리.PDF
E06 (Exception) 1 (Report) : { $I- } { I/O } Assign(InFile, InputName); Reset(InFile); { $I+ } { I/O } if IOResult 0 then { }; (Exception) 2 2 (Settling State) Post OnValidate BeforePost Post Settling
01_피부과Part-01
PART 1 CHAPTER 01 3 PART 4 C H A P T E R 5 PART CHAPTER 02 6 C H A P T E R CHAPTER 03 7 PART 8 C H A P T E R 9 PART 10 C H A P T E R 11 PART 12 C H A P T E R 13 PART 14 C H A P T E R TIP 15 PART TIP TIP
DBMS & SQL Server Installation Database Laboratory
DBMS & 조교 _ 최윤영 } 데이터베이스연구실 (1314 호 ) } 문의사항은 cyy@hallym.ac.kr } 과제제출은 dbcyy1@gmail.com } 수업공지사항및자료는모두홈페이지에서확인 } dblab.hallym.ac.kr } 홈페이지 ID: 학번 } 홈페이지 PW:s123 2 차례 } } 설치전점검사항 } 설치단계별설명 3 Hallym Univ.
학습목표 텍스트파일을다룰수있다. 스트림읽기, 쓰기를안다. 2
학습목표 텍스트파일을다룰수있다. 스트림읽기, 쓰기를안다. 2 8.1 텍스트파일다루기 8.2 스트림읽기, 쓰기 3 텍스트파일 문자, 숫자, 단어들이하나이상의줄로구성 파일확장명 :.txt,.ini,.log, OpenFileDialog 컨트롤 : 파일의위치를사용자가쉽게선택가능 Filter 속성 : 파일의형식선택가능 ShowDialog 메서드 : 열기대화상자 FileName
<C0CCBCBCBFB52DC1A4B4EBBFF82DBCAEBBE7B3EDB9AE2D313939392D382E687770>
i ii iii iv v vi 1 2 3 4 가상대학 시스템의 국내외 현황 조사 가상대학 플랫폼 개발 이상적인 가상대학시스템의 미래상 제안 5 웹-기반 가상대학 시스템 전통적인 교수 방법 시간/공간 제약을 극복한 학습동기 부여 교수의 일방적인 내용전달 교수와 학생간의 상호작용 동료 학생들 간의 상호작용 가상대학 운영 공지사항,강의록 자료실, 메모 질의응답,
Session3. 한국마이크로소프트(전사적 데이터 통합 컨퍼런스).ppt
SQL Server 2000 DTS / 2005 IS (mskang@microsoft.com) RRE / CSS / Microsoft SQL Server & Analysis Service genda SQL Server 2000 DTS SQL Server 2005 SSIS (M&A) BI SQL Server, Oracle, DB2, Sybase, Infomix,
Microsoft PowerPoint - 10Àå.ppt
10 장. DB 서버구축및운영 DBMS 의개념과용어를익힌다. 간단한 SQL 문법을학습한다. MySQL 서버를설치 / 운영한다. 관련용어 데이터 : 자료 테이블 : 데이터를표형식으로표현 레코드 : 테이블의행 필드또는컬럼 : 테이블의열 필드명 : 각필드의이름 데이터타입 : 각필드에입력할값의형식 학번이름주소연락처 관련용어 DB : 테이블의집합 DBMS : DB 들을관리하는소프트웨어
Microsoft SQL Server 2005 포켓 컨설턴트 관리자용
Microsoft SQL Server 2005 SQL Server 2005. SQL Server,. SQL Server. SQL Server,,, ( ). 1000 100,,,, SQL Server.? Microsoft SQL Server 2005 SQL Server (Workgroup, Standard, Enterprise, Developer).. SQL
FileMaker ODBC and JDBC Guide
FileMaker 14 5 5 5 5 6 6 6 7 7 7 8 8 8 9 9 10 10 11 11 12 12 12 12 12 13 13 14 15 16 17 18 18 19 19 20 20 20 21 21 21 22 22 22 22 23 24 24 24 24 25 27 27 28 29 29 29 29 30 30 31 31 31 32 1 1 1 1 1 1 1
PowerPoint 프레젠테이션
@ Lesson 3 if, if else, if else if, switch case for, while, do while break, continue : System.in, args, JOptionPane for (,, ) @ vs. logic data method variable Data Data Flow (Type), ( ) @ Member field
13주-14주proc.PDF
12 : Pro*C/C++ 1 2 Embeded SQL 3 PRO *C 31 C/C++ PRO *C NOT! NOT AND && AND OR OR EQUAL == = SQL,,, Embeded SQL SQL 32 Pro*C C SQL Pro*C C, C Pro*C, C C 321, C char : char[n] : n int, short, long : float
초보자를 위한 한글 Visual Basic .NET 21일 완성
21 Visual Basic.NET. Visual Basic.NET Visual Basic..NET Visual Basic.NET,..NET Micorosoft.,,..NET 21,. Visual Basic.NET, 21,.NET,.NET. Visual Basic.NET,.NET,,.,.NET...NET (Visual Basic, C#, C+ + ).NET.
Orcad Capture 9.x
OrCAD Capture Workbook (Ver 10.xx) 0 Capture 1 2 3 Capture for window 4.opj ( OrCAD Project file) Design file Programe link file..dsn (OrCAD Design file) Design file..olb (OrCAD Library file) file..upd
01....b74........62
4 5 CHAPTER 1 CHAPTER 2 CHAPTER 3 6 CHAPTER 4 CHAPTER 5 CHAPTER 6 7 1 CHAPTER 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
¾Ë·¹¸£±âÁöħ¼�1-ÃÖÁ¾
Chapter 1 Chapter 1 Chapter 1 Chapter 2 Chapter 2 Chapter 2 Chapter 2 Chapter 2 Chapter 3 Chapter 3 Chapter 3 Chapter 3 Chapter 3 Chapter 3 Chapter 3 Chapter 3 Chapter 4 Chapter 4
(291)본문7
2 Chapter 46 47 Chapter 2. 48 49 Chapter 2. 50 51 Chapter 2. 52 53 54 55 Chapter 2. 56 57 Chapter 2. 58 59 Chapter 2. 60 61 62 63 Chapter 2. 64 65 Chapter 2. 66 67 Chapter 2. 68 69 Chapter 2. 70 71 Chapter
歯엑셀모델링
I II II III III I VBA Understanding Excel VBA - 'VB & VBA In a Nutshell' by Paul Lomax, October,1998 To enter code: Tools/Macro/visual basic editor At editor: Insert/Module Type code, then compile by:
목차 BUG offline replicator 에서유효하지않은로그를읽을경우비정상종료할수있다... 3 BUG 각 partition 이서로다른 tablespace 를가지고, column type 이 CLOB 이며, 해당 table 을 truncate
ALTIBASE HDB 6.1.1.5.6 Patch Notes 목차 BUG-39240 offline replicator 에서유효하지않은로그를읽을경우비정상종료할수있다... 3 BUG-41443 각 partition 이서로다른 tablespace 를가지고, column type 이 CLOB 이며, 해당 table 을 truncate 한뒤, hash partition
Copyright 2012, Oracle and/or its affiliates. All rights reserved.,.,,,,,,,,,,,,.,...,. U.S. GOVERNMENT END USERS. Oracle programs, including any oper
Windows Netra Blade X3-2B( Sun Netra X6270 M3 Blade) : E37790 01 2012 9 Copyright 2012, Oracle and/or its affiliates. All rights reserved.,.,,,,,,,,,,,,.,...,. U.S. GOVERNMENT END USERS. Oracle programs,
C# 입문 : 이론과 실습
버튺기반컨트롤 레이블과링크레이블 텍스트상자 리스트 [2/43] 컨트롤 화면에표시되어사용자와상호작용을수행하는컴포넌트를의미. 종류 : 버튺, 레이블, 텍스트, 리스트 버튺기반컨트롤 : 버튺, 체크상자, 라디오버튺 컨트롤의종류 레이블컨트롤 : 레이블, 링크레이블 텍스트컨트롤 : 텍스트상자 리스트컨트롤 : 리스트상자, 콤보상자, 체크리스트상자 [3/43] 버튺기반컨트롤
USER GUIDE
Solution Package Volume II DATABASE MIGRATION 2010. 1. 9. U.Tu System 1 U.Tu System SeeMAGMA SYSTEM 차 례 1. INPUT & OUTPUT DATABASE LAYOUT...2 2. IPO 중 VB DATA DEFINE 자동작성...4 3. DATABASE UNLOAD...6 4.
Microsoft PowerPoint - web-part03-ch19-node.js기본.pptx
과목명: 웹프로그래밍응용 교재: 모던웹을 위한 JavaScript Jquery 입문, 한빛미디어 Part3. Ajax Ch19. node.js 기본 2014년 1학기 Professor Seung-Hoon Choi 19 node.js 기본 이 책에서는 서버 구현 시 node.js 를 사용함 자바스크립트로 서버를 개발 다른서버구현기술 ASP.NET, ASP.NET
초보자를 위한 크리스탈 리포트 9 - 대화형 리포트의 작성과 디자인
ha pte r 1 9..,.,, (legacy)., ERP(Enterprise Resource Planning, ), CRM(Customer Relationship Management, ), IT (Information Technology system, ). 700. (Microsoft.NET, SAP, PeopleSoft )... [ 1.1]. Part
작성자 : 한동훈 제목 : 효율적인웹응용프로그램구축 들어가기두번째섹션에서는먼저데이터액세스계층 (DAL: Data Access Layer) 작성에대한이야기를했습니다. 따라서데이터액세스계층에대해서먼저살펴본다음에 ASP.NET을기준으로 'Everything in one pa
작성자 : 한동훈 제목 : 효율적인웹응용프로그램구축 들어가기두번째섹션에서는먼저데이터액세스계층 (DAL: Data Access Layer) 작성에대한이야기를했습니다. 따라서데이터액세스계층에대해서먼저살펴본다음에 ASP.NET을기준으로 'Everything in one page(or method)' 안티패턴에대해서얘기하며이를풀기위해 MVC(Model-View-Controller)
페이지 2 / 9 목차 개요웹취약점분류점검결과해결방안 주의사항 : 빛스캔 ( 주 ) 의취약성검사가대상웹사이트의취약점을 100% 진단하지못할가능성이있으며, 원격에서탐지 하는점검의특성상오탐지 (False Positive) 할가능성이있으므로충분한검토과정
페이지 1 / 9 https://scan.bitscan.co.kr -BMT version 웹취약점점검보고서 점검대상 : testasp.vulnweb.com 주의 : 점검대상웹서버보안에관련된중요한정보를포함하고있습니다. 빛스캔 ( 주 ) https://scan.bitscan.co.kr 페이지 2 / 9 목차 1. 2. 3. 4. 개요웹취약점분류점검결과해결방안 주의사항
MasoJava4_Dongbin.PDF
JSTORM http://wwwjstormpekr Issued by: < > Revision: Document Information Document title: Document file name: MasoJava4_Dongbindoc Revision number: Issued by: < > SI, dbin@handysoftcokr
Microsoft Word - MS-SQL injections 공격 대처하기.doc
작성자 : 기술지원부조태준 tedcho@nextline.net MS-SQL Database 백업하기 ASP.NET 및 Microsoft SQL Server과같은강력한데이터베이스서버의고급서버측기술을통해개발자는동적인데이터중심웹사이트를매우쉽게만들수있습니다. 하지만 ASP.NET 및 SQL의기능은 SQL injections 공격이라는너무나일반적인공격방식을알고있는해커들에게도쉽게악용될수있습니다.
90
89 3 차원공간질의를위한효율적인위상학적데이터모델의검증 Validation of Efficient Topological Data Model for 3D Spatial Queries Seokho Lee Jiyeong Lee 요약 키워드 Abstract Keywords 90 91 92 93 94 95 96 -- 3D Brep adjacency_ordering DECLARE
MySQL-Ch05
MySQL P A R T 2 Chapter 05 Chapter 06 Chapter 07 Chapter 08 05 Chapter MySQL MySQL. (, C, Perl, PHP),. 5.1 MySQL., mysqldump, mysqlimport, mysqladmin, mysql. MySQL. mysql,. SQL. MySQL... MySQL ( ). MySQL,.
비긴쿡-자바 00앞부속
IT COOKBOOK 14 Java P r e f a c e Stay HungryStay Foolish 3D 15 C 3 16 Stay HungryStay Foolish CEO 2005 L e c t u r e S c h e d u l e 1 14 PPT API C A b o u t T h i s B o o k IT CookBook for Beginner Chapter
Java 프로그래머를 위한 C# 비교 활용
Java C#.. Microsoft.NET.NET C#. Microsoft C#,,. Microsoft SUN C# C C++. C# Java. C# Java Java C#.. Java? Java. C#., C# Microsoft. Microsoft..NET C# Microsoft., C#., Java, C#. C#.NET,., XML Java J2EE,.NET
자바-11장N'1-502
C h a p t e r 11 java.net.,,., (TCP/IP) (UDP/IP).,. 1 ISO OSI 7 1977 (ISO, International Standards Organization) (OSI, Open Systems Interconnection). 6 1983 X.200. OSI 7 [ 11-1] 7. 1 (Physical Layer),
신림프로그래머_클린코드.key
CLEAN CODE 6 11st Front Dev. Team 6 1. 2. 3. checked exception 4. 5. 6. 11 : 2 4 : java (50%), javascript (35%), SQL/PL-SQL (15%) : Spring, ibatis, Oracle, jquery ? , (, ) ( ) 클린코드를 무시한다면 . 6 1. ,,,!
API - Notification 메크로를통하여어느특정상황이되었을때 SolidWorks 및보낸경로를통하여알림메시지를보낼수있습니다. 이번기술자료에서는메크로에서이벤트처리기를통하여진행할예정이며, 메크로에서작업을수행하는데유용할것입니다. 알림이벤트핸들러는응용프로그램구현하는데있어
메크로를통하여어느특정상황이되었을때 SolidWorks 및보낸경로를통하여알림메시지를보낼수있습니다. 이번기술자료에서는메크로에서이벤트처리기를통하여진행할예정이며, 메크로에서작업을수행하는데유용할것입니다. 알림이벤트핸들러는응용프로그램구현하는데있어서가장중요한부분이라고도할수있기때문입니다. 1. 새로운메크로생성 새메크로만들기버튺을클릭하여파일을생성합니다. 2. 메크로저장 -
8 장데이터베이스 8.1 기본개념 - 데이터베이스 : 데이터를조직적으로구조화한집합 (cf. 엑셀파일 ) - 테이블 : 데이터의기록형식 (cf. 엑셀시트의첫줄 ) - 필드 : 같은종류의데이터 (cf. 엑셀시트의각칸 ) - 레코드 : 데이터내용 (cf. 엑셀시트의한줄 )
8 장데이터베이스 8.1 기본개념 - 데이터베이스 : 데이터를조직적으로구조화한집합 (cf. 엑셀파일 ) - 테이블 : 데이터의기록형식 (cf. 엑셀시트의첫줄 ) - 필드 : 같은종류의데이터 (cf. 엑셀시트의각칸 ) - 레코드 : 데이터내용 (cf. 엑셀시트의한줄 ) - DDL(Data Definition Language) : show, create, drop
USB USB DV25 DV25 REC SRN-475S REC SRN-475S LAN POWER LAN POWER Quick Network Setup Guide xdsl/cable Modem PC DVR 1~3 1.. DVR DVR IP xdsl Cable xdsl C
USB USB DV25 DV25 REC SRN-475S REC SRN-475S LAN POWER LAN POWER Quick Network Setup Guide xdsl/cable Modem PC DVR 1~3 1.. DVR DVR IP xdsl Cable xdsl Cable PC PC Step 1~5. Step, PC, DVR Step 1. Cable Step
ORANGE FOR ORACLE V4.0 INSTALLATION GUIDE (Online Upgrade) ORANGE CONFIGURATION ADMIN O
Orange for ORACLE V4.0 Installation Guide ORANGE FOR ORACLE V4.0 INSTALLATION GUIDE...1 1....2 1.1...2 1.2...2 1.2.1...2 1.2.2 (Online Upgrade)...11 1.3 ORANGE CONFIGURATION ADMIN...12 1.3.1 Orange Configuration
EMBARCADERO TECHNOLOGIES (Humphery Kim) RAD Studio : h=p://tech.devgear.co.kr/ : h=p://blog.hjf.pe.kr/ Facebook : h=p://d.com/hjfactory :
#3 (RAD STUDIO) In www.devgear.co.kr 2016.05.23 EMBARCADERO TECHNOLOGIES (Humphery Kim) RAD Studio : h=p://tech.devgear.co.kr/ : h=p://blog.hjf.pe.kr/ Facebook : h=p://d.com/hjfactory : hskim@embarcadero.kr
JDBC 소개및설치 Database Laboratory
JDBC 소개및설치 JDBC } What is the JDBC? } JAVA Database Connectivity 의약어 } 자바프로그램안에서 SQL 을실행하기위해데이터베이스를연결해주는응용프로그램인터페이스 } 연결된데이터베이스의종류와상관없이동일한방법으로자바가데이터베이스내에서발생하는트랜잭션을제어할수있도록하는환경을제공 2 JDBC Driver Manager }
Analytics > Log & Crash Search > Unity ios SDK [Deprecated] Log & Crash Unity ios SDK. TOAST SDK. Log & Crash Unity SDK Log & Crash Search. Log & Cras
![Analytics > Log & Crash Search > Unity ios SDK [Deprecated] Log & Crash Unity ios SDK. TOAST SDK. Log & Crash Unity SDK Log & Crash Search. Log & Cras](/thumbs/101/151500399.jpg "Analytics > Log & Crash Search > Unity ios SDK [Deprecated] Log & Crash Unity ios SDK. TOAST SDK. Log & Crash Unity SDK Log & Crash Search. Log & Cras")
Analytics > Log & Crash Search > Unity ios SDK [Deprecated] Log & Crash Unity ios SDK. TOAST SDK. Log & Crash Unity SDK Log & Crash Search. Log & Crash Unity SDK... Log & Crash Search. - Unity3D v4.0 ios
ilist.add(new Integer(1))과 같이 사용하지 않고 ilist.add(1)과 같이 사용한 것은 자바 5.0에 추가된 기본 자료형과 해당 객체 자료 형과의 오토박싱/언박싱 기능을 사용한 것으로 오토박싱이란 자바 컴파일러가 객체를 요구하는 곳에 기본 자료형
바에 제네릭스(generics)를 도입하기 위한 연구는 이미 8년 전인 1996년부터라고 한다. 실제로 자바에 제네릭스를 도입하 는 몇 가지 방안들이 논문으로 나오기 시작한 것이 1998년 초임을 감 안하면 무려 8년이 지난 후에야 자바 5.0에 전격 채택되었다는 것은 이것이 얼마나 어려운 일이었나 하는 것을 보여준다. 자바의 스펙을 결정하는 표준화 절차인
Chap7.PDF
Chapter 7 The SUN Intranet Data Warehouse: Architecture and Tools All rights reserved 1 Intranet Data Warehouse : Distributed Networking Computing Peer-to-peer Peer-to-peer:,. C/S Microsoft ActiveX DCOM(Distributed
第 1 節 組 織 11 第 1 章 檢 察 의 組 織 人 事 制 度 등 第 1 項 大 檢 察 廳 第 1 節 組 대검찰청은 대법원에 대응하여 수도인 서울에 위치 한다(검찰청법 제2조,제3조,대검찰청의 위치와 각급 검찰청의명칭및위치에관한규정 제2조). 대검찰청에 검찰총장,대
第 1 章 檢 察 의 組 織 人 事 制 度 등 第 1 節 組 織 11 第 1 章 檢 察 의 組 織 人 事 制 度 등 第 1 項 大 檢 察 廳 第 1 節 組 대검찰청은 대법원에 대응하여 수도인 서울에 위치 한다(검찰청법 제2조,제3조,대검찰청의 위치와 각급 검찰청의명칭및위치에관한규정 제2조). 대검찰청에 검찰총장,대검찰청 차장검사,대검찰청 검사,검찰연구관,부
JMF2_심빈구.PDF
JMF JSTORM http://wwwjstormpekr Issued by: < > Document Information Document title: Document file name: Revision number: Issued by: JMF2_ doc Issue Date: Status: < > raica@nownurinet
Delphi 2005 Reviewer's Guide
Delphi 2005 Borland Delphi 2005 Contents 8 Delphi 8 (IDE)13 IDE, 13 IDE, 15 Structure Pane 16 VCL / VCLNET 18 Tool Palette 19 Tool Palette 20 VCLNET 22 Object Inspector 23 Upgrade Project 24 Delphi 2005
SQL Developer Connect to TimesTen 유니원아이앤씨 DB 기술지원팀 2010 년 07 월 28 일 문서정보 프로젝트명 SQL Developer Connect to TimesTen 서브시스템명 버전 1.0 문서명 작성일 작성자
SQL Developer Connect to TimesTen 유니원아이앤씨 DB 팀 2010 년 07 월 28 일 문서정보 프로젝트명 SQL Developer Connect to TimesTen 서브시스템명 버전 1.0 문서명 작성일 2010-07-28 작성자 김학준 최종수정일 2010-07-28 문서번호 20100728_01_khj 재개정이력 일자내용수정인버전
PWR PWR HDD HDD USB USB Quick Network Setup Guide xdsl/cable Modem PC DVR 1~3 1.. DVR DVR IP xdsl Cable xdsl Cable PC PC DDNS (
PWR PWR HDD HDD USB USB Quick Network Setup Guide xdsl/cable Modem PC DVR 1~3 1.. DVR DVR IP xdsl Cable xdsl Cable PC PC DDNS (http://ddns.hanwha-security.com) Step 1~5. Step, PC, DVR Step 1. Cable Step
PowerPoint 프레젠테이션
Reasons for Poor Performance Programs 60% Design 20% System 2.5% Database 17.5% Source: ORACLE Performance Tuning 1 SMS TOOL DBA Monitoring TOOL Administration TOOL Performance Insight Backup SQL TUNING
Dialog Box 실행파일을 Web에 포함시키는 방법
DialogBox Web 1 Dialog Box Web 1 MFC ActiveX ControlWizard workspace 2 insert, ID 3 class 4 CDialogCtrl Class 5 classwizard OnCreate Create 6 ActiveX OCX 7 html 1 MFC ActiveX ControlWizard workspace New
歯2000-09-Final.PDF
Design Pattern - API JSTORM http://www.jstorm.pe.kr -1- java API 2000-08-14 Public 2000-08-16 Draft (dbin@handysoft.co.kr), (pam@emotion.co.kr) HISTORY (csecau@orgio.net) 2001/2/15 9 10 jstorm
MS-SQL SERVER 대비 기능
Business! ORACLE MS - SQL ORACLE MS - SQL Clustering A-Z A-F G-L M-R S-Z T-Z Microsoft EE : Works for benchmarks only CREATE VIEW Customers AS SELECT * FROM Server1.TableOwner.Customers_33 UNION ALL SELECT
3 S Q L A n t i p a t t e r n s Trees/intro/parent.sql CREATE TABLE Comments ( comment_id SERIAL PRIMARY KEY, parent_id BIGINT UNSIGNED, comment TEXT
3 S Q L A n t i p a t t e r n s Trees/intro/parent.sql CREATE TABLE Comments ( comment_id SERIAL PRIMARY KEY, parent_id BIGINT UNSIGNED, comment TEXT NOT NULL, FOREIGN KEY (parent_id) REFERENCES Comments(comment_id)
2파트-07
CHAPTER 07 Ajax ( ) (Silverlight) Ajax RIA(Rich Internet Application) Firefox 4 Ajax MVC Ajax ActionResult Ajax jquery Ajax HTML (Partial View) 7 3 GetOrganized Ajax GetOrganized Ajax HTTP POST 154 CHAPTER