im dabbling in wpf , datasets first time apologies if question basic.
i have product table , productsubcategory in dataset have created relationship between based on productsubcategoryid columns in both tables.
from datasources window able successfuly drag columns producttable onto form , have code allows me navigate through records. can make changes , save records. works fine
for product subcategory dragged combo box onto form , set displayname description (from productsubcategory table). works fine meaning displays correct productsubcategory description product when has one. combo box has solitary entry
what want populate combo box entries productsubcategory table user can select different 1 if want , have save when save product record.
here xaml page
the combo box named 'namecombobox'
<grid x:name="grid1" datacontext="{staticresource productviewsource}" horizontalalignment="left" margin="71,36,0,0" grid.row="1" verticalalignment="top"> <grid.columndefinitions> <columndefinition width="auto"/> <columndefinition width="auto"/> </grid.columndefinitions> <grid.rowdefinitions> <rowdefinition height="auto"/> <rowdefinition height="auto"/> <rowdefinition height="auto"/> <rowdefinition height="auto"/> <rowdefinition height="auto"/> </grid.rowdefinitions> <label content="product id:" grid.column="0" horizontalalignment="left" margin="3" grid.row="0" verticalalignment="center"/> <textbox x:name="productidtextbox" grid.column="1" horizontalalignment="left" height="23" margin="3" grid.row="0" text="{binding productid, mode=oneway}" verticalalignment="center" width="120"/> <label content="name:" grid.column="0" horizontalalignment="left" margin="3" grid.row="1" verticalalignment="center"/> <textbox x:name="nametextbox" grid.column="1" horizontalalignment="left" height="23" margin="3" grid.row="1" text="{binding name, mode=twoway, notifyonvalidationerror=true, validatesonexceptions=true}" verticalalignment="center" width="120"/> <label content="product number:" grid.column="0" horizontalalignment="left" margin="3" grid.row="2" verticalalignment="center"/> <textbox x:name="productnumbertextbox" grid.column="1" horizontalalignment="left" height="23" margin="3" grid.row="2" text="{binding productnumber, mode=twoway, notifyonvalidationerror=true, validatesonexceptions=true}" verticalalignment="center" width="120"/> <label content="make flag:" grid.column="0" horizontalalignment="left" margin="3" grid.row="3" verticalalignment="center"/> <checkbox x:name="makeflagcheckbox" content="" grid.column="1" horizontalalignment="left" ischecked="{binding makeflag, mode=twoway, notifyonvalidationerror=true, validatesonexceptions=true}" margin="3" grid.row="3" verticalalignment="center"/> <label content="color:" grid.column="0" horizontalalignment="left" margin="3" grid.row="4" verticalalignment="center"/> <textbox x:name="colortextbox" grid.column="1" horizontalalignment="left" height="23" margin="3" grid.row="4" text="{binding color, mode=twoway, notifyonvalidationerror=true, validatesonexceptions=true}" verticalalignment="center" width="120"/> </grid> <grid x:name="grid5" datacontext="{staticresource productproductsubcategoryviewsource}" horizontalalignment="left" margin="208,214,0,0" grid.row="1" verticalalignment="top"> <grid.columndefinitions> <columndefinition width="auto"/> <columndefinition width="auto"/> </grid.columndefinitions> <grid.rowdefinitions> <rowdefinition height="auto"/> </grid.rowdefinitions> <label content="name:" grid.column="0" horizontalalignment="left" margin="-133,-10,0,16" grid.row="0" verticalalignment="center"/> <combobox x:name="namecombobox" displaymemberpath="name" horizontalalignment="left" height="auto" itemssource="{binding}" margin="-27,-10,0,20" grid.row="0" verticalalignment="center" width="120" grid.columnspan="2"> <combobox.itemspanel> <itemspaneltemplate> <virtualizingstackpanel/> </itemspaneltemplate> </combobox.itemspanel> </combobox> </grid> </grid>
Comments
Post a Comment