读书人

msdn上的例代通不?asp

发布时间: 2012-02-29 16:44:10 作者: rapoo

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了没》/

读书人网 >asp.net

热点推荐