yorock 0 Newbie Poster

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..

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.