|
|
JScript.Net 之 SqlDataReader读取数据 |
|
|
作者:未知 来源:月光软件站 加入时间:2005-2-28 月光软件站 |
<%@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(); } %>
|
|
相关文章:相关软件: |
|