No DB table output on IE browser when App submitted from Visual St

Guest · Nov 11, 2004

Just loaded my Laptop with XP Pro, SQL 8.0, and IIS server for the first
time. I installed student cd samples and they run fine on the browser for
SQL and Access databases when i just type the url 'hhtp://localhost/....".
PROBLEM: I copied the code and created a new project in Visual Studio and ran
my app - it finally runs on the browser with no errors but I do not get any
output for both access and SQL. Help please with restrictions on IIS or
Visual studio that is preventing any output from showing.

Guest · Nov 12, 2004

hi Bildo...

Guest · Nov 12, 2004

Thanks for looking at this so quick.
here is the code:
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
<%@ Page Language="vb" CodeBehind="DisplayDataSetItems.aspx.vb"
AutoEventWireup="false" Inherits="tstwebapp.DisplayDataSetItems" %>
<HTML>
<HEAD>
<script language="VB" runat="server">
Sub Page_Load
Dim myDS As New DataSet()
Dim ConnStr As String
ConnStr =
"server=DCXK7X51\sqlapps;database=pubs;Trusted_Connection=yes"
Dim SQLSelect As String
SQLSelect = "SELECT * FROM Titles "
SQLSelect &= "SELECT * FROM Publishers"
Dim mySqlConn As New SqlConnection(ConnStr)
Dim mySqlDA As New SqlDataAdapter(SQLSelect, ConnStr)

mySqlDA.Fill(myDS)

' Get Each DataTable in the DataTableCollection and print each row
value.
Dim CurrentTable As DataTable
Dim CurrentRow As DataRow
Dim CurrentColumn As DataColumn
For Each CurrentTable In myDS.Tables
value.Text &= "Table: " & CurrentTable.TableName & "<br/>"
value.Text &= "---------------------------------<br/>"
For Each CurrentRow In CurrentTable.Rows
value.Text &= "<br/>  "
For Each CurrentColumn in CurrentTable.Columns
If Not (CurrentRow(CurrentColumn) Is Nothing) Then
If Not IsDbNull(CurrentRow(CurrentColumn)) Then
value.Text &= CStr(CurrentRow(CurrentColumn))
Else
value.Text &= "NULL"
End If
value.Text &= "<br/>  "
End If
Next
If CurrentRow.RowState = DataRowState.Unchanged Then
value.Text &= "Unchanged<br/>  "
End If
Next
value.Text &= "---------------------------------<br/>"
value.Text &= "<br/><br/>"
Next
End Sub
</script>
</HEAD>
<body>
<asp:literal id="value" runat="server" />
</body>
</HTML>

VS app does not show SQL or Access DB result in IE browser.	4	Nov 12, 2004
See no controls on browser	4	Dec 10, 2003
can't create web app in visual studio	3	Sep 19, 2006
Http 403 Response, rather than default.aspx, when site's root requested	8	Jul 25, 2009
Deploying web app on server	8	Jul 4, 2005
Visual Studio .NET setup from hell	7	May 10, 2005
Cookies from ASP.NET app not persisting even when enabled!	2	Feb 4, 2004
devenv.exe and others causing stop error (BSOD) 0x50 (Visual Studio 2005)	0	Jun 22, 2007

No DB table output on IE browser when App submitted from Visual St

Guest

Guest

Guest

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads