Updating a dataset in vb net dating first kiss tips
Cheers Kieran Private Sub Form2_Load(By Val sender As System. Add(New Object() ) 'Data View to sort the items Dim dv As New Data View dv. Sort = "Des" Dim cb As Data Grid View Combo Box Column = Me.
As per your suggestion -1) How could I use a Data View to incorporate the 'Employee Name' when it is not part of the underlying datatable upon which the dataview would be made and2) This Datagridview allows the user to Update, Add and delete Data, if a Data View can resolve the sort on display value requirement then will it also allow for Updating Adding and Deleting Data in the Data Grid View?
3) Have you any example code depicting similar solution.
It won't be elegant code by any means, but off the top of my head, that's the only way I can think of at the moment to accomplish this.
Modify your Select query for your Data Adapter which fills the Data Table for your main table. Modify your Insert, Update and Delete commands for your Data Adapter to supply just the employee_id to your parameters collection instead of the concatenated value.
To set this up, instead of binding my Data Grid View directly to the Data Table, I bind it to a Data View based off of the Data Table.