namespace WebApplication1
{
    public class 이윤환
    {
        public 전지현<string>[] Collect;
    }

    public class 전지현<T>
    {
        public T x;
        public 전지현(T x)
        {
            this.x = x;
        }
    }
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            이윤환 a = new 이윤환();
            a.Collect = new 전지현<string>[] { new 전지현<string>("아 "), new 전지현<string>("머라는거야"), new 전지현<string>(" 병신아!!!") };

            IEnumerator ie = a.Collect.GetEnumerator();

            while (ie.MoveNext())
            {
                Response.Write(((전지현<string>)ie.Current).x);
            }

            Response.Write(" 아 짜증나!");
        }
    }
}

namespace WebApplication1
{
    public class 이윤환
    {
        public 전지현[] Collect;
    }

    public class 전지현
    {
        public string x;
        public 전지현(string x)
        {
            this.x = x;
        }
    }
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            이윤환 a = new 이윤환();
            a.Collect = new 전지현[] { new 전지현("아 "), new 전지현("머라는거야"),new 전지현(" 병신아!!!") };

            IEnumerator ie = a.Collect.GetEnumerator();

            while (ie.MoveNext())
            {
                Response.Write(((전지현)ie.Current).x);
            }

            Response.Write(" 아 짜증나!");
        }
    }
}

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        string sqlconn = "provider=SQLOLEDB.1;" + "uid=sa;pwd=1;database=My;data source=localhost";
        string sqlsel = "select * from Myname order by uid asc";       
        OleDbConnection odc;
        OleDbCommand odm;
        OleDbDataAdapter oda;
        OleDbCommandBuilder builder;

        public Form1()
        {
            InitializeComponent();
        }

        private void db_open()
        {           
            OleDbConnection odc = new OleDbConnection();
            odc.ConnectionString = sqlconn;
            odc.Open();           
        }

        private void db_comm()
        {
            odc = new OleDbConnection();
            odc.ConnectionString = sqlconn;  
        
            odm = new OleDbCommand();
            odm.Connection = odc;
            odm.CommandText = sqlsel;
            odm.CommandType = CommandType.Text;
        }     
       
        private void button1_Click(object sender, EventArgs e)
        {
            db_open();
            db_comm();

            odc = new OleDbConnection();
            odc.ConnectionString = sqlconn;

            odm = new OleDbCommand();
            odm.Connection = odc;
            odm.CommandText = sqlsel;
            odm.CommandType = CommandType.Text;
            oda = new OleDbDataAdapter();
            oda.SelectCommand = odm;

            DataSet DS = new DataSet();

            oda.Fill(DS, "Name");

            dataGridView1.DataSource = DS.Tables["Name"].DefaultView;
        }

        private void button2_Click(object sender, EventArgs e)
        {
            string txtMag = textBox1.Text.Trim();
           
            db_open();

            oda = new OleDbDataAdapter(sqlsel, sqlconn);
            builder = new OleDbCommandBuilder(oda);

            DataSet DS = new DataSet();

            oda.Fill(DS, "Name");

            DataRow DR = DS.Tables["Name"].NewRow();

            DR["Name"] = txtMag;

            DS.Tables["Name"].Rows.Add(DR);

            oda.Update(DS, "Name");
            DS.Clear();

            oda.Fill(DS, "Name");

            dataGridView1.DataSource = DS.Tables["Name"].DefaultView;
        }

        private void button3_Click(object sender, EventArgs e)
        {
            string txtMag = textBox1.Text.ToString();

            oda = new OleDbDataAdapter(sqlsel, sqlconn);
            builder = new OleDbCommandBuilder(oda);

            DataSet DS = new DataSet();
            oda.Fill(DS, "Name");

            int index = dataGridView1.CurrentCell.RowIndex;
            DataRow DR = DS.Tables["Name"].Rows[index];

            DR.BeginEdit();
            DR["Name"] = txtMag;
            DR.EndEdit();

            oda.Update(DS.GetChanges(DataRowState.Modified), "Name");
            DS.AcceptChanges();

            DS.Clear();
            oda.Fill(DS, "Name");
            dataGridView1.DataSource = DS.Tables["Name"].DefaultView;
        }
    }
}


얌전히 sqlconnection 이나 씁시다 ;;

namespace ConsoleApplication1
{
    class Program
    {
        public delegate void dele();

        public static void a()
        {
            Console.WriteLine("아");
        }

