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);
}
}
