ASP.NET - How to display Recordset

ziycon

I have the below code but i can't display the recordset, maybe i'm doing it way to complicated!?

Expand|Select|Wrap|Line Numbers

 <% DIM strDataSourceName, objConn
 
Set objConn = Server.CreateObject("ADODB.Connection")
 
strDataSourceName="Provider=SQLOLEDB;Data Source=localhost,1433;Network Library=DBMSSOCN;Initial Catalog=testdb;User ID=testuser;Password=12345678;"
 
objConn.connectionstring = strDataSourceName

objConn.Open 
 
DIM mySQL

mySQL = "SELECT message FROM message_tbl WHERE id=1"
 
DIM objRS

Set objRS = Server.CreateObject("ADODB.Recordset")

objRS.Open mySQL, objConn %>

<html>

<head>

<title>ASP Test Page</title>

</head>

<body>

<% response.write() %>

</body>

</html>

<% objRS.Close

objConn.Close %>

GazMathias

You are not telling Response.Write what to write.

Try

Expand|Select|Wrap|Line Numbers

Response.Write objRS("message")

or

Expand|Select|Wrap|Line Numbers

<%=objRS("message")%>

jhardman

I'm confused, you say in your title that this is an ASP.NET question, yet you posted it in the "classic" ASP section, and the code sure looks like "classic" ASP written in VBScript. Perhaps the confusion stems from not knowing which version of ASP you are using.

Jared

ASP.NET - How to display Recordset

re: ASP.NET - How to display Recordset

re: ASP.NET - How to display Recordset

Similar ASP / Active Server Pages bytes

/bytes/development

/bytes/it

/bytes/about