I have a system for Visitor management , it's include 2part one for visit and other for visitor a form for visit info conatains many field enterd by textbox and dropdown list , the visitor info appear in gridview becuase its possible one visit include many visitors so i have many info for them Like (Nationality, National ID, OrgName , Name).
i need stored procedure to save all this data in DB in Visit table and to link the tow part in the same table by one button.