|
↓
namespace MakeTable
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
| private DataTable dt; //전역변수 |
private void tblPeople_Click(object sender, EventArgs e)
{
dt = MakePeopleTable();
dataGridView1.DataSource = dt;
} |
/// <summary>
/// 오름차순,내림차순 정렬 후 리스트 박스 출력
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
///
private void DisplayResult(DataRow[] Result)
{
lstDisplay.Items.Clear();
foreach (DataRow R in Result)
{
lstDisplay.Items.Add(R["Name"]);
}
}
//오름차순
private void btnAsc_Click(object sender, EventArgs e)
{
//Select메서드 사용
DataRow[] Result = dt.Select("", "Name Asc");
DisplayResult(Result); //출력
}
//내림차순
private void btnDesc_Click(object sender, EventArgs e)
{
//Select메서드 사용
DataRow[] Result = dt.Select("", "Name Desc");
DisplayResult(Result); //출력
}
//의 나이 이름 조사
private void btnAge_Click(object sender, EventArgs e)
{
string name = txtAge.Text;
DataRow Result = dt.Rows.Find(name);
if (Result ==null)
{
MessageBox.Show("해당사람이 없습니다");
}
else
{
MessageBox.Show
(name + "의 나이 :" + Result["Age"].ToString());
}
}
//살 이상인 사람들 조사
private void btnName_Click(object sender, EventArgs e)
{
DataRow[] Result = dt.Select("Age >=" + txtName.Text);
DisplayResult(Result);
}
/// <summary>
/// 삭제, Accept, 새로변경, Reject 클릭이벤드
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
///삭제
private void btnDelete_Click(object sender, EventArgs e)
{
DataRow[] arr = dt.Select("Name ='" + txtDelete.Text + "'");
if (arr.Length != 0)
{
arr[0].Delete(); //삭제
}
this.dataGridView1.DataSource = dt;
}
//Accept
private void btnAccept_Click(object sender, EventArgs e)
{
dt.AcceptChanges(); //변경완료
}
//새로변경
private void btnNewChange_Click(object sender, EventArgs e)
{
DataRow[] arr = dt.Select("Name = '" + txtChangeAge.Text + "'");
if (arr.Length != 0)
{
arr[0]["Age"] = Convert.ToInt32(txtNewChange.Text);
}
}
//Reject
private void btnReject_Click(object sender, EventArgs e)
{
dt.RejectChanges(); //변경취소
}
}
}
| 
MakeTable0929.zip