what i can't find in the book

bertus · #1 (**permalink**) September 12th, 2010, 02:48 PM

suppose I want to build a page on which my users can see (following the planet wrox site) a details view of 'reviews' but read-only and i want to show not the 'GenreId' property but the actual Genre name. How do I build this? because If I make a connection to a SQLconnectionstring connected to the 'Reviews' table I only can retrieve the 'GenreId' property because that's in that specific table.
In the book, in chapter 13 thispossibility is built using a dropdown menu (page 470) but then only in inserting or updating.

Parallell i want to make a detailsview page in my site with all the details of a certain 'VACATURE'. In my 'vacature'table I use:
--- 'FunctieId' for the type of job, connected to 'FunctieNaam' in the 'Functie' table and
--- 'FiliaalId' which refers to 'FiliaalNaam' in my 'Filiaal' table
But how do I get the data from Vacature united with FunctiNaam en FiliaalNaam in one detailsview?

Quite a story, right? Well, that's not all:

From my page 'VacaturesTotaa.aspx' you get to the detailspage through a working hyperlink field in a gridview, which adds a querystring to the URL to the 'detailsviewPage.aspx' (working!

) but how do i retrieve this querystring's value on the details page so i tell the detailsview what to show in the detailsview considering that querystring's 'Id'?

did I explain that correctly? I cost me already a day of experimenting and i can't get it to work....

help.....?

Weer een noodkreet uit Sneek...greetz!

Imar · #2 (**permalink**) September 13th, 2010, 02:57 AM

Hi there,

Take a look at page 414 in Chapter 12, section Joining Data.

The following example show something similar, where the Name (not just the ID) of a Genre is queried with a Review:

Code:

 
SELECT
  Review.Id, Review.Title, Genre.Name
FROM
  Review

Code:

INNER JOIN Genre ON Review.GenreId = Genre.Id

Imar

gouravvishnoi · #3 (**permalink**) September 13th, 2010, 06:42 AM

Hi All,
I am very new in Remoting & Windows ,actually till now i had only work in
Web,recently i change my job so i have to work on Windows.Now i have
one query...

I have to make a application in that Create a Virtual Directory in IIS
Through Remoting or WCF..and after that we will able to update this
virtual directory Properties..So can you tell me or guide how can i'll
prepare for that..Please i'll heartly thankful to you....

Regards:
Gourav Vishnoi
91-9871157845 (M)

Need to download code?

Navigation