Master/Detail problem on Whidbey CTP build

[Johnny §õ«¶¿« \(Microsoft MVP for ASP.NET\)]

The following code is from the online tutorial but it doesn't run on my CTP
build I've just installed.

The first problem is, ImageField doesn't have a public DataField field. Ok,
I removed this line.

The second problem is that "the @EmployeeID column can not be found." Hmmm,
could any one help me verify if the program happens on your side?

BTW, I didn't install SQL 2005. I still use SQL 2000. Can it be the cause of
the problems?

<table cellpadding="10 ">
<tr>
<td valign="top">
<asp:GridView
ID="MasterGridV iew"
DataSourceID="M asterSource"
AutoGenerateCol umns="false"
DataKeyNames="E mployeeID"
CellPadding="5"
SelectedRowStyl e-BackColor="#eee eee"
Runat="Server">
<Columns>
<asp:TemplateFi eld HeaderText="Emp loyee">
<ItemTemplate >
<asp:LinkButt on CommandName="Se lect" Runat="Server">
<%# Eval("LastName" ) %>, <%# Eval("FirstName ") %>
</asp:LinkButton>
</ItemTemplate>
</asp:TemplateFie ld>
</Columns>
</asp:GridView>

</td>
<td valign="top">

<asp:DetailsVie w
DataSourceID="D etailsSource"
AutoGenerateRow s="false"
CellPadding="5"
FieldHeaderStyl e-Font-Bold="true"
FieldHeaderStyl e-HorizontalAlign ="Right"
Runat="Server">
<Fields>
<asp:ImageFie ld DataField="Phot o" HeaderText="Pho to:" />
<asp:BoundFie ld DataField="Last Name"
HeaderText="Las t Name:" />
<asp:BoundFie ld DataField="Firs tName"
HeaderText="Fir st Name:" />
<asp:BoundFie ld DataField="Exte nsion"
HeaderText="Ext ension:" />
</Fields>
</asp:DetailsView >
</td>
</tr>
</table>
<asp:SqlDataSou rce
ID="MasterSourc e"
EnableCaching=" true"
CacheDuration=" 600"
ConnectionStrin g=
"Server=localho st;database=Nor thwind;Trusted_ Connection=true "
SelectCommand=" SELECT * FROM Employees"
Runat="Server" />
<asp:SqlDataSou rce
ID="DetailsSour ce"
EnableCaching=" true"
CacheDuration=" 600"
ConnectionStrin g=
"Server=localho st;database=Nor thwind;Trusted_ Connection=true "
SelectCommand=" SELECT * FROM Employees"
FilterExpressio n="EmployeeID=@ EmployeeID"
Runat="Server">
<FilterParamete rs>
<asp:ControlPar ameter
Name="EmployeeI D"
ControlID="Mast erGridView"
PropertyName="S electedValue" />
</FilterParameter s>
</asp:SqlDataSour ce>

[Johnny §õ«¶¿« \(Microsoft MVP for ASP.NET\)]

Haaa! I found the solution by myself from the MSDN product feedback center.

There is a syntax change in the new version, just change

FilterExpressio n="EmployeeID=' @Employee'"

to

FilterExpressio n="EmployeeID=' {0}'"

and the problem is gone.

Refer to
http://lab.msdn.microsoft.com/produc...3-d5ee72fd9303

"Johnny §õ«¶¿« (Microsoft MVP for ASP.NET)" <jo****@phone.i dv.tw> ¼¶¼g©ó¶l¥ó
·s»D:OM******** *****@TK2MSFTNG P10.phx.gbl...

The following code is from the online tutorial but it doesn't run on my CTP build I've just installed.

The first problem is, ImageField doesn't have a public DataField field. Ok, I removed this line.

The second problem is that "the @EmployeeID column can not be found." Hmmm, could any one help me verify if the program happens on your side?

BTW, I didn't install SQL 2005. I still use SQL 2000. Can it be the cause of the problems?

<table cellpadding="10 ">
<tr>
<td valign="top">
<asp:GridView
ID="MasterGridV iew"
DataSourceID="M asterSource"
AutoGenerateCol umns="false"
DataKeyNames="E mployeeID"
CellPadding="5"
SelectedRowStyl e-BackColor="#eee eee"
Runat="Server">
<Columns>
<asp:TemplateFi eld HeaderText="Emp loyee">
<ItemTemplate >
<asp:LinkButt on CommandName="Se lect" Runat="Server">
<%# Eval("LastName" ) %>, <%# Eval("FirstName ") %>
</asp:LinkButton>
</ItemTemplate>
</asp:TemplateFie ld>
</Columns>
</asp:GridView>

</td>
<td valign="top">

<asp:DetailsVie w
DataSourceID="D etailsSource"
AutoGenerateRow s="false"
CellPadding="5"
FieldHeaderStyl e-Font-Bold="true"
FieldHeaderStyl e-HorizontalAlign ="Right"
Runat="Server">
<Fields>
<asp:ImageFie ld DataField="Phot o" HeaderText="Pho to:" />
<asp:BoundFie ld DataField="Last Name"
HeaderText="Las t Name:" />
<asp:BoundFie ld DataField="Firs tName"
HeaderText="Fir st Name:" />
<asp:BoundFie ld DataField="Exte nsion"
HeaderText="Ext ension:" />
</Fields>
</asp:DetailsView >
</td>
</tr>
</table>
<asp:SqlDataSou rce
ID="MasterSourc e"
EnableCaching=" true"
CacheDuration=" 600"
ConnectionStrin g=
"Server=localho st;database=Nor thwind;Trusted_ Connection=true "
SelectCommand=" SELECT * FROM Employees"
Runat="Server" />
<asp:SqlDataSou rce
ID="DetailsSour ce"
EnableCaching=" true"
CacheDuration=" 600"
ConnectionStrin g=
"Server=localho st;database=Nor thwind;Trusted_ Connection=true "
SelectCommand=" SELECT * FROM Employees"
FilterExpressio n="EmployeeID=@ EmployeeID"
Runat="Server">
<FilterParamete rs>
<asp:ControlPar ameter
Name="EmployeeI D"
ControlID="Mast erGridView"
PropertyName="S electedValue" />
</FilterParameter s>
</asp:SqlDataSour ce>