        public static void b()
        {
            Console.WriteLine("배가");
        }

        public static void c()
        {
            Console.WriteLine("고파요");
        }

        static void Main(string[] args)
        {
            dele[] ba = { a, b, c };

            --아래 두가지 방법 중 하나로 해도 됨

            for (int i = 0; i < ba.Length; i++)
            {
                dele bbb = new dele(ba[i]);
                bbb();
            }

            //dele d1 = new dele(a);
            //dele d2 = new dele(b);
            //dele d3 = new dele(c);

            //d1 += d2;
            //d1 += d3;

            //d1();
            -- 이렇게 넣어도 됨...
        }
    }
}

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            string sqlconn = "server=localhost;database=MyDB;uid=sa;pwd=1";
            SqlConnection scn;

            Console.WriteLine("진행할 작업을 선택해주세요.");
            Console.WriteLine("1. 전체보기");
            Console.WriteLine("2. 입력하기");
            string choice = Console.ReadLine();

            if (choice == "1")
            {
                string sqlquery = "select * from MyTable";
                scn = new SqlConnection(sqlconn);
                scn.Open();
                SqlCommand scm = new SqlCommand(sqlquery, scn);
                SqlDataReader sdr = scm.ExecuteReader();

                while (sdr.Read())
                {
                    for (int i = 0; i < sdr.FieldCount; i++)
                    {
                        Console.WriteLine(sdr[i]+":");
                    }
                    Console.WriteLine("출력완료.");
                }
            }
            else if (choice == "2")
            {
                Console.WriteLine("번호입력");
                int name = Int32.Parse(Console.ReadLine());
                Console.WriteLine("ID 입력");
                string id = Console.ReadLine();
                Console.WriteLine("비번 입력");
                string pass = Console.ReadLine();

                string sqlquery = "insert into MyTable values(" + name + "," + "'" + id + "'" + "," + "'" + pass + "'" + ")";
                scn = new SqlConnection(sqlconn);
                scn.Open();

                SqlCommand scm = new SqlCommand(sqlquery, scn);
                scm.ExecuteNonQuery();
                Console.WriteLine("입력 완료.");
            }
        }
    }
}


코드를 보면 알 수 있으니 디비 백업본은 별도로 첨부 안함

public partial class _Default : System.Web.UI.Page
{
    private string sqlconn = "server=localhost;database=MYWEB;uid=sa;pwd=1";
    private StringBuilder sb;
    //protected string cut_Catename(string CATENAME)
    //{
    //    #region 카테고리 명을 받아서 [사용][미사용]글자를 잘라서 카테고리 명만 반환하는 메소드
    //    string rtnval = "";

    //    int leng = CATENAME.Length - 5;
    //    rtnval = CATENAME.Substring(0, leng);

    //    return rtnval;
    //    #endregion
    //}
    protected string Cut_CateName()
    {
        int a = lbCate1.SelectedItem.Text.IndexOf("[");
        string temp = lbCate1.SelectedItem.Text.Remove(a);
        return temp;
    }

    protected void Page_Load(object sender, EventArgs e)
    {       
        if (!IsPostBack)
        {
            this.get_data_binding();
        }
    }

    protected void get_data_binding()
    {
        #region 데이터를 리스트박스에 넣어주는 메소드
        string sqlquery = "SELECT CATE_IDX,  ";
        sqlquery += " CATE_NAME +'   ['+(CASE IS_USE WHEN 'Y' ";
        sqlquery += " THEN '사용중' ELSE '미사용' END)+']' AS [CATE_NAME] ";
        sqlquery += " FROM T_CATEGORY ";
        sqlquery += " WHERE PARENT_CATE_IDX = '00000000'";

        SqlConnection scn = new SqlConnection(sqlconn);

        DataSet DS = new DataSet();

        SqlDataAdapter sda = new SqlDataAdapter(sqlquery, sqlconn);
        sda.Fill(DS, "cate1");

        this.lbCate1.DataSource = DS.Tables["CATE1"].DefaultView;
        this.lbCate1.DataTextField = "CATE_NAME";
        this.lbCate1.DataValueField = "CATE_IDX";
        this.lbCate1.DataBind();
        #endregion
    }

