No Data Being Shown

Jatherton99 · Jun 13, 2002

I can create a project, then a data connection and then a data command. I can see the tables and data so I know that I am connecting to the database. I can add recordsets and fields the like from the database. The problem is when I try to view the page in my browser it comes up with the text boxes empty. The record navagation buttons are visible but nothing else.

I am testing on a machine running Win2K with IIS5.0 and Visual InterDev 6.0. Attempted both SQL and Access databases. Please help. Newbie banging his head against the wall!

Dynapen · Jun 20, 2002

Can you post us a example of the code you are using. Even if it's just a shortened version. Then we can see if maybe we can find something in the code that you are missing. The money's gone, the brain is shot.....but the liquor we still got.

Jatherton99 · Jun 30, 2002

<html>
<head>
<meta NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<title></title>

<link REL="stylesheet" TYPE="text/css" HREF="_Themes/auto/THEME.CSS" VI6.0THEME="Automotive">
<link REL="stylesheet" TYPE="text/css" HREF="_Themes/auto/GRAPH0.CSS" VI6.0THEME="Automotive">
<link REL="stylesheet" TYPE="text/css" HREF="_Themes/auto/COLOR0.CSS" VI6.0THEME="Automotive">
<link REL="stylesheet" TYPE="text/css" HREF="_Themes/auto/CUSTOM.CSS" VI6.0THEME="Automotive"></head>
<body>




<table border="0" width="100%" height="100%">
<tr>
<td rowspan="2" width="120" valign="top">







</td>
<td height="40" valign="top">







</td>
</tr>
<tr>
<td width="100%" valign="top">





<p>

<SCRIPT LANGUAGE="JavaScript" src="_ScriptLibrary/EventMgr.HTM"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript" src="_ScriptLibrary/Recordset.HTM"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript">
function _initRecordset1()
{
Recordset1.setRecordSource('Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Northwind;Data Source=JATHERTON;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=JATHERTON;Use Encryption for Data=False;Tag with column collation when possible=False', 'SELECT Products.* FROM Products');
Recordset1.open();

}
CreateRecordset('Recordset1', _initRecordset1, null);
</SCRIPT>


</p>
<p>ProductName

<script language="JavaScript" src="_ScriptLibrary/TextBox.HTM"></script>
<SCRIPT LANGUAGE=JavaScript>
function _initTextbox1()
{
Textbox1.setStyle(TXT_TEXTBOX);
Textbox1.setDataSource(Recordset1);
Textbox1.setDataField('ProductName');
Textbox1.setMaxLength(40);
Textbox1.setColumnCount(20);
}
CreateTextbox('Textbox1', _initTextbox1, null);
</script>


</p>
<p>QuantityPerUnit

<SCRIPT LANGUAGE=JavaScript>
function _initTextbox2()
{
Textbox2.setStyle(TXT_TEXTBOX);
Textbox2.setDataSource(Recordset1);
Textbox2.setDataField('QuantityPerUnit');
Textbox2.setMaxLength(20);
Textbox2.setColumnCount(20);
}
CreateTextbox('Textbox2', _initTextbox2, null);
</script>


</p>
<p>UnitPrice

<SCRIPT LANGUAGE=JavaScript>
function _initTextbox3()
{
Textbox3.setStyle(TXT_TEXTBOX);
Textbox3.setDataSource(Recordset1);
Textbox3.setDataField('UnitPrice');
Textbox3.setMaxLength(19);
Textbox3.setColumnCount(20);
}
CreateTextbox('Textbox3', _initTextbox3, null);
</script>


</p>
<p>

<script language="JavaScript" src="_ScriptLibrary/Button.HTM"></script>
<script language="JavaScript" src="_ScriptLibrary/RSNavBar.HTM"></script>
<SCRIPT LANGUAGE=JavaScript>
function _initRecordsetNavbar1()
{
RecordsetNavbar1.setAlignment(1);
RecordsetNavbar1.setButtonStyles(170);
RecordsetNavbar1.updateOnMove = false;
RecordsetNavbar1.setDataSource(Recordset1);
RecordsetNavbar1.getButton(0).value = ' |< ';
RecordsetNavbar1.getButton(1).value = ' < ';
RecordsetNavbar1.getButton(2).value = ' > ';
RecordsetNavbar1.getButton(3).value = ' >| ';
}
CreateRecordsetNavbar('RecordsetNavbar1', _initRecordsetNavbar1, null);
</script>


</p>
<p>




</p>
</td>
</tr>
</table>




</body>
</html>

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

No Data Being Shown

Jatherton99

IS-IT--Management

Dynapen

Programmer

Jatherton99

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor