I have a static sitmap now I need to make it dynamic using database. plase help me.
like such code I have and table name submenu.

<?xml version="1.0" encoding="utf-8" ?>
<siteMap xmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" >
  <!--<siteMapNode url="" title=""  description="">
        <siteMapNode url="" title=""  description="" />
        <siteMapNode url="" title=""  description="" />
    </siteMapNode>-->
  <siteMapNode url="">
    <siteMapNode url="~/" description="Accounting" title="Accounting">
      <siteMapNode url="frmStandardJournalVEntry.aspx" title="Standard Journal Voucher Entry (SJV)"  description="Standard Journal Voucher Entry Page" />
      <siteMapNode url="CashPaymentVoucher.aspx" title="Cash Payment Voucher(CPV)"  description="Cash Payment Voucher Page" />
      <siteMapNode url="FrmChaquePaymentVoucher.aspx" title="Cheque Payment Voucher(CRV)"  description="Cash Payment Voucher Page" />
      <siteMapNode url="frmCreditVoucherCash.aspx" title="Credit voucher-Cash"  description="Credit voucher-Cash Page" />
      <siteMapNode url="frmCreditVouchercheque.aspx" title="Credit Voucher Cheque"  description="Credit Voucher Cheque Page" />
      <siteMapNode url="SqlDataSource.aspx" title="Voucher Review"  description="Voucher Review Page" />
      <siteMapNode url="" title="Supplier Information"  description="Supplier Information" />
      <siteMapNode url="" title="Contra Voucher"  description="Contra Voucher" />
    </siteMapNode>
    <siteMapNode url="~/s.aspx" description="Reporting" title="Reporting">
      <siteMapNode url="CheckBox2.aspx" title="Standard Journal Voucher Entry (SJV)"  description="Standard Journal Voucher Entry Page" />
      <siteMapNode url="BulletedList2.aspx" title="Cash Payment Voucher(CPV)"  description="Cash Payment Voucher Page" />
      <siteMapNode url="" title="Credit voucher-Cash"  description="Credit voucher-Cash Page" />
      <siteMapNode url="CheckBoxList2.aspx" title="Credit Voucher Cheque"  description="Credit Voucher Cheque Page" />
      <siteMapNode url="SqlDataSource2.aspx" title="Voucher Review"  description="Voucher Review Page" />
      <siteMapNode url="XmlDataSource2.aspx" title="Supplier Information"  description="Supplier Information" />
      <siteMapNode url="" title="Contra Voucher"  description="Contra Voucher" />
      <siteMapNode url="" title="Standard Journal Voucher Entry (SJV)"  description="Standard Journal Voucher Entry Page" />
      <siteMapNode url="" title="Cash Payment Voucher(CPV)"  description="Cash Payment Voucher Page" />
      <siteMapNode url="" title="Credit voucher-Cash"  description="Credit voucher-Cash Page" />
      <siteMapNode url="" title="Credit Voucher Cheque"  description="Credit Voucher Cheque Page" />
      <siteMapNode url="" title="Voucher Review"  description="Voucher Review Page" />
      <siteMapNode url="" title="Supplier Information"  description="Supplier Information" />
      <siteMapNode url="" title="Contra Voucher"  description="Contra Voucher" />
      <siteMapNode url="" title="Contra Voucher"  description="Contra Voucher" />
      <siteMapNode url="" title="Standard Journal Voucher Entry (SJV)"  description="Standard Journal Voucher Entry Page" />
      <siteMapNode url="" title="Cash Payment Voucher(CPV)"  description="Cash Payment Voucher Page" />
      <siteMapNode url="" title="Credit voucher-Cash"  description="Credit voucher-Cash Page" />
      <siteMapNode url="" title="Credit Voucher Cheque"  description="Credit Voucher Cheque Page" />
      <siteMapNode url="" title="Voucher Review"  description="Voucher Review Page" />
      <siteMapNode url="" title="Supplier Information"  description="Supplier Information" />
      <siteMapNode url="" title="Contra Voucher"  description="Contra Voucher" />
    </siteMapNode>
    <siteMapNode url="~/b.aspx" description="Setting" title="Setting">
      <siteMapNode url="" title="Account Information"  description="Account Information" />
    </siteMapNode>
    <siteMapNode url="~/c.aspx" description="Administration" title="Accounting">
      <siteMapNode url="" title="Clear Table"  description="Clear Table" />
    </siteMapNode>
  </siteMapNode>
</siteMap>

plase make it as a compleate dynamic using 'submenu' table data.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.