JScript.Net之SqlDataReader读取数据

最新推荐文章于 2024-09-21 22:02:19 发布

zgqtxwd

最新推荐文章于 2024-09-21 22:02:19 发布

阅读量274

点赞数

分类专栏： javascript 文章标签： string database sql import server table

javascript 专栏收录该内容

589 篇文章 0 订阅

订阅专栏

<%@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();
}
%> < <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>