JScript.Net 之 SqlDataReader读取数据

JScript.Net 之 SqlDataReader读取数据

- 中国WEB开发者网络 (http://www.webasp.net)
-- 技术教程 (http://www.webasp.net/article/)
--- JScript.Net 之 SqlDataReader读取数据 (http://www.webasp.net/article/24/23596.htm)

-- 作者：未知
-- 发布日期： 2005-05-09

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

webasp.net