|
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Configuration;
namespace WinDataAdapter
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
Display(); //DataReader이용
Display1(); //DataSet - Fill 이용
}
//Connection - command - DataReader - DataSet
// DataTable 윈폼만... 패턴 출력
private void Display()
{
SqlConnection con = new SqlConnection();
con.ConnectionString =
"server=.;database=AddressBook;uid=AddressBook;pwd=1234;";
con.Open();
SqlCommand cmd = new SqlCommand
("Select *From AddressBook", con);
cmd.CommandType = CommandType.Text;
SqlDataReader dr = cmd.ExecuteReader();//팩터리 메서드로 리더생성
DataTable dt = new DataTable();
dt.Load(dr);
this.dataGridView1.DataSource = dt; //출력
dr.Close();
con.Close();
}
//Connection - Command - DataSet - Fill 패턴 출력
private SqlDataAdapter da2;//필드레벨로 재선언
private DataTable dt2;
private void Display1()
{
SqlConnection con = new SqlConnection();
con.ConnectionString =
server=.;database=AddressBook;uid=AddressBook;pwd=1234;";
con.Open();
SqlCommand cmd = new SqlCommand
da2 = new SqlDataAdapter(cmd);
da2.SelectCommand = cmd;
//삽입
cmd = new SqlCommand
("Insert Into AddressBook Values
(@Name, @Mobile, @Email)", con);
cmd.Parameters.Add("@Name", SqlDbType.VarChar, 25, "Name");
cmd.Parameters.Add
("@Mobile",SqlDbType.VarChar, 25, "Mobile");
cmd.Parameters.Add("@Email", SqlDbType.VarChar, 25, "Email");
da2.InsertCommand = cmd;
//수정
cmd = new SqlCommand
("Update AddressBook Set
Name = @Name, Mobile=@Mobile,
Email=@Email Where Num = @Num", con);
cmd.Parameters.Add
("@Name", SqlDbType.VarChar, 25, "Name");
cmd.Parameters.Add
("@Mobile", SqlDbType.VarChar, 25,"Mobile");
cmd.Parameters.Add
("@Email", SqlDbType.VarChar, 25,"Email");
cmd.Parameters.Add("@Num", SqlDbType.Int, 32, "Num");
da2.UpdateCommand = cmd;
//삭제
cmd = new SqlCommand
("Delete AddressBook Where Num = @Num",con);
cmd.Parameters.Add("@Num",SqlDbType.Int,32,"Num");
da2.DeleteCommand = cmd;
dt2 = new DataTable("Addressbook");
da2.Fill(dt2);
this.dataGridView2.DataSource = dt2;
}
private void btnSave_Click(object sender, EventArgs e)
{
da2.Update(dt2); //변경 내역 적용하기
}
}
} | 
WinDataAdapter0930.zip