Example #1
0
        public static List <Bid> FindLowestBid(int id)       //find the lowest bid for a specific gig
        {
            // string sql = @"SELECT * FROM dbo.bids WHERE GigId = @OwnerId";
            string sql = @"SELECT MIN(Price) AS Price FROM dbo.bids WHERE GigId = @Id";

            return(SqlDataAccess.LoadNum <Bid>(sql, id));
        }