I'm getting an error when trying to insert a parent and/or child record. The error says "Procedure or function usp_ins_Chart_Review_Claim has too many arguments specified." I've checked the stored procedures and they both have the same number of parameters that are in their section.
Here is what the datasource code looks like:
<ig:WebHierarchicalDataSource ID="WHDS_Claims_and_Diags" runat="server">
<DataViews>
<ig:DataView ID="dsClaims_DefaultView" DataMember="DefaultView" DataSourceID="dsClaims" />
<ig:DataView ID="dsDiags_DefaultView" DataMember="DefaultView" DataSourceID="dsDiags" />
DataViews>
<DataRelations>
<ig:DataRelation ChildColumns="Original_Claim_ID" ChildDataViewID="dsDiags_DefaultView" ParentColumns="Original_Claim_ID" ParentDataViewID="dsClaims_DefaultView" />
DataRelations>
ig:WebHierarchicalDataSource>
<asp:SqlDataSource ID="dsClaims" runat="server" ConnectionString="<%$ ConnectionStrings:cs_CHP_EDPS %>" InsertCommand="usp_ins_Chart_Review_Claim" InsertCommandType="StoredProcedure" OnInserting="dsClaims_Inserting" SelectCommand="usp_get_Chart_Review_Claims_in_Prev_Year" SelectCommandType="StoredProcedure">
<InsertParameters>
<asp:Parameter Name="Member_ID" Type="String" />
<asp:Parameter DbType="Date" Name="Start_Date" />
<asp:Parameter DbType="Date" Name="End_Date" />
<asp:Parameter Name="User_Name" Type="String" />
InsertParameters>
<SelectParameters>
<asp:QueryStringParameter Name="Member_ID" QueryStringField="Member_ID" Type="String" />
<asp:QueryStringParameter Name="HCC" QueryStringField="HCC" Type="Int32" />
SelectParameters>
asp:SqlDataSource>
<asp:SqlDataSource ID="dsDiags" runat="server" ConnectionString="<%$ ConnectionStrings:cs_CHP_EDPS %>" DeleteCommand="usp_del_Chart_Review_Diag" DeleteCommandType="StoredProcedure" OnDeleting="dsDiags_Deleting" InsertCommand="usp_ins_Chart_Review_Diag" InsertCommandType="StoredProcedure" OnInserting="dsDiags_Inserting" SelectCommand="usp_get_Chart_Review_Claim_Diags" SelectCommandType="StoredProcedure">
<DeleteParameters>
<asp:Parameter Name="Row_ID" Type="Int32" />
DeleteParameters>
<asp:Parameter Name="Claim_ID" Type="String" />
<asp:Parameter Name="Diag" Type="String" />
We are looking forward for your reply.
I apologize. I'm going to have to move to something else and come back to this. I work for a healthcare organization and the data contained in the tables is personal health information, so I am not allowed to send it out. I had started creating a separate database and with only the tables you needed with dummy data in the tables, but before I could finish I was asked to get another project finished first.
Hello Angela,
Thank you for your patience.
Do you get the same error once you fix your parameters?
An .mdf and .ldf files would do fine. This is all I need to get the sample working.
I am looking forward to hearing from you.
Thank you for sending the files.
I will get back to you once I have a solution or question regarding your issue.
Please let me know if there is anything else.
Dang it, forgot to attach it!