public DataTable GetBestPictures() { HollywoodDBConnect aHollywoodConn = new HollywoodDBConnect(); try { return(aHollywoodConn.GetTable("spBestMovies", CommandType.StoredProcedure)); } catch (Exception ex) { LastError = ex.Message; return(null); } }
public DataTable GetActors(int mID) { HollywoodDBConnect aHollywoodConn = new HollywoodDBConnect(); SqlParameter param = new SqlParameter("@MovieID", SqlDbType.Int); param.Value = mID; try { return(aHollywoodConn.GetTable("SELECT Actors.LastName, Actors.FirstName, Actors.DateOfBirth FROM Actors INNER JOIN Roles ON Actors.ActorID = Roles.ActorID WHERE MovieID = @MovieID", CommandType.Text, param)); } catch (Exception ex) { LastError = ex.Message; return(null); } }