Can not UPDATE dataGridView


  • I have the project in MS Access, I have been converting to VS C# with three, linked tables (Table A and Table B one-to-many and Table C as a Lookup table for Table B many-to-one). Since, I could not find any replacement for DataSheet View from MS Access in Visual C#, where we could disply data from Tables B and C in one row(hierarchicaly), I put two linked dataGridViews (bonded to Table A to Table B). Then I changed dataAdapter of Table B to use query from two tables B and C (lookup) and added two columns to table B dataGridView with dataPropertyName of fields from table C. Now I have data from table A in first dataGridView and as well as data from new query of two tables B and C in second dataGridView. There is ONE PROBLEM: I can not UPDATE tables with new data becouse altered dataAdapter for table B has no definition for Update. New query is read only. Does any one has an idea how to overcame it?


    Monday, April 3, 2006 7:11 PM