i have one html page.

I want display data from database.

i have created one asp file that display data from database

also i have created html file which contains all design of web page.

when i combine this two . it displays table from database but images are not displayed .

I m sending my both files

status-check.html

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Digicomp </title>

<link href="../includes/digi-style.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" type="text/css" href="../includes/ddlevelsmenu-base.css" />
<script type="text/javascript" src="../includes/ddlevelsmenu.js"></script>
<style type="text/css">

.suckertreemenu ul{
margin: 0;
padding: 0;
list-style-type: none;
font-family:Arial, Helvetica, sans-serif;
text-align: left;
z-index:-1;
display: block;
}

.suckertreemenu ul li{
position: relative;
display: inline;
float: left;
BACKGROUND-COLOR: #d9d9d9;
z-index: 1000;
}

.suckertreemenu ul li a{
border-left-width: 0;
text-decoration: none;
color: #5c5b5a;
z-index: 1000;
}
	
.suckertreemenu ul li ul{
left: 0;
position: absolute;
top: 1em; /* no need to change, as true value set by script */
display: block;
visibility: hidden;
}

.suckertreemenu ul li ul li{
display: list-item;
float: none;
}
.cobalt{
left:66px;
}
.suckertreemenu ul li ul li ul{ 
left: 159px; /* no need to change, as true value set by script */
top: 0;
}

.suckertreemenu ul li ul li a{
    PADDING-RIGHT: 0px;
    BORDER-TOP: #ffffff 1px solid;
    MARGIN-TOP: 0px;
    DISPLAY: block;
    PADDING-LEFT: 0px;
    FONT-WEIGHT: normal;
    BACKGROUND: #d9d9d9;
    LIST-STYLE-IMAGE: none;
    MARGIN-BOTTOM: 0px;
    PADDING-BOTTOM: 0px;
    BORDER-LEFT: #b1d9ef 4px solid;
    WIDTH: 100%;
    COLOR: #5c5b5a;
    TEXT-INDENT: 7px;
    PADDING-TOP: 3px;
    BORDER-BOTTOM: #bcbcbc 3px solid;
    TEXT-ALIGN: left;
    TEXT-DECORATION: none;
font-size:10px;
}

.suckertreemenu ul li a:hover{
 BACKGROUND-COLOR: transparent
color: #FFFFFF;text-decoration:none;
}


* html p#iepara{ /*For a paragraph (if any) that immediately follows suckertree menu, add 1em top spacing between the two in IE*/
padding-top: 2em;
}

	
	.suckertreemenu .mainfoldericon{
background:no-repeat center right;
}

.suckertreemenu .subfoldericon{
background:no-repeat center right;
}

* html .suckertreemenu ul li { float: left; height: 1%; }
* html .suckertreemenu ul li a { height: 1%; }
* html .suckertreemenu ul li ul li { float: left;}

</style>
<script type="text/javascript">

var menuids=["treemenu1"] //Enter id(s) of SuckerTree UL menus, separated by commas

function buildsubmenus_horizontal(){
for (var i=0; i<menuids.length; i++){
  var ultags=document.getElementById(menuids[i]).getElementsByTagName("ul")
    for (var t=0; t<ultags.length; t++){
		if (ultags[t].parentNode.parentNode.id==menuids[i]){ //if this is a first level submenu
			ultags[t].style.top=ultags[t].parentNode.offsetHeight+"px" //dynamically position first level submenus to be height of main menu item
			ultags[t].parentNode.getElementsByTagName("a")[0].className="mainfoldericon"
		}
		else{ //else if this is a sub level menu (ul)
		  ultags[t].style.left=ultags[t-1].getElementsByTagName("a")[0].offsetWidth+"px" //position menu to the right of menu item that activated it
    	ultags[t].parentNode.getElementsByTagName("a")[0].className="subfoldericon"
		}
    ultags[t].parentNode.onmouseover=function(){
    this.getElementsByTagName("ul")[0].style.visibility="visible"
    }
    ultags[t].parentNode.onmouseout=function(){
    this.getElementsByTagName("ul")[0].style.visibility="hidden"
    }
    }
  }
}

