JScript.Net 之 SqlDataReader读取数据

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

zgqtxwd

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

阅读量262

点赞数

分类专栏： 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>