Line 39: {
Line 40: dbCmdRetrieve = new OleDbCommand("SELECT gid, tblPhotoGalleries.cid, gname, gdescription, postdate, tblPhotoGalleries.updatedate, cname FROM tblPhotoGalleries, tblCommittees WHERE tblPhotoGalleries.cid IS NOT NULL AND tblPhotoGalleries.cid = tblCommittees.cid AND yid = ? ORDER BY tblCommittees.cid ASC, tblPhotoGalleries.updatedate DESC, gid ASC", dbConn);
Line 41: dbCmdRetrieve.Parameters.Add("@yid", OleDbType.Integer).Value = Int32.Parse(Session[SessionState.strSchoolYear].ToString());
Line 42: }
Line 43: else
|