i am using a formview control in my project..
i am trying to update fields of 2 tables using formview..
table1:Personal_details:
columns:P_id --->primary key
Emp_id-->foreign key
First_name
table2:Educational_qualification
columns:Eq_id ->primary key
Emp_id ->foreign key
Institute..
these 2 tables are connected by column Emp_id
My update command of formview control is:
UpdateCommand="Update [Personal_details] Set [First_name]=@First_name WHERE [P_id]=@original_P_id and[Emp_id]=@original_Emp_id and [First_name]=@original_First_name;
Update [Educational_qualification] Set[Institute]=@Institute WHERE [Eq_id]=@original_Eq_id and [Emp_id]=@original_Emp_id and [Institute]=@original_Institute"
<UpdateParameters >
<asp:Parameter Name ="P_id" Type ="string" />
<asp:Parameter Name ="original_P_id" Type ="string" />
<asp:Parameter Name ="original_Eq_id" Type ="string" />
<asp:Parameter Name ="First_name" Type ="string" />
<asp:Parameter Name ="Institute" Type ="string" />
<asp:Parameter Name="original_First_name" Type ="string" />
<asp:Parameter Name="original_Institute" Type ="string" />
<asp:Parameter Name ="original_Emp_id" Type ="string" />
</UpdateParameters>
when i try 2 edit values,old values are not gettin updated..i.e after clicking on the update link still the old values are gettin displayed..
plz suggest some solution..