Hi Folks, in the above book in page 461 a QueryString is setup (fig 13-16) in the where clause. Can someone explain what is going on as I can't understand exactly what is going on. Specifically the syntax [Id] = @Id.

In advance, many thanks
Mark

Hi there,

The QueryString parameter is used to influence the SQL statement so it only selects the review whose ID is in the query string (in the address of the page; e.g. something like ?Id=123 would retrieve review 123).

The part:

[id] = @id

contains two important sections. [Id] refers to the Id column of the Review table. It's used in the WHERE Expression like this:

SELECT .... FROM Review WHERE [Id] = 123

In this example, the value for the ID is hardcoded to 123. In the example on page 461, the ID comes from the Id Query String parameter. The @id part is a placeholder that .NET fills with the ID retrieved from the query string, resulting in the correct review from being retrieved.

Does clarify things?

For future questions that are directly related to the book, can you please post in the book's own forum category at http://p2p.wrox.com/book-beginning-asp-net-4-c-vb-560/ ?

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Hi Imar, and many thanks for your prompt informative reply again. Chapter 14 of your book is good stuff.

Regards
Mark