if (window.addEventListener)
window.addEventListener("load", buildsubmenus_horizontal, false)
else if (window.attachEvent)
window.attachEvent("onload", buildsubmenus_horizontal)


</script>

</head>
<body>

<table class="main"  border="0" align="center" cellpadding="0" cellspacing="0">
  
  
  <tr>
    <td colspan="3"><!-- #BeginLibraryItem "/Library/header.lbi" --><table width="100%" border="0" cellspacing="0" cellpadding="0" class="header">
	  <tr>
		<td align="right"><a href="../index.html">Home</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="../sitemap.html">Site Map</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="../contact-us.html">Contact Us</a></td>
		<td width="30">&nbsp;</td>
	  </tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="100" height="78" valign="top"><a href="http://www.alliedindia.com/" target="_blank"><img src="../images/logo_AD.gif" border="0" /></a></td>
        <td width="98" align="left" valign="top"><img src="../images/logo_DC.gif" /></td>
        <td width="510" align="left"><img src="../images/welcome.gif" alt="" /></td>
        <td width="183" align="center" valign="middle"><form action="../search.php" method="post" name="search_form" id="search_form" style="padding:0px;margin:0px;" onsubmit="return fnsearch();">
            <table border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td><input name="btnsearch" type="text" class="top_searchbox" onfocus="javascript:fnfocus(this);" onblur="javascript:fnblur(this);" value="Search" /></td>
                <td><input name="image" type="image" src="../images/top_search_btn.png" border="0" /></td>
              </tr>
            </table>
        </form></td>
      </tr>
    </table><!-- #EndLibraryItem --></td>
  </tr>
  <tr>
    <td colspan="3"><OBJECT id=obj1 style="LEFT: 0px; TOP: 0px" codeBase=http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0 
 height=244 width=891 border=0 classid="clsid:D27CDB6E-AE6D-11CF-96B8-444553540000" VIEWASTEXT>
 <PARAM NAME="_cx" VALUE="23574">
 <PARAM NAME="_cy" VALUE="6456">
 <PARAM NAME="FlashVars" VALUE="">
 <PARAM NAME="Movie" VALUE="../images/banner.swf">
 <PARAM NAME="Src" VALUE="../images/banner.swf">
 <PARAM NAME="WMode" VALUE="Transparent">
 <PARAM NAME="Play" VALUE="-1">
 <PARAM NAME="Loop" VALUE="-1">
 <PARAM NAME="Quality" VALUE="High">
 <PARAM NAME="SAlign" VALUE="">
 <PARAM NAME="Menu" VALUE="-1">
 <PARAM NAME="Base" VALUE="">
 <PARAM NAME="AllowScriptAccess" VALUE="">
 <PARAM NAME="Scale" VALUE="ShowAll">
 <PARAM NAME="DeviceFont" VALUE="0">
 <PARAM NAME="EmbedMovie" VALUE="0">
 <PARAM NAME="BGColor" VALUE="">
 <PARAM NAME="SWRemote" VALUE="">
 <PARAM NAME="MovieData" VALUE="">
 <PARAM NAME="SeamlessTabbing" VALUE="1">
 <PARAM NAME="Profile" VALUE="0">
 <PARAM NAME="ProfileAddress" VALUE="">
 <PARAM NAME="ProfilePort" VALUE="0">
 <PARAM NAME="AllowNetworking" VALUE="all">
 <PARAM NAME="AllowFullScreen" VALUE="false">
 
      
  <embed src="../images/banner.swf" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" name="obj1" width="891" height="244" quality="High"></OBJECT></td>
  </tr>
  <tr>
    <td colspan="3" class="gap"></td>
  </tr>
  <tr>
    <td colspan="3" valign="top" class="nav">	
	  <table width="884" align="center" >
        <tr >
          <td width="90" height="36">&nbsp; </td>
          <td width="782" align="left" valign="top" style="padding-top:5px;"><div class="suckertreemenu">
              <ul id="treemenu1">
                   <li><a href="../about-us/about-us.html">About Digicomp</a>&nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;&nbsp;
                       <ul style="width:120PX; padding-top:8px;">
                         <li><a href="../about-us/about-us.html" target="_parent" rel="ddsubmenu1" >About Company</a></li>
                         <li><a href="../about-us/about-company.html" target="_parent" >Company Profile</a></li>
                         <li><a href="../about-us/about-business-model.html" target="_parent" >Business Model</a></li>
                         <li><a href="../about-us/about-brief-history.html" target="_parent" >Brief History</a></li>
                         <li><a href="../about-us/about-digicomp-team.html" target="_parent" >Team Digicomp</a></li>
                         <li><a href="../about-us/about-why-digicomp.html" target="_parent" >Why Digicomp</a></li>
                         <li><a href="../about-us/about-quality-policy.html" target="_parent" >Quality Policy</a></li>
                         <li><a href="../about-us/about-vision.html" target="_parent" >Vision</a></li>
					  <li><a href="../about-us/parentcompany.html" target="_parent" >Parent Company</a></li>
					  <li><a href="../about-us/jointventure.html" target="_parent" >Joint Ventures</a></li>
                       </ul>
                   </li>
                   <li> <a href="#" rel="ddsubmenu2">Hardware Services</a>&nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;&nbsp;
                       <ul style="width:170PX; padding-top:8px;">
                         <li><a href="hardwareservices.html" target="_parent" >&nbsp;Hardware Services</a></li>
                         <li><a href="complete-service-solution.html" target="_parent" >&nbsp;Complete Service Solution</a></li>
                         <li><a href="digicomp-advantages.html" target="_parent" >&nbsp;Digicomp Advantage</a></li>
                         <li><a href="servicemodel.html" target="_parent" >&nbsp;Service Business Model</a></li>
                         <li  class="nav1"><a href="#"><span class="right-a">&raquo;</span>&nbsp;Services offered </a>
                             <ul  style="width:170PX;">
                               <li><a href="front-end-services.html" target="_parent" >Front End Services</a></li>
                               <li><a href="onsite-support-services.html" target="_parent" >Onsite Support Services</a></li>
                               <li><a href="back-end-services.html" target="_parent" >Backend Services</a></li>
                             </ul>
                         </li>
                         <li><a href="reverse-logistics.html" target="_parent" >&nbsp;Reverse Logistics</a></li>
                         <li><a href="logistics.html" target="_parent" >&nbsp;Logistics</a></li>
                         <li><a href="international-rma.html" target="_parent" >&nbsp;International RMA</a></li>
                         <li><a href="faqs.html" target="_parent" >&nbsp;Frequently Asked Questions</a></li>
                         <li class="nav1"><a href="#"><span class="right-a">&raquo;</span>&nbsp;Man / Machine / Process </a>
                             <ul style="width:170PX;">
                               <li><a href="man-machine-process.html" target="_parent" >Man / Machine / Process</a></li>
                               <li><a href="repair-infrastructure.html" target="_parent" >Repair Infrastructure</a></li>
                             </ul>
                         </li>
                         <li class="nav1"><a href="#"><span class="right-a">&raquo;</span>&nbsp;Quick Support </a>
                             <ul style="width:170PX;">
                               <li><a href="customer-registration.html" target="_parent" >Customer Registration</a></li>
                               <li><a href="asus-support.html" target="_parent" >ASUS Support</a></li>
                               <li><a href="status-check.html" target="_parent" >Status Check</a></li>
                             </ul>
                         </li>
                       </ul>
                   </li>
                   <li ><a href="#" rel="ddsubmenu3">Asset Recovery</a>&nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;&nbsp;
                       <ul style="width:180PX; padding-top:8px;">
                         <li class="nav1"> <a href="#"><span class="right-a">&raquo;</span>&nbsp;Asset Recovery </a>
                             <ul style="width:150PX;">
                               <li><a href="../asset-recovery/introduction.html" target="_parent" >Introduction</a></li>
                               <li><a href="../asset-recovery/asset-recovery-process.html" target="_parent" >Asset Recovery Process</a></li>
                               <li><a href="../asset-recovery/data-sanitization.html" target="_parent" >Data Sanitization</a></li>
                             </ul>
                         </li>
                         <li><a href="../asset-recovery/refurbishing-re-manufacturing.html" target="_parent" >&nbsp;Refurbishing/Remanufacturing</a></li>
                       </ul>
                   </li>
                   <li> <a href="#" rel="ddsubmenu4">Software Services</a>&nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;&nbsp;
                       <ul style="width:170PX; padding-top:8px;">
                         <li><a href="../software-services/software-about-software.html" target="_parent" >&nbsp;About Software Business</a></li>
                         <li class="nav1"><a href="#"><span class="right-a">&raquo;</span>&nbsp;Software Solutions </a>
                             <ul style="width:170PX;">
                               <li><a href="../software-services/software-dealership-management-system.html" target="_parent" >Dealer Management System</a></li>
                               <li><a href="../software-services/software-channel-management-system.html" target="_parent" >Channel Mangement System</a></li>
                               <li><a href="../software-services/software-pps-silk-exporters.html" target="_parent" >PPS for Silk Exporters</a></li>
                               <li><a href="../software-services/software-service-management-software.html" target="_parent" >Service/RMA Management</a></li>
                               <li><a href="../software-services/software-sales-management-software.html" target="_parent" >Sales Management</a></li>
                               <li><a href="../software-services/software-hr.html" target="_parent" >HR Management</a></li>
                             </ul>
                         </li>
                         <li class="nav1"><a href="#"><span class="right-a">&raquo;</span>&nbsp;Software Services</a>
                             <ul style="width:170PX;">
                               <li><a href="../software-services/software-maintenance.html" target="_parent" >Software Maintenance</a></li>
                               <li><a href="../software-services/software-training.html" target="_parent" >Training</a></li>
                               <li><a href="../software-services/software-manpower.html" target="_parent" >Manpower</a></li>
                             </ul>
                         </li>
                       </ul>
                   </li>
                   <li><a href="#" rel="ddsubmenu6">Reverse Logistics</a>&nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;&nbsp;
                       <ul style="width:180PX;padding-top:8px;">
                         <li><a href="../reverse-logistics.html" target="_parent" >Reverse Logistics</a></li>
                       </ul>
                   </li>
                   <li><a href="#" rel="ddsubmenu5">Clientele</a>
                       <ul style="width:180PX;padding-top:8px;">
                         <li><a href="../clientele/hardware-services.html" target="_parent" >Hardware Services</a></li>
                         <li><a href="../clientele/software-solutions-services.html" target="_parent" >Software Solutions &amp; Services</a></li>
                         <li><a href="../clientele/client-asset.html" target="_parent" >Asset Recovery</a></li>
                       </ul>
                   </li>
                 </ul>
          </div></td>
        </tr>
      </table></td>
  </tr>
  <tr>
    <td colspan="3" class="content">
	<!-- header ends -->


