Regarding The Query To Save The Ids Of The Edited Names From Different Tables Into A Single Table.

Here with the below query iam binding my gridview with industry name,company name,Plant Name,Group Name related to the IDs in Audit table.Select Aud.Ad_ID_PK,Aud.Audit_Name,Ind.Industry_Name,Cmp.Company_Name,Pla.Plant_Name,Gr.Groups_Name,Aud.Audit_Started_On,Aud.Audit_Scheduledto,Aud.Audit_Created_On from

Industry Ind,

Company Cmp,

Plant Pla,

Groups Gr,

Audits Audwhere Ind.Ind_Id_PK =Aud.Audit_Industry and

Cmp.Cmp_ID_PK =Aud.Audit_Company and

Pla.Pl_ID_PK =Aud.Audit_Plant and

Gr.G_ID_PK =Aud.Audit_Group and

Ad_ID_PK in (select Ad_ID_PK from Audits)

Now i want to edit these names.

when i click on edit in gridview these names will be filled into textboxes and when i change the names it should compare the name with particular tables and should get the Id of that and store in Audits table.

For example:

i have this data in my audits table:





Commercial83312

2
2
2
1

Here Commercial83312 is ID of that Audit and 2,2,2,1 are the Industry,Company,Plant and group Ids for that particular audit.In the front end i can see the names of this particular IDs.

when i edit the industry name in the UI it must check the name with industry table and get the ID of the changed name and store it in audit table.

so the data may be changed in audits table as :



Commercial83312

4
2
2
1


 





so here the industry ID is changed

I need the stored procedure for this.

please help me,its very urgent...