using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) { SqlConnection conn = dbconn.crtConn();//调用静态数据库连接类,并实例化 conn.Open(); SqlCommand cmd = new SqlCommand(select name from sort,conn); //建立command 命令 ,并实例化为cmd try //试着读取数据库,如果没有错误,则执行下面错作 { SqlDataReader rs = cmd.ExecuteReader();//从数据源中读取数据,并将数据返回到rs中 while (rs.Read()) //使用rs.read()输出rs中的数据内容 { Response.Write(rs.GetString(0)+br); //数据内容 }