private void RefreshDataGrid()
{
// 데이터 requery
DataSet ds = mind.GetDataSet("Select id as '일련번호(Id)', name as '이름(name)', " +
"email as 'email(이메일)', birthdate as '생년월일(birthdate)'," +
"phone as '연락처(phone)', type as '구분(family Type)' " +
"from member order by id", "member");
this.dataGridView1.DataSource = ds;
this.dataGridView1.DataMember = "member";
this.dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
this.dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
}
public void RefreshDataGrid()
{
// DataGridView
DataSet ds = mind.GetDataSet("select id as '일련번호(ID)', subject as '제목(Subject)', " +
"firstdate as '등록일자(regidate)', comdate as '답변일자(comment Date)', clientID from counsel_table " +
"where memberID = " + txt_ID.Text +
" order by id", "counsel_table");
this.dataGridView.DataSource = ds;
this.dataGridView.DataMember = "counsel_table";
this.dataGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
this.dataGridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
}