    protected bool CheckingData(string check)
    {
        bool result = false;
        sb = new StringBuilder();
        sb.Append("SELECT count(*)");
        sb.Append(" FROM T_CATEGORY ");
        sb.Append(" WHERE CATE_NAME = '" + check + "'");
        SqlConnection scn = new SqlConnection(sqlconn);
        SqlDataAdapter sda = new SqlDataAdapter(sb.ToString(), sqlconn);
        DataSet ds = new DataSet();
        sda.Fill(ds);
        foreach (DataRow dr in ds.Tables["table"].Rows)
        {
            if (dr[0].ToString() == "1")
                result = true;
            else
                result = false;
        }
        scn.Close();
        return result;
    }

    protected void manager(string message)
    {
        ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "GB", "javascript:alert('" + message + "');", true);
    }

    protected void btnInsertCate1_Click(object sender, EventArgs e)
    {
        try
        {
            SqlConnection scn = new SqlConnection(sqlconn);
            SqlCommand scm;

            #region 수정 후 선택한 리스트아이템을 이름 바꿔주는 메소드
            if (this.CheckBox1.Checked)
            {
                this.hidCateVal.Value = Cut_CateName();
               
                //string lbcate = cut_Catename(this.lbCate1.SelectedItem.Text);
                //string lbcate = Cut_CateName();
                //string sqlquery2 = "UPDATE T_CATEGORY SET CATE_NAME =" + "'" + this.txtCate1.Text.Trim() + "'" + " WHERE CATE_NAME = " + "'" + lbcate.Trim() + "'";
                string sqlquery2 = "UPDATE T_CATEGORY SET CATE_NAME =" + "'" + this.txtCate1.Text.Trim() + "'" + " WHERE CATE_NAME = " + "'" + this.hidCateVal.Value.Trim() + "'";
               
                scm = new SqlCommand(sqlquery2, scn);
                scn.Open();

                int rs = scm.ExecuteNonQuery();

                scn.Close();

                if (rs == 1)
                {
                    Response.Redirect("./Default.aspx");
                }
                else
                {
                    Response.Write(sqlquery2);
                }
            }

            #endregion
            #region 1차 카테고리를 리스트 박스에 넣어주는 메소드
            else
            {
                string strInsert = "INSERT INTO T_CATEGORY";
                strInsert += " SELECT ISNULL(MAX(CATE_IDX),10000000)+1";
                strInsert += ",'" + this.txtCate1.Text.Trim() + "','00000000','Y'";
                strInsert += " FROM T_CATEGORY";

                scn.Open();
                scm = new SqlCommand(strInsert, scn);

                int result = scm.ExecuteNonQuery();
                scn.Close();

                if (result == 1)
                {
                    Response.Redirect("./Default.aspx");
                }
                else
                {
                    Response.Write("실패했습니다.");
                }
            #endregion
            }
        }
        catch (Exception ex)
        {
            manager("카테고리가 중복되었습니다\\n다른내용을 입력하세요");
        }
    }
    protected void lbCate1_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (this.CheckBox1.Checked)
        {
            this.txtCate1.Text = Cut_CateName();
        }
    }
    protected void btnChange_Click(object sender, EventArgs e)
    {
        #region 사용/미사용을 바꿔주는 메소드
        for (int i = 0; i < this.lbCate1.Items.Count; i++)
        {
            if (this.lbCate1.Items[i].Selected == true)
            {
                string strSelVal = this.lbCate1.Items[i].Value;
                //선택된 항목의 CATE_IDX 값을 얻어온 뒤에
                string sqlquery = "update T_CATEGORY";
                sqlquery += " SET IS_USE = CASE IS_USE WHEN 'Y' THEN 'N' ELSE 'Y' END";
                sqlquery += " WHERE CATE_IDX = '" + strSelVal + "'";

                SqlConnection scn = new SqlConnection(sqlconn);
                SqlCommand scm = new SqlCommand(sqlquery, scn);
                scn.Open();

                int intresult = scm.ExecuteNonQuery();
                scn.Close();

                if (intresult == 1)
                {
                    Response.Redirect("./Default.aspx");
                }
                else
                {
                    Response.Write("실패하였습니다.");
                }
            }
        }
        #endregion
    }
    protected void CheckBox1_CheckedChanged(object sender, EventArgs e)
    {
        #region 체크박스(수정)을 눌렀을 때 텍스트박스 내용을 수정하는 메소드
        if (this.CheckBox1.Checked)
        {
            this.btnInsertCate1.Text = "1차 카테고리 수정";

            this.txtCate1.Text = Cut_CateName();
        }
        else
        {
            this.btnInsertCate1.Text = "1차 카테고리; 등록";
            this.txtCate1.Text = "";
        }
        #endregion
    }
}

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>제목 없음</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
     <table width="100%" cellpadding="5" cellspacing="2" bgcolor="#f0f0f0">
        <tr>
            <td background="#ffffff" width="50%"><p style="font-family:돋움; font-size:20px; font-weight:bold;">1차 카테고리 리스트</p></td>
            <td width="50%"><p style="font-family:돋움; font-size:20px; font-weight:bold;">1차 카테고리 등록</p></td>
        </tr>
        <tr>
            <td bgcolor="#ffffff">
                <table>
                    <tr>
                        <td>
                            <asp:ListBox ID="lbCate1" AutoPostBack="true" runat="server" Width="250" Height="300"
                                onselectedindexchanged="lbCate1_SelectedIndexChanged">
                            </asp:ListBox>
                            <br />
                            <asp:Button ID="btnChange" runat="server" Text="사용여부변경"
                                onclick="btnChange_Click" />
                        </td>
                    </tr>
                </table>
            </td>
            <td bgcolor="#ffffff">1차 : <asp:TextBox ID="txtCate1" runat="server" BorderStyle="Solid" BorderWidth="1px" Width="250"></asp:TextBox>&nbsp;<asp:Button
                    ID="btnInsertCate1" runat="server" Text="1차 카테고리 등록"
                    onclick="btnInsertCate1_Click" />
                <br />
                <asp:Label ID="Label1" runat="server"></asp:Label>
                    <asp:CheckBox ID="CheckBox1" AutoPostBack="true" runat="server"
                    oncheckedchanged="CheckBox1_CheckedChanged" />
                    </td>
        </tr>
    </table>
    <input type = "hidden" id="hidCateVal" runat="server" />
    </div>
    </form>
