JScript.Net 之 SqlDataReader读取数据

js|jscript|数据

<%@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 rs = SqlDataReader;
var conn : SqlConnection = new SqlConnection(db);
var cmd : SqlCommand = new SqlCommand(sql,conn);
            
try{

    conn.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();
}
%>