public ArrayList Select() { ArrayList resultList = null; Database db = new Database(DataBaseInfo.RealDBInfo()); Hashtable resultMap = db.GetReader("select bNo, bTitle, bContents, delYn, CONVERT(CHAR(10), GETDATE(), 111)regDate from [Board];"); if (Convert.ToInt32(resultMap["MsgCode"]) == -1) { Console.WriteLine(resultMap["Msg"].ToString()); } else { resultList = (ArrayList)resultMap["Data"]; } return(resultList); }
public ArrayList Views() { ArrayList list = new ArrayList(); ArrayList resultList = null; Database db = new Database(DataBaseInfo.RealDBInfo()); // 실제 RealDBInfo로 바꾸면 됨. Hashtable resultMap = db.GetReader("select bNo, bTitle, bContents from [Board];"); // 쿼리만 가변적으로 바뀌면 가능! if (Convert.ToInt32(resultMap["MsgCode"]) == -1) { Console.WriteLine(resultMap["Msg"].ToString()); } else { resultList = (ArrayList)resultMap["Data"]; //foreach (var row in resultList) //{ // list.Add(row); //} } return(resultList); }