</body>
</html>

namespace ADONET_FinalTest
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void TextBoxClear()
        {
            txtName.Clear();
            txtMail.Clear();
            txtPhone.Clear();
            txtName.Focus();
        }

        private void btnDAOpen_Click(object sender, EventArgs e)
        {
            string oleconnection = "provider=Microsoft.JET.OLEDB.4.0;" + "data source= "
                + Application.StartupPath + @"\member.mdb";
            string sqlquery = "SELECT * FROM member";

            OleDbDataAdapter oleadapter = new OleDbDataAdapter(sqlquery, oleconnection);
            DataSet DS = new DataSet();

            oleadapter.Fill(DS, "member");
            dataGridView1.DataSource = DS.Tables["member"].DefaultView;
        }

        private void btnCCBtn_Click(object sender, EventArgs e)
        {
            OleDbConnection oleconn = new OleDbConnection();
            oleconn.ConnectionString = "provider=Microsoft.JET.OLEDB.4.0;" + "data source= "
                + Application.StartupPath + @"\member.mdb";
            oleconn.Open();

            OleDbCommand olecom = new OleDbCommand();
            olecom.Connection = oleconn;
            olecom.CommandText = "SELECT * FROM member";           

            OleDbDataAdapter oleadapter = new OleDbDataAdapter();
            oleadapter.SelectCommand = olecom;

            DataSet DS = new DataSet();

            oleadapter.Fill(DS, "member");
            dataGridView1.DataSource = DS.Tables["member"].DefaultView;
        }

        private void btnInput_Click(object sender, EventArgs e)
        {
            if (dataGridView1.CurrentCell != null)
            {
                //string oleconnection = "provider=Microsoft.JET.OLEDB.4.0;" + "data source= "
                //    + Application.StartupPath + @"\member.mdb";
                //string sqlquery = "SELECT * FROM member";

                //OleDbDataAdapter oleadapter = new OleDbDataAdapter(sqlquery, oleconnection);
                OleDbConnection oleconn = new OleDbConnection();
                oleconn.ConnectionString = "provider=Microsoft.JET.OLEDB.4.0;" + "data source= "
                    + Application.StartupPath + @"\member.mdb";
                oleconn.Open();

                OleDbCommand olecom = new OleDbCommand();
                olecom.Connection = oleconn;
                olecom.CommandText = "SELECT * FROM member";

                OleDbDataAdapter oleadapter = new OleDbDataAdapter();
                oleadapter.SelectCommand = olecom;
                OleDbCommandBuilder builder = new OleDbCommandBuilder(oleadapter);
                DataSet DS = new DataSet();

                oleadapter.Fill(DS, "member");

                DataRow DR = DS.Tables["member"].NewRow();

                DR["uName"] = txtName.Text.Trim();
                DR["uMail"] = txtMail.Text.Trim();
                DR["uPhone"] = txtPhone.Text.Trim();

                DS.Tables["member"].Rows.Add(DR);

                oleadapter.Update(DS, "member");

                DS.Clear();
                oleadapter.Fill(DS, "member");

                dataGridView1.DataSource = DS.Tables["member"].DefaultView;

                TextBoxClear();
            }
        }

        private void btnDRBtn_Click(object sender, EventArgs e)
        {
            //OleDbConnection oleconn = new OleDbConnection();
            //oleconn.ConnectionString = "provider=Microsoft.JET.OLEDB.4.0;" + "data source= "
            //    + Application.StartupPath + @"\member.mdb";
            //oleconn.Open();

            //OleDbCommand olecom = new OleDbCommand();
            //olecom.Connection = oleconn;
            //olecom.CommandText = "SELECT * FROM member";
            OleDbConnection oleconn = new OleDbConnection();
            oleconn.ConnectionString = "provider=Microsoft.JET.OLEDB.4.0;" + "data source= "
                + Application.StartupPath + @"\member.mdb";
            oleconn.Open();

            OleDbCommand olecom = new OleDbCommand();
            olecom.Connection = oleconn;
            olecom.CommandText = "SELECT * FROM member";

            //OleDbDataAdapter oleadapter = new OleDbDataAdapter();
            //oleadapter.SelectCommand = olecom;

            OleDbDataReader odr = olecom.ExecuteReader();

            string result;
            while (odr.Read())
            {
                result = odr.GetInt32(0) + " "
                    + odr.GetString(1) + " "
                    + odr.GetString(2) + " "
                    + odr.GetString(3) + " ";
                MessageBox.Show(result);
            }
        }

        private void btnChange_Click(object sender, EventArgs e)
        {
            if (dataGridView1.DataSource != null)
            {
                string oleconn = "provider=microsoft.JET.OLEDB.4.0;" + "data source= "
                    + Application.StartupPath + @"\member.mdb";
                string sqlquery = "SELECT * FROM member";

                OleDbDataAdapter oleadapter = new OleDbDataAdapter(sqlquery, oleconn);
                OleDbCommandBuilder builder = new OleDbCommandBuilder(oleadapter);
                DataSet DS = new DataSet();

                oleadapter.Fill(DS, "member");

                int index = dataGridView1.CurrentCell.RowIndex;
                DataRow DR = DS.Tables["member"].Rows[index];
               
                DR.BeginEdit();
                DR["uName"]=txtName.Text.Trim();
                DR["uMail"]=txtMail.Text.Trim();
                DR["uPhone"]=txtPhone.Text.Trim();
                DR.EndEdit();

                oleadapter.Update(DS.GetChanges(DataRowState.Modified), "member");
                DS.AcceptChanges();

                DS.Clear();
                oleadapter.Fill(DS, "member");
                dataGridView1.DataSource = DS.Tables["member"].DefaultView;

                TextBoxClear();
            }
        }

        private void btnDel_Click(object sender, EventArgs e)
        {
            if (dataGridView1.CurrentCell != null)
            {
                string oleconn = "provider=microsoft.JET.OLEDB.4.0;" + "data source= "
                    + Application.StartupPath + @"\member.mdb";
                string sqlquery = "SELECT * FROM member";

                OleDbDataAdapter oleadapter = new OleDbDataAdapter(sqlquery, oleconn);
                OleDbCommandBuilder builder = new OleDbCommandBuilder(oleadapter);
                DataSet DS = new DataSet();

                oleadapter.Fill(DS, "member");

                int index = dataGridView1.CurrentCell.RowIndex;
                DataRow DR = DS.Tables["member"].Rows[index];
                DR.Delete();               

                oleadapter.Update(DS.GetChanges(DataRowState.Deleted), "member");
                DS.AcceptChanges();

                DS.Clear();
                oleadapter.Fill(DS, "member");
                dataGridView1.DataSource = DS.Tables["member"].DefaultView;

                TextBoxClear();
            }
        }
    }
}


