msdn上的這個範例代碼調試通不過?asp.net2.0
錯誤為:Cannot find column [@EmployeeID].
<html>
<head runat= "server ">
<title> Master/Detail Page </title>
</head>
<body>
<form runat= "server ">
<table cellpadding= "10 ">
<tr>
<td valign= "top ">
<asp:GridView
ID= "MasterGridView "
DataSourceID= "MasterSource "
AutoGenerateColumns= "false "
DataKeyNames= "EmployeeID "
CellPadding= "5 "
SelectedRowStyle-BackColor= "#eeeeee "
Runat= "Server ">
<Columns>
<asp:TemplateField HeaderText= "Employee ">
<ItemTemplate>
<asp:LinkButton CommandName= "Select " Runat= "Server ">
<%# Eval( "LastName ") %> , <%# Eval( "FirstName ") %>
</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</td>
<td valign= "top ">
<asp:DetailsView
DataSourceID= "DetailsSource "
AutoGenerateRows= "false "
CellPadding= "5 "
FieldHeaderStyle-Font-Bold= "true "
FieldHeaderStyle-HorizontalAlign= "Right "
Runat= "Server ">
<Fields>
<asp:ImageField DataField= "Photo " HeaderText= "Photo: " />
<asp:BoundField DataField= "LastName "
HeaderText= "Last Name: " />
<asp:BoundField DataField= "FirstName "
HeaderText= "First Name: " />
<asp:BoundField DataField= "Extension "
HeaderText= "Extension: " />
</Fields>
</asp:DetailsView>
</td>
</tr>
</table>
<asp:SqlDataSource
ID= "MasterSource "
EnableCaching= "true "
CacheDuration= "600 "
ConnectionString=
"Server=localhost;database=Northwind;Trusted_Connection=true "
SelectCommand= "SELECT * FROM Employees "
Runat= "Server " />
<asp:SqlDataSource
ID= "DetailsSource "
EnableCaching= "true "
CacheDuration= "600 "
ConnectionString=
"Server=localhost;database=Northwind;Trusted_Connection=true "
SelectCommand= "SELECT * FROM Employees "
FilterExpression= "EmployeeID=@EmployeeID "
Runat= "Server ">
<FilterParameters>
<asp:ControlParameter
Name= "EmployeeID "
ControlID= "MasterGridView "
PropertyName= "SelectedValue " />
</FilterParameters>
</asp:SqlDataSource>
</form>
</body>
</html>
------解决方案--------------------
错误 1
<asp:ImageField DataField= "Photo " HeaderText= "Photo: " />
===========
ImageField 不具有 DataField 属性
》》》
<asp:ImageField DataImageUrlField= "Photo " HeaderText= "Photo: " />
错误 2
FilterExpression= "EmployeeID=@EmployeeID "
=======
FilterExpression 属性中,参数只能使用占位符
》》》
FilterExpression= "EmployeeID={0} "
详细说明见:
[解决办法]
兄弟 你装 SQL2000了没》/