<!-- content starts -->
	<table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td align="left" valign="top" class="text-area">
		
		<h1>Status Check</h1>

<%
Set db = Server.CreateObject("ADODB.Connection")

db.Open "Provider=SQLOLEDB.1;Persist Security Info=False;UID=sa;PWD=dgsoft;Initial Catalog=DGTEST;Data Source=192.168.1.23"

Response.Write "Connected OK"

DIM mySQL
 mySQL = "SELECT * FROM tblInward where strInwardNo='D06073344'"

 DIM objRS
 Set objRS = Server.CreateObject("ADODB.Recordset")
 objRS.Open mySQL, db
%>
<%
Response.Write("<table border='1' cellpadding='2' bgcolor='#e59a26' WIDTH='600PX'>")
Response.Write("<tr><th>InwardNo</th><th>Inward Date</th><th>Status</th><th>Repair Status</th><th>Item Desc</th>")
Response.Write("</tr>")
%>

<%  DO WHILE NOT objRS.EOF %>
<tr><td><% Response.Write objRS("strInwardNo") %></td>
<td><% Response.Write objRS("strInwardDate") %></td>
<td><% Response.Write objRS("strStatus") %></td>
<td><% Response.Write objRS("strRepairStatus") %></td>
<td><% Response.Write objRS("strItemDesc") %></td></tr>

 <%
 objRS.MoveNext
 Loop

