vb.net - Show child data in a DataGridView control related to multiple parent entity records -

-

i have vb winforms form 3 bindingsource controls, each showing data (via datagridviews or bound textboxes) 3 related entities created db first.

i need have datagridview showing & allowing adding/editing/deleting tbl_distribution_dealermodel_overalts records related both current tbl_primarydealergroup record (joining on fields tbl_primarydealergroup.dealergroupid = tbl_distribution_dealermodels_overalts.firstdealergroupid) , current tbl_seriesmanufacturer record (joining on 2 common fields: aus_series_cde , manufacturerid). tbl_distribution_dealermodel_overalts on many-side of relationships 2 other tables:

entities

how can have child entity's datagridview show records related each of 2 (or more) parent entity records? may necessary me relate child entity 3 or more parents in project, generically applicable answers appreciated

i sorted out myself:

private sub bs_tblsm_tblpdg_currentchanged(sender system.object, e system.eventargs) handles bs_tbl_series_manufacturer.currentchanged, bs_tbl_primarydealergroup.currentchanged     if bs_tbl_series_manufacturer.current isnot nothing , bs_tbl_primarydealergroup.current isnot nothing         dim series string = bs_tbl_series_manufacturer.getitemproperties(nothing)("aus_series_cde").getvalue(bs_tbl_series_manufacturer.current)         dim manufacturer byte = bs_tbl_series_manufacturer.getitemproperties(nothing)("manufacturerid").getvalue(bs_tbl_series_manufacturer.current)         dim pdg integer = bs_tbl_primarydealergroup.getitemproperties(nothing)("dealergroupid").getvalue(bs_tbl_primarydealergroup.current)         dim changefilter boolean = false         if m_currentseries <> series             m_currentseries = series             changefilter = true         end if         if m_currentmanufacturer <> manufacturer             m_currentmanufacturer = manufacturer             changefilter = true         end if         if m_currentpdg <> pdg             m_currentpdg = pdg             changefilter = true         end if         if changefilter             dim dlrmdloveralts ienumerable(of tbl_distribution_dealermodel_overalts)             dlrmdloveralts = ddmoa tbl_distribution_dealermodel_overalts in m_context.tbl_distribution_dealermodel_overalts.local.tobindinglist _                              ddmoa.aus_series_cde = m_currentseries , ddmoa.manufacturerid = m_currentmanufacturer , ddmoa.firstdealergroupid = m_currentpdg _                              select ddmoa             bs_tbl_distribution_dealermodel_overalts.datasource = dlrmdloveralts.tolist             me.dgvtbcdealermodeloveralts_aus_series_cde.defaultcellstyle.nullvalue = m_currentseries.tostring             me.dgvtbcdealermodeloveralts_manufacturerid.defaultcellstyle.nullvalue = m_currentmanufacturer.tostring             me.dgvtbcdealermodeloveralts_firstdealergroupid.defaultcellstyle.nullvalue = m_currentpdg.tostring             bs_tbl_distribution_dealermodel_overalts.resetbindings(false)             changefilter = false         end if     end if end sub

the trick not try use datamembers of parent bindingsources in child bindingsource, relate entities in code in currentchanged of both parent bindingsources.


Comments

Post a Comment

Popular posts from this blog

c# - must be a non-abstract type with a public parameterless constructor in redis -

-
when save object, got below error must non-abstract type public parameterless constructor in order use parameter 't' in generic type or method 'servicestack.redis.redisclient.store<t>(t) redisclass.getinstnace().store(msg); // error here redisclass.getinstnace().save(); as third party's class, can not edit how save object? could create wrapper around third party object call constructor, store wrapper? e.g. public class mywrapper { public thirdpartyobject thirdpartyinstance { get; set; } public mywrapper() { thirdpartyinstance = new thirdpartyobject("constructors"); } }
Read more

c# - ReportViewer control - axd url -

-
i've embedded microsoft.reporting.webforms.reportviewer control in aspx. site works on mysite.com. when try exmple export report, there new black window opened address mysite.com/reserved.reportviewerwebcontrol.axd... it's working fine. but.. pass axd via proxy. mean, i'd force export use url myproxy.mysite.com/reserved.reportviewerwebcontrol.axd... redirect request mysite.com/reserved.reportviewerwebcontrol.axd... i've noticed, link build within js (that inlcuded in axd): exportreport: function(format) { if (this.exporturlbase == null) return false; window.open(this.exporturlbase + encodeuricomponent(format), "_blank"); return true; }, the url axd stored in exporturlbase . how can change proxy serwer url? it possible modify exporturlbase field in javascript. report stored in placeholder somewhere on page, once found can create call _getinternalviewer() function on gain access exporturlbase. have @ following code: ...
Read more

time series - R growth rate calculation week over week on daily timeseries data -

-
i'm trying calculate w/w growth rates entirely in r. use excel, or preprocess ruby, that's not point. data.frame example date gpv type 1 2013-04-01 12900 office 2 2013-04-02 16232 office 3 2013-04-03 10035 office i want factored 'type' , need wrap date type column weeks. , calculate week on week growth. i think need ddply group week - custom function determines if date in given week or not? then, after that, use diff , find growth b/w weeks divided previous week. then i'll plot week/week growths, or use data.frame export it. this closed had same useful ideas. update: answer ggplot: all same below, use instead of plot ggplot(data.frame(week=seq(length(gr)), gr), aes(x=week,y=gr*100)) + geom_point() + geom_smooth(method='loess') + coord_cartesian(xlim = c(.95, 10.05)) + scale_x_discrete() + ggtitle('week on week growth rate, apr 1') + ylab('growth rate %') (old, correct answer using plot) w...
Read more