一个关于DataGrid的问题
<asp:TemplateColumn HeaderText="是否系统">
<ItemTemplate>
<asp:CheckBox id="CheckBox2" runat="server" Checked='<%# DataBinder.Eval(Container, "DataItem.sfxt")%>'>
</asp:CheckBox>
</ItemTemplate>
</asp:TemplateColumn>
以上是我的页面
Sql语句是:
select pzbm,pzmc,case sfsy when 'Y' then 'true' else 'false' end as sfsy,case sfxt when 'Y' then 'true' else 'false' end as sfxt from t_PinZhong
结果出错,错误信息是:
行 25:<asp:TemplateColumn HeaderText="是否使用">
行 26:<ItemTemplate>
行 27:<asp:CheckBox id="CheckBox1" runat="server" Checked='<%# DataBinder.Eval(Container, "DataItem.sfsy")%>'>
行 28:</asp:CheckBox>
行 29:</ItemTemplate>
源文件: c:\inetpub\wwwroot\WebApplication3\WebForm2.aspx 行: 27
堆栈跟踪:
[InvalidCastException: 指定的转换无效。]
ASP.WebForm2_aspx.__DataBind__control13(Object sender, EventArgs e) in c:\inetpub\wwwroot\WebApplication3\WebForm2.aspx:27
System.Web.UI.Control.OnDataBinding(EventArgs e)
System.Web.UI.Control.DataBind()
System.Web.UI.Control.DataBind()
System.Web.UI.Control.DataBind()
System.Web.UI.WebControls.DataGrid.CreateItem(Int32 itemIndex, Int32 dataSourceIndex, ListItemType itemType, Boolean dataBind, Object dataItem, DataGridColumn[] columns, TableRowCollection rows, PagedDataSource pagedDataSource)
System.Web.UI.WebControls.DataGrid.CreateControlHierarchy(Boolean useDataSource)
System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e)
System.Web.UI.WebControls.BaseDataList.DataBind()
WebApplication3.WebForm2.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\webapplication3\webform2.aspx.cs:36
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()