<% @ import namespace = "system.data.sqlclient"%>
VAR DB: STRING = "Server = 10.1.0.1; UID = SA; PWD = 123; Database = DB";
Var SQL: String = "SELECT * from Table";
Var = SqlDataReader;
Var conn: SqlConnection = New SqlConnection (DB);
VAR CMD: SQLCommand = New SQLCOMMAND (SQL, CONN);
Try {
Cn.open ();
RS = cmd.executeReader ();
IF (Rs.hasRows)
{
// Founded.
}
Else
{
// Not found.
While (RS.Read ())
{
Response.write (RS ["ID"] .tostring ());
}
}
Rs.close ();
CONN.CLOSE ();
} catCH (e) {
Response.write ("Error!");
} finally {
cmd.dispose ();
Conn.dispose ();
}
%>
