asp.net - Inserting data into multiple tables using single RadDataForm with EntityDataSource -
i have scenario in have insert data multiple tables using single raddataform entitydatasource
following 3 tables , columns comtype: id, contype
contactdetail: id, contactname, city
contactcom: id, contactdetailsid, comtypeid, comvalue
the point able insert single table not able insert multiple tables.
[
<asp:label id="comvaluelabel3" runat="server" associatedcontrolid="comvaluetextbox" cssclass="rdflabel rdfblock" text="comvalue"></asp:label> <telerik:radtextbox id="comvaluetextbox" runat="server" rendermode="lightweight" text='<%# bind("comvalue") %>' wrappercssclass="rdfinput" />
]1
following syntax of calling other tables columns while insertion
<asp:label id="contactnamelabel2"runat="server"associatedcontrolid="contactnametextbox" cssclass="rdflabel rdfblock" text="contactname"></asp:label> <telerik:radtextbox id="contactnametextbox" runat="server" rendermode="lightweight" text='<%# bind("contactdetail.contactname") %>' wrappercssclass="rdfinput" /> <asp:label id="citylabel2" runat="server" associatedcontrolid="citytextbox" cssclass="rdflabel rdfblock" text="city"></asp:label> <telerik:radtextbox id="citytextbox" runat="server" rendermode="lightweight" text='<%# bind("contactdetail.city") %>' wrappercssclass="rdfinput" />
entitydatasource code:
<asp:entitydatasource id="entitydatasource1" runat="server" connectionstring="name=sampleentities" defaultcontainername="sampleentities" enabledelete="true" enableflattening="false" enableinsert="true" enableupdate="true"entitysetname="contactcoms" entitytypefilter="contactcom" include="contactdetail,comtype"></asp:entitydatasource>
i unable call columns of other tables in include method
here attaching sample db , full code of scenario
how can accomplish this
thanks in advance
Comments
Post a Comment