我得到这个奇怪的错误…我的数据库中的主键是’DocumentID’,所以我知道这不是问题.我正在尝试选择,编辑和删除gridview按钮工作,但我需要正确设置datakeynames以供他们使用.有任何想法吗?
- <asp:GridView ID="GridView1" runat="server" DataSourceID="sdsDocuments" EnableModelValidation="True"
- SelectedIndex="0" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" DataKeyNames="DocumentID,DocumentTitle,DocumentBody">
- <Columns>
- <asp:BoundField DataField="DocumentID" HeaderText="DocumentID" ReadOnly="True" SortExpression="ID" />
- <asp:BoundField DataField="DocumentTitle" HeaderText="DocumentTitle" SortExpression="Title" />
- <asp:BoundField DataField="DocumentBody" HeaderText="DocumentBody" SortExpression="Body" />
- <asp:CommandField ShowSelectButton="True" ShowDeleteButton="True" />
- </Columns>
- </asp:GridView>
- <asp:sqlDataSource ID="sdsDocuments" runat="server" ConnectionString="<%$ConnectionStrings:blcDocumentationConnectionString %>"
- SelectCommand="SELECT [DocumentTitle],[DocumentBody] FROM [tblDocument]" />
这是堆栈跟踪…
- [HttpException (0x80004005): DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'DocumentID'.]
- System.Web.UI.DataBinder.GetPropertyValue(Object container,String propName) +8672869
- System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource,Boolean dataBinding) +2178
- System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data) +57
- System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data) +14
- System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) +114
- System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments,DataSourceViewSelectCallback callback) +31
- System.Web.UI.WebControls.DataBoundControl.PerformSelect() +142
- System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73
- System.Web.UI.WebControls.GridView.DataBind() +4
- System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
- System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +72
- System.Web.UI.Control.EnsureChildControls() +87
- System.Web.UI.Control.PreRenderRecursiveInternal() +44
- System.Web.UI.Control.PreRenderRecursiveInternal() +171
- System.Web.UI.Control.PreRenderRecursiveInternal() +171
- System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint,Boolean includeStagesAfterAsyncPoint) +842
解决方法
那么你没有选择documentid列,因此它不存在于datatable或dataview中,它们绑定到grid或通过datatable引用该列.
将您的查询更改为
- SelectCommand="SELECT [DocumentID],[DocumentTitle],[DocumentBody] FROM [tblDocument]" />