[I am trying to bind a gridview from a table and updation records in another table]
Actually I have two sql tables, named mtblVehicle_Booking and mtblLog_Book. In both tables all columns are same but mtblLog_Book is having 2 more columns KM_Start and KM_End.
Actually I am binding the gridview from mtblVehicle_Booking table (which don't have KM_Start and KM_End columns). The other side I have given edit option in gridview, but when I need to edit this gridview , the colums KM_Start and KM_End should come in that gridview as editing form and after updating the gridview the updated information should be seen in the gridview.
How can I accomplish this.
you can take it as a Gridview bounded with one table but when it gets update this should be partially bounded with the other table with updated information and rest of the gridview should bounded with the first one.
Suppose if gridview is having 5 rows from table1 one and if I edit two rows for updation the table2 then the gridview should show these 2 rows from table2 and the rest rows from table1 which actually has bot been updated.