objRS.Close
 Set objRS = Nothing
 db.Close
 Set db= Nothing
 %> 
 </table>

		
		<table width="100%" border="0" cellpadding="5" cellspacing="0" class="textnormal">
          <tr>
            <td>Under Construction</td>
          </tr>
        </table></td>
        <td valign="top" class="rightarea"><!-- #BeginLibraryItem "/Library/st_alliance.lbi" --><span class="shop">Joint Venture</span><br />
      <br />
      <table width="80%" border="0" cellspacing="0" cellpadding="0" style="border:1px solid #ccc;">
        <tr>
          <td height="10"></td>
        </tr>
        
        <tr>
          <td align="center"><a href="../about-us/jointventure.html"><img src="../images/dets.jpg" width="141" height="31" border="0" /></a></td>
        </tr>
        <tr>
           <td height="10"></td>
        </tr>
      </table>
      <br /><!-- #EndLibraryItem --></td>
      </tr>
    </table>
	<!-- content ends -->	
	
	
<!-- footer starts --></td>
  </tr>
  <tr>
    <td colspan="3" class="divider-h">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="3" >
	
	<table width="100%" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td  align="center"><img src="../images/iso.gif" alt="" width="95" height="72" /></td>
          <td  align="center"><img src="../images/footer-highlights.gif" alt="" width="262" height="72" /></td>
          <td class="footer-text">
		    <ul>
		      <li><u>35 locations in India</u></li>
		    <li><u>Offering warranty support for major motherboard brands</u></li>
		     <li><u>Service on the web - Laptop and Motherboard repair services online</u></li>
		     <li><u>A strong workforce of 500+</u></li>
		    
          </ul>		  </td>
        </tr>
      </table>	  </td>
  </tr>
  <tr>
    <td colspan="3" >&nbsp;</td>
  </tr>
  <tr>
    <td colspan="3" class="footer-btm" >&nbsp;</td>
  </tr>
  <tr>
    <td colspan="3" class="footer-link" >
	Copyright © 2010. DIGICOMP Complete Solutions. All rights reserved
	<br />

