Window PDA 입력,출력,수정,삭제,검색 기능

초 간단하게 기능 구현~공부 하면서 제가 직접 작성했어요...

---

using System;

using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlServerCe;

namespace SmartDeviceProject2
{
    public partial class Form2 : Form
    {
        private DataSet dataset;
        private SqlCeDataAdapter adapter;
        private int cmdMode;

        public Form2()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string connStr = @"Data Source=\Program Files\SmartDeviceProject1\TestDB.sdf";

            SqlCeConnection conn = new SqlCeConnection(connStr);
            try
            {
                dataset = new DataSet();
                SqlCeCommand cmd = new SqlCeCommand();

                //생성
                cmd.CommandText = "Select Num, Name, Email From TBuser";
                //Connection 객체 연결
                cmd.Connection = conn;
                conn.Open();

                //SqlDataAdapter 클래스의 객체 생성
                adapter = new SqlCeDataAdapter();
                //SqlDataAdapter 클래스의 Command 모드 설정
                adapter.SelectCommand = cmd;

                //SqlDataadapter 클래스를 이용해서 DataSet 개체에 데이터를 채움
                adapter.Fill(dataset, "TBuser");
                //DataSet 개체에 담긴 데이터를 DataGrid 컨트롤에 바인딩 시킴
                this.dataGrid1.DataSource = dataset.Tables["TBuser"];
            }
            catch (Exception err)
            {
                MessageBox.Show(err.Message.ToString());
            }
            finally
            {
                try
                {
                    if (conn != null)
                    {
                        conn.Close();
                    }
                }
                catch(Exception)
                {
                }
            }
        }

        #region 입력

        //입력 팝업창 표시
        private void button2_Click(object sender, EventArgs e)
        {
            cmdMode = 1;    //입력모드
            this.popUp();
            textBox1.Text = "";
        }

        //입력 팝업창 불러오기
        private void popUp()
        {
            panel1.Visible = true;
           
            //입력과 수정창이 화면에 보이도록 이동
            this.panel1.Top = 20;
            this.panel1.Left = 32;

            //보여지는 Panel을 맨 앞으로 지정
            this.panel1.BringToFront();
            this.textBox1.Focus();

            //수정버튼을 클릭 했다면...
            if (cmdMode == 2)
            {
                //DataGrid 컨트롤에 현재 선택되어진 셀에 데이터를 TextBox 컨트롤에 표시
                this.textBox1.Focus();

                this.textBox1.Text = this.dataset.Tables["TBuser"].Rows[this.dataGrid1.CurrentRowIndex]["Name"].ToString();
                this.textBox2.Text = this.dataset.Tables["TBuser"].Rows[this.dataGrid1.CurrentRowIndex]["Email"].ToString();
                this.textBox3.Text = this.dataset.Tables["TBuser"].Rows[this.dataGrid1.CurrentRowIndex]["Num"].ToString();
            }
        }

        //팝업창 - 입력버튼
        private void button5_Click(object sender, EventArgs e)
        {
            DataRow dr = null;
            string columnName = "";

            if (cmdMode == 1)
            {
                //dr = dataset.Tables["TBuser"].NewRow();

                //columnName = dataset.Tables["TBuser"].Columns[1].ColumnName;
                //dr[columnName] = this.textBox1.Text;

                //columnName = dataset.Tables["TBuser"].Columns[2].ColumnName;
                //dr[columnName] = this.textBox2.Text;

                //dataset.Tables["TBuser"].Rows.Add(dr);

//====================================================================================================================================
                string connStr = @"Data Source=\Program Files\SmartDeviceProject1\TestDB.sdf";
                SqlCeConnection conn = new SqlCeConnection(connStr);
                try
                {
                    dataset = new DataSet();
                    SqlCeCommand cmd = new SqlCeCommand();

                    //생성
                    cmd.CommandText = "Select Num, Name, Email From TBuser";
                    cmd.CommandText = "Insert Into TBuser(Name, Email) Values('" + textBox1.Text + "','" + textBox2.Text + "')";
                    //Connection 객체 연결
                    cmd.Connection = conn;
                    conn.Open();

                    //SqlDataAdapter 클래스의 객체 생성
                    adapter = new SqlCeDataAdapter();
                    //SqlDataAdapter 클래스의 Command 모드 설정
                    adapter.SelectCommand = cmd;

                    //SqlDataadapter 클래스를 이용해서 DataSet 개체에 데이터를 채움
                    adapter.Fill(dataset, "TBuser");
                    //DataSet 개체에 담긴 데이터를 DataGrid 컨트롤에 바인딩 시킴
                    this.dataGrid1.DataSource = dataset.Tables["TBuser"];

                    panel1.Hide();
                }

                catch (Exception err)
                {
                    MessageBox.Show(err.Message.ToString());
                }
//====================================================================================================================================
            }
            else if(cmdMode == 2)
            {
                this.dataset.Tables["TBuser"].Rows[this.dataGrid1.CurrentRowIndex]["Name"] = textBox1.Text;
                this.dataset.Tables["TBuser"].Rows[this.dataGrid1.CurrentRowIndex]["Email"] = textBox2.Text;

                dataset = new DataSet();
                SqlCeCommand cmd = new SqlCeCommand();
                cmd.CommandText = "Update TBuser Set Name = '" + textBox1.Text + "', Email = '" + textBox2.Text + "' Where Num = " + textBox3.Text + "";
                //cmd.CommandText = "Update TBuser Set Name = '" + textBox1.Text + "', Email = '" + textBox2.Text + "'";

                saveData();

                panel1.Hide();
            }
        }

