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 GetQuestion() { string query = "SELECT QUESTION_ID, QUESTION_USER_ID, QUESTION_TEXT, ROW_INDEX FROM TB_USER_QUESTION"; using (DataTable dt = DBSqlite.GetSelectData(query)) { if (dt.Rows.Count > 0) { QuestionCollection.Clear(); foreach (DataRow dr in dt.Rows) { question Question = new question() { QUESTION_ID = dr["QUESTION_ID"].ToString(), QUESTION_USER_ID = dr["QUESTION_USER_ID"].ToString(), QUESTION_TEXT = dr["QUESTION_TEXT"].ToString(), ROW_INDEX = (int)dr["ROW_INDEX"] }; QuestionCollection.Add(Question); } } } }
//유저 아이디 판별 private bool ConfirmUserID(members newUser) { string query = "SELECT ID FROM TB_MEMBERS WHERE ID = '" + newUser.ID + "'"; using (DataTable dt = DBSqlite.GetSelectData(query)) { if (dt.Rows.Count <= 0) { return(true); } } return(false); }
private void ComboBoxBinding() { Members = new ObservableCollection <members>(); string qeury = "SELECT ID, NAME FROM TB_MEMBERS"; using (DataTable dt = DBSqlite.GetSelectData(qeury)) { foreach (DataRow dr in dt.Rows) { Members.Add(new members() { ID = dr["ID"].ToString(), NAME = dr["NAME"].ToString() }); } } }
private bool LoginConfirmation(string userID, string userPassWord) { string query = "SELECT * from TB_MEMBERS WHERE ID = '" + userID + "' AND PASSWORD = '******'"; using (DataTable dt = DBSqlite.GetSelectData(query)) { if (dt.Rows.Count > 0) { Application.Current.Resources["id"] = userID; return(true); } else { return(false); } } }