Updating datagridview in c
Later than Q very much for the reply No sorry's in this just you are giving your idea I changed the code like above now its not throwing any exception but the message "data updated "is coming but its not updating in the database whe n I checked Thanks Geeta Ok.
There is no need of using Update in Data Set, until u make any changes to the table. If so, that will be must easier, as u'll be freed up of writing any code.
Now What I'm trying to do is when user do the changes in the grid those changes should be reflected in the list (in object properties) and then it should be updated in the database.
I just wanna update my database with one click only.
But as Goran says, a more detailed explanation would be useful. This is actually my very first coding project since taking a 5 day ASP. So if you want to throw in any other pointers about how I should "clean up" my code, please feel free. The overall goal is to take the kids in the Applicants table and assign them to jobs in the Job Titles table. I've searched the web for nearly a week now and none of the solutions work. Fill command from a tableadapter or dataadapter originally and it will remain like that unless and until you make changes to it in the application or you use the original . It should be a simple matter, but I started out with the two Data Grid Views and have not gotten anywhere. Let me illustrate what I mean: with acknowledgments to Goran, as it is the same point as he has made. Close() This button Updates the database, but the changes are not reflected in the Data Grid View, Job Titles Data Grid View, until I exit the application and run it again. That datatable was (again, I assume) filled by some sort of . I have a table for Job Titles and another table for the Applicants. There is PK_Job Title ID in tbl Job Titles and FK_Job Title ID in tbl Applicants. Indeed, doing it that way may be better even in a multi-user setting: just doing updates to the database more frequently. Write("data updated"); here the exception is Invalid Opration Exception was unhandled by user code Update unable to find Table Mapping['Employee Table'] or Data Table 'Employee Table'. Open(); Sql Data Adapter da Select = new Sql Data Adapter("SELECT * FROM Employee Table", conn); Sql Command Builder cb Select = new Sql Command Builder(da Select); Data Set ds Select = new Data Set(); da Select. Write("data updated"); I changed the code what ever you send previously protected void my Grid View_Row Updating(object sender, Grid View Update Event Args e) } but again the same exception is throwing again please tell me where to change the code.......... Open(); Sql Data Adapter da Select = new Sql Data Adapter("SELECT * FROM Employee Table", conn); // Sql Command Builder cb Select = new Sql Command Builder(da Select); Data Set ds Select = new Data Set("Emploee Table"); da Select.