Question

c# 如何在aspx.cs文件中遍历输出数据库表中某一字端的全部信息,比如说字端id有三个怎么得到这三个值呢?

Answer 1

DataTable dt=new DataTable();
SqlConnection conn=new SqlConnection("数据库连接");
conn.Open();
SqlCommand cmd=new SqlCommand("sql statement",conn);
SqlDataReader dr
using(dr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
dt.Load(dr);
}
foreach(DataRow row in dt.Rows)
{
Response.Write(row["id"]);
}

Answer 2

string constr = "数据库连接";
System.Data.IDbConnection cn = new System.Data.SqlClient.SqlConnection(constr);
System.Data.IDbCommand dbCmd = cn.CreateCommand();
dbCmd.CommandText = "sql statement";
dbCmd.CommandType = System.Data.CommandType.StoredProcedure;//CommandType的枚举值
cn.Open();
System.Data.IDataReader dbReader = dbCmd.ExecuteReader();
while (dbReader.Read())
{
Response.Write(dbReader["id"].ToString());
}
dbReader.Dispose();
if (!dbReader.IsClosed) dbReader.Close();
cn.Close();

Answer 3

select id from 表名