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() }); } } }