Designed by <a href="http://www.rarepixeltech.com" target="_blank">RarePixel</a></td>
  </tr>
</table>

<!-- footer ends -->
</body>
</html>

status-check.asp

<html>
<head>
</head>

<body>

<%
Set db = Server.CreateObject("ADODB.Connection")

db.Open "Provider=SQLOLEDB.1;Persist Security Info=False;UID=sa;PWD=dgsoft;Initial Catalog=DGTEST;Data Source=192.168.1.23"

Response.Write "Connected OK"

DIM mySQL
 mySQL = "SELECT * FROM tblInward where strInwardNo='D06073344'"

 DIM objRS
 Set objRS = Server.CreateObject("ADODB.Recordset")
 objRS.Open mySQL, db
%>
<%
Response.Write("<table border='1' cellpadding='2' bgcolor='#e59a26' WIDTH='600PX'>")
Response.Write("<tr><th>InwardNo</th><th>Inward Date</th><th>Status</th><th>Repair Status</th><th>Item Desc</th>")
Response.Write("</tr>")
%>

<%  DO WHILE NOT objRS.EOF %>
<tr><td><% Response.Write objRS("strInwardNo") %></td>
<td><% Response.Write objRS("strInwardDate") %></td>
<td><% Response.Write objRS("strStatus") %></td>
<td><% Response.Write objRS("strRepairStatus") %></td>
<td><% Response.Write objRS("strItemDesc") %></td></tr>

 <%
 objRS.MoveNext
 Loop

objRS.Close
 Set objRS = Nothing
 db.Close
 Set db= Nothing
 %> 
 </table>



<form>
Name : <br>
<input type="text" size=10>
<input type="submit" value="OK">
</form>
</body>
</html>

please help me....i don't know what to do???

Recommended Answers

All 2 Replies

use iframe on your html page to display asp files.

<iframe src='helloworld.asp'></iframe>

i have one html page.
i have created one asp file that display data from database
also i have created html file which contains all design of web page.
when i combine this two . it displays table from database but images are not displayed .

Firstly, your database is calling a server on an intranet?

It should be obvious from the image links as to whether they point to the correct location or not. When yu load the page and see a broken image, right click to get image properties.

For example I see image links like "../images/some.gif" which suggest that the page is located in a folder and not at root level. Either way, a sure fix is changing those image links to... "/images/some.gif" and it won't matter which folder the page is in.

Also, your database is calling a server on an intranet?

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.