修复 - 数据绑定： 'System.Data.DataRowView'不包含具有名称的属性

Question

create procedure St_Proc_GetUserReportforCurrentDayTask                  
@userID int                  
as                  
    Begin                  
        set NoCount on;                  
        DECLARE @TODAY DATE                    
        SET @TODAY = CONVERT(VARCHAR(10), GETDATE(), 111)                  
        select  CONVERT(VARCHAR,production.CalendarDate,101) + RIGHT (CONVERT(VARCHAR,production.CalendarDate , 100 ) ,7) as Date,                   
        RegionAndProjectInfo.RegionProjectName as Region ,                  
        County.CountyName as County,                  
        WorkType.WorkTypeName as WorkType,                  
        Task.TaskName as Task,      
        Production.VolumeProcessed as 'Volumes Processed',                  
        Production.TimeSpent as 'Duration(HH:MM)'                  
        from Production                   
        inner join RegionAndProjectInfo                  
        on                  
        RegionAndProjectInfo.RegionProjectID=Production.RegionProjectID                  
        inner join County                  
        on                   
        County.CountyID=Production.CountyID                  
        inner join WorkType                  
        on                  
        WorkType.WorkTypeID=Production.WorkTypeID                  
        inner join Task                  
        on                  
        Task.TaskID=Production.TaskID                  
        where Production.UserID=@userID and CalendarDate >= @TODAY                  
    End 

这是我的存储过程，

我正在执行此存储过程并将结果保存在数据集中，然后将网格与此数据集绑定。

private void BindGridOnPageLoad()
    {
        _production = new EmployeeQuotientCL.Production();
        _userEcode = Convert.ToString(Session["UserID"]);
        int _userID = _production.GetUserIDFromDB(_userEcode);
        dsUserTaskDetails = _production.GetTabularUsertaskDetails(_userID);
        BindGridView(dsUserTaskDetails);
    }

到这里为止，一切都很好.然后我要求在网格视图的页脚中显示持续时间(HH：MM(总计。我在页面中添加了以下代码：-

<div id="gridview">
            <asp:GridView ID="GVUserEnteredDetails" runat="server" ShowFooter="true" CssClass="mGrid"  CellSpacing="2"   onselectedindexchanged="GVUserEnteredDetails_SelectedIndexChanged" onrowdatabound="GridView1_RowDataBound">                  
            </asp:GridView>

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            tp += Convert.ToDecimal(((DataRowView)e.Row.DataItem).Row["[Duration(HH:MM)]"]);
        }
        if (e.Row.RowType == DataControlRowType.Footer)
        {
            e.Row.Cells[0].Text = "Total Hours : ";
            e.Row.Cells[1].Text = tp.ToString("c");
            e.Row.Cells[0].HorizontalAlign = HorizontalAlign.Right;
            e.Row.Cells[1].HorizontalAlign = HorizontalAlign.Right;
            e.Row.Font.Bold = true;
        }
    }

但是当我调试时，我收到此错误：- "数据绑定："系统数据.数据行视图"不包含名为"持续时间"的属性。我犯了什么错误以及如何修复它？任何建议和帮助都会对我有所帮助。

堆栈跟踪：-

[

参数异常：列"[持续时间(HH：MM(]"不属于表表。 System.Data.DataRow.GetDataColumn(String columnName( +2124943 System.Data.DataRow.get_Item(字符串列名称( +13 情 商。Associates.Production.GridView1_RowDataBound(Object sender， GridViewRowEventArgs e( in C：\Users\dsingh\Documents\Visual Studio 2010\Projects\EQ\EQ\Associates\Production.aspx.cs：112 System.Web.UI.WebControls.GridView.OnRowDataBound(GridViewRowEventArgs e( +115 System.Web.UI.WebControls.GridView.CreateRow(Int32 rowIndex， Int32 dataSourceIndex， DataControlRowType rowType， DataControlRowState rowState， Boolean dataBind， Object dataItem， DataControlField[] fields， TableRowCollection rows， PagedDataSource pagedDataSource( +181 System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource， Boolean dataBinding( +3896 System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data( +66 System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data( +14 System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data( +128 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments， DataSourceViewSelectCallback callback( +33 System.Web.UI.WebControls.DataBoundControl.PerformSelect(( +143 System.Web.UI.WebControls.BaseDataBoundControl.DataBind(( +74 System.Web.UI.WebControls.GridView.DataBind(( +4 情 商。Associates.Production.BindGridView(DataSet ds( in C：\Users\dsingh\Documents\Visual Studio 2010\Projects\EQ\EQ\Associates\Production.aspx.cs：603 情 商。Associates.Production.BindGridOnPageLoad(( in C：\Users\dsingh\Documents\Visual Studio 2010\Projects\EQ\EQ\Associates\Production.aspx.cs：593 情 商。Associates.Production.Page_Load(Object sender， EventArgs e( in C：\Users\dsingh\Documents\Visual Studio 2010\Projects\EQ\EQ\Associates\Production.aspx.cs：78 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp， Object o， Object t， EventArgs e( +14 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender， EventArgs e( +35 System.Web.UI.Control.OnLoad(EventArgs e( +91 System.Web.UI.Control.LoadRecursive(( +74 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint， Boolean includeStagesAfterAsyncPoint( +2207

Answer 1

正如您在评论中提到的，您在表示为 HH：mm 的数据的十进制解析中遇到了麻烦

您应该使用TimeSpan来对所有这些值求和，而不是小数。(TimeSpan解析了 4.0 的确切功能，但如果您使用的是较小的版本(

尝试以这种方式进行

TimeSpan ts = DateTime.ParseExact("02:30", "HH:mm", CultureInfo.InvariantCulture).TimeOfDay;
// instead of 02:30 you would have the string from your column passed in
// you can add up the values in this fashion
ts.Add(DateTime.ParseExact("08:30", "HH:mm", CultureInfo.InvariantCulture).TimeOfDay);

结果时间跨度，您可以使用它以您选择的格式显示它，因为它也有天数，或者您可以随时显示ts.TotalMinutes

希望这就是您正在寻找的，否则请更新相关部分

Answer 2

尝试在列名周围使用 sqare 括号，因为它包含特殊字符。 比如，

 tp += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "[Duration(HH:MM)]"));