I have a small problem with GridView. I have two tables (Clients and Projects) and I used inner join condition to join one column from another table. The Clients table consists of ClientID and Client columns while the Projects column consists of ProjectID, ClientID, Client and Project. In the GridView datasource, I used inner join statement to join the ProjectID, Project and Client columns from both the tables.
Now if I change the Client (DropdownList) in GridView and click update, the record is not getting updated.
I think that the ClientID has to be updated if the Client is changed. Can anybody suggest how the ClientID can be updated automatically once the Client is changed? Thanks
Here is the HTML code:
View Complete Post