I am trying to query data from a MS SQL server with a C# web form without “CodeBehind”. I want to write the information to a table in the web form’s body.
I am having trouble declaring the SqlConnection and SqlCommand objects that connect to the server.

How do you use “using System;”, “using System.Data;”, “using System.Data.SqlClient” inside of script element of as .aspx file?


I know how to do it with JavaScript and ADO. (code below)

<html><head><table>
<%@ language="javascript" %>
<%
var sqlstr = " ";
var conn_str = " ";
var AdOpenForwardOnly = 0;
var adLockReadOnly = 1;
var rs = new ActiveXObject("ADODB.Recordset");
var conn = new ActiveXObject("ADODB.Connection");

conn_str = "PROVIDER=SQLOLEDB;Server=my_server;" +
"Database=db_myDatabase;User ID=myUserID;" +
"Password=myPassword;"

sqlstr = "SELECT * FROM [myTable]";

conn.open(conn_str, "", "");
rs.open(sqlstr, conn, AdOpenForwardOnly, adLockReadOnly);

while(!rs.eof)
{
Response.write("<tr><td>" + rs(0));
Response.write("</td><td>"+ rs(1));
Response.write("</td><td>"+ rs(2));
Response.write("</td></tr>");

rs.MoveNext();
}
%></tbody></table></body></html>


Any suggestions, links to articles or tutorials would be greatly appreciated.