주석 처리 해놓은 것은 데이터를 가져올 때 두가지 방식이 있는데, 둘 모두 가능하다는 것임. 다만, 둘 모두 한번에 사용은 할 필요가 없음.

namespace DataSet
{
    public partial class Form1 : Form
    {
        DataTable dt;
        DataRow dr;
        public Form1()
        {
            InitializeComponent();
        }

        private void textBox1_TextChanged(object sender, EventArgs e)
        {

        }

        private void textBox2_TextChanged(object sender, EventArgs e)
        {

        }
        /// <summary>
        /// 데이터 테이블을 사용해서 메모리 테이블을 생성하고 컬럼을 추가시키는 역할
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Create_Table_Click(object sender, EventArgs e)
        {
            dt = new DataTable("Result");
            dt.Columns.Add("uName", Type.GetType("System.String"));
            dt.Columns.Add("uKor", Type.GetType("System.String"));
            dt.Columns.Add("uEng", Type.GetType("System.String"));
            dt.Columns.Add("uMath", Type.GetType("System.String"));
            dt.Columns.Add("uAvg", Type.GetType("System.String"));

            dataGridView1.DataSource = dt;
        }
        /// <summary>
        /// 추가된 컬럼에 행을 추가해서 행마다 값을 집어넣는 역할
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Add_Data_Click(object sender, EventArgs e)
        {
            DataRow dr = dt.NewRow();
            dr[0] = textBox1.Text;
            dr[1] = float.Parse(textBox2.Text);
            dr[2] = float.Parse(textBox3.Text);
            dr[3] = float.Parse(textBox4.Text);
            dr[4] = (float.Parse(textBox2.Text) + float.Parse(textBox3.Text) + float.Parse(textBox4.Text)) / 3;
            dt.Rows.Add(dr);
        }
        /// <summary>
        /// i값 for문을 사용해서 값을 증가시키고(즉 열을 증가시키면서 선택된 행값을 찾아 그 부분을 수정
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Mod_Data_Click(object sender, EventArgs e)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (textBox1.Text == dt.Rows[i][0].ToString())
                {
                    dt.Rows[i][0] = textBox1.Text;
                    dt.Rows[i][1] = float.Parse(textBox2.Text);
                    dt.Rows[i][2] = float.Parse(textBox3.Text);
                    dt.Rows[i][3] = float.Parse(textBox4.Text);
                    dt.Rows[i][4] = (float.Parse(textBox2.Text) + float.Parse(textBox3.Text) + float.Parse(textBox4.Text)) / 3;
                }
            }
        }
        /// <summary>
        /// 위와 마찬가지로 선택된 행값을 찾아서 그 행을 삭제함
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Del_Data_Click(object sender, EventArgs e)
        {
            try
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    if (dt.Rows[i][0].ToString() == dataGridView1.CurrentRow.Cells[0].Value.ToString())
                    {
                        dt.Rows[i].Delete();
                    }
                }
            }
            catch (Exception ee)
            {
                MessageBox.Show("데이터가 없는 칸은 삭제할 수 없습니다.");
            }
        }
        /// <summary>
        /// 모든 열과 행을 삭제시키고 메모리 할당을 해제시킴
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Del_Alldata_Click(object sender, EventArgs e)
        {
            try
            {
                dataGridView1.DataSource = null;
                dt.Dispose();
            }
            catch (Exception ee)
            {
                MessageBox.Show("입력된 값이 없습니다.");
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if(textBox1.Text == dt.Rows[i][0].ToString())                   
                {
                    dt.Rows[i].Delete();
                }
            }
        }
    }
}

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            //테이블 생성
            DataTable table = new DataTable("member");

            //테이블에 컬럼 생성
            DataColumn col = new DataColumn();
            col.DataType = Type.GetType("System.String");
            col.Caption = "이름";
            col.ColumnName = "Name";
            table.Columns.Add(col); //Name컬럼 등록

            DataRow row = table.NewRow();
            //Detached 메시지 출력
            Console.WriteLine("레코드 상태 {0}", row.RowState.ToString());

            table.Rows.Add(row);
            //Added 메시지 출력
            Console.WriteLine("레코드 상태 {0}", row.RowState.ToString());

            table.AcceptChanges();
            //Unchanged 메시지 출력
            Console.WriteLine("레코드 상태 {0}",row.RowState.ToString());

            row["Name"] = "이윤환";
            //Modified 메시지 출력
            Console.WriteLine("레코드 상태 {0}",row.RowState.ToString());

            row.Delete();
            //Deleted 메시지 출력
            Console.WriteLine("레코드 상태 {0}",row.RowState.ToString());

            row.AcceptChanges();
        }
    }
}