VB.NET Refresh other DataGridView based if changing in another DataGridView -
i habe datagridview shows attributes of employees. can add remove, save, works quite fine. in same form have datagridview shows employeegroups employees belong. datamodel this: tableemployees.pk --> table employeegroups fk employeenr --> employeenr
now tried several ways (it feels hundreds) refresh second datagridview. because wanted possibility test bit easier code in buttonevent change it, if works.
here datacollections:
t_magruppentableadapter.fill(dtmagruppen) tmagruppenbindingsource.datasource = dtmagruppen out of names can see types.
here how fill datagridview:
private sub datagridmagruppen_fill() ' set datagridview. dim mitarbeiternr, gruppennr new datagridviewcomboboxcolumn me.datagridmagruppen .autogeneratecolumns = false .datasource = db.tmagruppenbindingsource .autosizerowsmode = _ datagridviewautosizerowsmode.displayedcellsexceptheaders .borderstyle = borderstyle.fixed3d .editmode = datagridvieweditmode.editonenter end me.datagridmagruppen.columns mitarbeiternr .datapropertyname = "mitarbeiternr" .datasource = db.tmitarbeiter2bindingsource .displaymember = "nn" .valuemember = "nr" .flatstyle = system.windows.forms.flatstyle.flat .headertext = "mitarbeiter" .width = 193 end gruppennr .datapropertyname = "gruppennr" .datasource = db.tgruppenbindingsource .displaymember = "gruppename" .valuemember = "nr" .flatstyle = system.windows.forms.flatstyle.flat .headertext = "gruppe" .width = 190 end .addrange(mitarbeiternr, gruppennr) end end sub and here tries refresh datagridview:
db.tableadapterspeichern(1) db.tmagruppenbindingsource.resetbindings(false) 'db.dtmagruppen.clear() 'db.t_magruppentableadapter.fill(db.dtmagruppen) 'datagridmagruppen.datasource = db.dtmagruppen the dataadapters etc. have prefix because made database class.
so how can refresh datagridview magruppen after update datagridviewemployees?
*edit add method tableadapterspeichern
public sub tableadapterspeichern(byval typ integer) dim test integer select case typ case 1 'person tmitarbeiterbindingsource.endedit() test = t_mitarbeitertableadapter.update(ctype(tmitarbeiterbindingsource.datasource, datatable)) case 2 'kfz tkfzbindingsource.endedit() t_kfztableadapter.update(ctype(tkfzbindingsource.datasource, datatable)) case 3 'gruppen tmagruppenbindingsource.endedit() t_magruppentableadapter.update(ctype(tmagruppenbindingsource.datasource, datatable)) case 4 'person tmitarbeiter1bindingsource.endedit() t_mitarbeiter1tableadapter.update(ctype(tmitarbeiter1bindingsource.datasource, datatable)) end select end sub i can add new employees , everything, should work, type use save employees 1.
Comments
Post a Comment