public void FillAllCombobox() { try { var db = new SQLDatabaseHelper(); DataTable recipe; String query = "SELECT * FROM TypeSentence"; recipe = db.GetDataTable(query); if (recipe != null) { foreach (DataRow r in recipe.Rows) { cbbType.Items.Add(r["Description"].ToString()); } } query = "SELECT * FROM People"; recipe = db.GetDataTable(query); if (recipe != null) { foreach (DataRow r in recipe.Rows) { cbbPeople.Items.Add(r["RealName"].ToString()); cbbAuthor.Items.Add(r["RealName"].ToString()); } } } catch (Exception fail) { String error = "The following error has occurred:\n\n"; error += fail.Message.ToString() + "\n\n"; } }
public void ShowData(int type, int people, int author) { try { var db = new SQLDatabaseHelper(); DataTable recipe; String query = "SELECT s.ID,s.Sentence AS 'Câu',t.Description AS 'Kiểu câu',p.RealName AS 'Viết cho',s.Author AS 'Người viết' " + "FROM Sentence s, TypeSentence t, People p " + "WHERE (s.TypeId = t.ID AND s.PeopleId = p.ID"; if (type != 0) { query += " AND s.TypeId =" + type; } if (people != 0) { query += " AND s.PeopleId =" + people; } if (author != 0) { query += " AND s.Author =" + author; } query += ")"; recipe = db.GetDataTable(query); dgvSentence.DataSource = recipe; } catch (Exception fail) { String error = "The following error has occurred:\n\n"; error += fail.Message.ToString() + "\n\n"; } }
public string getStringPeople(int Id) { string result = ""; try { var db = new SQLDatabaseHelper(); DataTable recipe; String query = "SELECT * FROM People WHERE ID =" + Id; recipe = db.GetDataTable(query); if (recipe != null) { foreach (DataRow r in recipe.Rows) { result = (string)r["RealName"]; } } } catch (Exception fail) { String error = "The following error has occurred:\n\n"; error += fail.Message.ToString() + "\n\n"; } return(result); }
public int getIDPeople(string str) { if (str == "") { return(0); } int result = 1; try { var db = new SQLDatabaseHelper(); DataTable recipe; String query = "SELECT * FROM People WHERE RealName LIKE N'%" + str + "%'"; recipe = db.GetDataTable(query); if (recipe != null) { foreach (DataRow r in recipe.Rows) { result = (int)r["ID"]; } } } catch (Exception fail) { String error = "The following error has occurred:\n\n"; error += fail.Message.ToString() + "\n\n"; } return(result); }