        private void saveData()
        {
            string conStr = @"Data Source=\Program Files\SmartDeviceProject1\TestDB.sdf";
            SqlCeConnection con = new SqlCeConnection(conStr);
            try
            {
                dataset = new DataSet();
                SqlCeCommand cmd = new SqlCeCommand();

                cmd.CommandText = "select Num, Name, Email From TBuser";
                cmd.CommandText = "Update TBuser Set Name = '" + textBox1.Text + "', Email = '" + textBox2.Text + "'Where Num = " + textBox3.Text + "";
                cmd.Connection = con;
                con.Open();
                adapter = new SqlCeDataAdapter();
                adapter.SelectCommand = cmd;

                adapter.Fill(dataset, "TBuser");
                this.dataGrid1.DataSource = dataset.Tables["TBuser"];

            }
            catch(Exception err)
            {
                MessageBox.Show(err.Message.ToString());
            }
        }

       
        //팝업창 - 취소버튼
        private void button6_Click(object sender, EventArgs e)
        {
            panel1.Hide();
        }

        #endregion

        //수정버튼
        private void button3_Click(object sender, EventArgs e)
        {
            cmdMode = 2;
            popUp();
        }

        //삭제버튼
        private void button4_Click(object sender, EventArgs e)
        {
            dataset.Tables["TBuser"].Rows[this.dataGrid1.CurrentCell.RowNumber].Delete();

            DisplayData();

        }

        private void DisplayData()
        {
            string conStr = @"Data Source=\Program Files\SmartDeviceProject1\TestDB.sdf";
            SqlCeConnection conn = new SqlCeConnection(conStr);

            try
            {
                SqlCeCommandBuilder cb = new SqlCeCommandBuilder(adapter);
                adapter.Update(dataset, "TBuser");
                this.dataset.Tables["TBuser"].AcceptChanges();
            }

            catch (Exception err)
            {
                MessageBox.Show(err.Message.ToString());
            }
            finally
            {
                try
                {
                    if (conn != null)
                    {
                        conn.Close();
                    }
                }
                catch (Exception err)
                {
                    MessageBox.Show(err.Message.ToString());
                }
            }
        }

        //검색버튼
        private void button7_Click(object sender, EventArgs e)
        {
            string conStr = @"Data Source=\Program Files\SmartDeviceProject1\TestDB.sdf";
            SqlCeConnection conn = new SqlCeConnection(conStr);

            try
            {
                dataset = new DataSet();

                SqlCeCommand cmd = new SqlCeCommand();
                cmd.CommandText = "Select *From TBuser Where Name = '" + textBox4.Text + "'";

                MessageBox.Show("너가 찾는게 " + textBox4.Text + " 맞음?");

                cmd.Connection = conn;
                conn.Open();

                adapter = new SqlCeDataAdapter();
                adapter.SelectCommand = cmd;

                adapter.Fill(dataset, "TBuser");
                this.dataGrid1.DataSource = dataset.Tables["TBuser"];

            }

            catch (Exception err)
            {
                MessageBox.Show(err.Message.ToString());
            }
        }
    }
}