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>
Please mark as 'answer' if it is helpful. Thanks in advance!
NIthya Natha...
Member
6 Points
59 Posts
IErrorInfo.GetDescription failed with E_FAIL(0x80004005).
Apr 30, 2012 03:33 AM|LINK
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>Ashley.Jones
Member
210 Points
51 Posts
Re: IErrorInfo.GetDescription failed with E_FAIL(0x80004005).
Apr 30, 2012 06:03 AM|LINK
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
ramiramilu
All-Star
95393 Points
14096 Posts
Re: IErrorInfo.GetDescription failed with E_FAIL(0x80004005).
Apr 30, 2012 08:00 AM|LINK
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,
JumpStart