I am having a hard time doing a 'review a book' function in my web application. Having a 3 tables, Book_Table (Book_ID, BookTitle, Author), User_Profile(MemberId, LName, FName, MName), Book_Review(ReviewId, BookId, MemberId, Review, DatePosted)..
..
..
Before having a review, the user must select 'read' from the dropdownlist.
I am trying to implement it in my page but I'm having a hard time doing it. Please help me. Answers, or links can be,. Thank you very much..
I'm currently working on this codes but it's not working with my listview.. please help.
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:ASPdatabase %>"
SelectCommand="SELECT User_Profile.MemberId, User_Profile.Picture, User_Profile.Fname, Book_Review.Review, Book_Review.ReviewDate, Book_Review.MemberId AS Expr1, User_Profile.UserId FROM Book_Review INNER JOIN User_Profile ON Book_Review.MemberId = User_Profile.MemberId WHERE (Book_Review.Book_ID = @Book_ID)">
<SelectParameters>
<asp:QueryStringParameter Name="Book_ID" QueryStringField="Book_ID" />
</SelectParameters>
</asp:SqlDataSource>