IErrorInfo.GetDescription failed with E_FAIL(0x80004005).

Guys, im not sure why am i getting this error. I have tried to google it and seems most are about the [] around the field.

Here's my code that causing the error, hope someone can rectify it:

<asp:SqlDataSource ID="dsGridView" runat="server" ConnectionString="<%$ ConnectionStrings:MyConn %>" ProviderName="<%$ ConnectionStrings:MyConn.ProviderName %>"
        SelectCommand="SELECT d.[dept_ID], d.[dept_name], c.[costCentre_name], Coalesce(i.Amount, 0) - Coalesce(u.Amount, 0) AS 'balance'
        FROM department d
        INNER JOIN costCentre c ON d.[dept_ID] = c.[dept_ID]
        LEFT JOIN (SELECT cc_ID, Sum(amount) AS 'Amount' FROM monthlyIncome GROUP BY cc_ID) i ON c.[cc_ID]=i.[cc_ID]
        LEFT JOIN (SELECT cc_ID, Sum(amount) AS 'Amount' FROM utilization GROUP BY cc_ID) u ON c.[cc_ID]=u.[cc_ID]"
        FilterExpression="Convert(dept_ID, 'System.String')  like '{0}%'">
            <FilterParameters>
            <asp:ControlParameter Name="dept_ID" ControlID="ddlDept" PropertyName="SelectedValue" />
            </FilterParameters>
            </asp:SqlDataSource>

Re: IErrorInfo.GetDescription failed with E_FAIL(0x80004005).

Hello,

Follow the links below. It will help you to resolve the issue.

http://forums.asp.net/t/1225443.aspx/1

http://stackoverflow.com/questions/6455909/ierrorinfo-getdescription-failed-with-e-fail0x80004005-system-data-while-data

Re: IErrorInfo.GetDescription failed with E_FAIL(0x80004005).

run your sql query in SSMS with some sample inputs and check if your SQL is working, then we can trouble shoot with Filter Paramter...

Thanks,