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.