public ShowItem GetShowItem(int showNo) { SQLiteCommand query = new SQLiteCommand(); query.CommandText = "SELECT show_no, date, show_name, show_comment FROM [" + Year + "_show] WHERE show_no = @noparam;"; query.CommandType = System.Data.CommandType.Text; query.Parameters.Add(new SQLiteParameter("@noparam", showNo)); query.Connection = ClubConn; SQLiteDataReader reader = DoTheReader(query); ShowItem item = new ShowItem(); while (reader.Read()) { item.No = reader.GetInt32(0); item.Date = StringToDate(reader.GetString(1)); item.Name = reader.GetString(2); item.Comments = reader.GetString(3); } reader.Close(); ClubConn.Close(); return item; }
// Optional: sort (default is date) public List<ShowItem> GetShowItemList(ShowSort sort = ShowSort.Default) { // Case statment for sort column string sortString; switch(sort) { case ShowSort.Number: sortString = "show_no"; break; case ShowSort.Name: sortString = "show_name"; break; default: sortString = "date"; break; } string query = "SELECT show_no, date, show_name, show_comment FROM [" + Year + "_show] ORDER BY " + sortString + ";"; SQLiteDataReader reader = DoTheReader(ClubConn, query); List<ShowItem> showItemList = new List<ShowItem>(); ShowItem item; reader = DoTheReader(ClubConn, query); while (reader.Read()) { item = new ShowItem(); item.No = reader.GetInt32(0); item.Date = StringToDate(reader.GetString(1)); item.Name = reader.GetString(2); item.Comments = reader.GetString(3); showItemList.Add(item); } reader.Close(); ClubConn.Close(); return showItemList; }
// Optional: sort (default is date) public List<ShowItem> GetShowItemList(string database, int year, string sort) { MySqlDataReader reader; ShowItem item; List<ShowItem> showItemList = new List<ShowItem>(); if (sort == String.Empty) sort = "date"; reader = GetReader(database, year + "_show", "show_no, date, show_name, show_comment", String.Empty, sort); while(reader.Read()) { item = new ShowItem(); item.no = reader.GetInt32(0); item.date = reader.GetDateTime(1); item.name = reader.GetString(2); item.comments = reader.GetString(3); showItemList.Add(item); } reader.Close(); connection.Close(); return showItemList; }
public ShowItem GetShowItem(string database, int year, int showNo) { MySqlDataReader reader; ShowItem item = new ShowItem(); reader = GetReader(database, year + "_show", "show_no, date, show_name, show_comment", "show_no=" + showNo, "date"); while (reader.Read()) { item.no = reader.GetInt32(0); item.date = reader.GetDateTime(1); item.name = reader.GetString(2); item.comments = reader.GetString(3); } reader.Close(); connection.Close(); return item; }