private void RefreshDataGrid()
{
string query = "SELECT ID, NAME, AUTH, PASSWORD FROM TB_MEMBERS";
using (DataTable dt = DBSqlite.GetSelectData(query))
{
if (dt.Rows.Count > 0)
{
MemberCollection.Clear();
foreach (DataRow dr in dt.Rows)
{
members user = new members()
{
IsSelect = false,
ID = dr["ID"].ToString(),
NAME = dr["NAME"].ToString(),
AUTH = dr["AUTH"].ToString(),
PASSWORD = dr["PASSWORD"].ToString()
};
MemberCollection.Add(user);
}
}
}
}
private void updateMember()
{
MemberCollection.Clear();
string csvText;
using (StreamReader streamReader = new StreamReader("./member.txt", Encoding.GetEncoding("UTF-8")))
{
csvText = streamReader.ReadToEnd();
}
using (StringReader stringReader = new StringReader(csvText))
{
while (stringReader.Peek() > -1)
{
MemberCollection.Add(new Person {
Name = stringReader.ReadLine()
});
}
}
}
