111,097
社区成员




public partial class DataRead : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string str = "server=localhost;uid=sa;pwd=123456;database=DataTest";
SqlConnection conn = new SqlConnection(str);
string sql = "select * from student";
SqlDataAdapter adp = new SqlDataAdapter(sql, conn);//Adepter对象
DataSet ds = new DataSet();//DataSet对象
adp.Fill(ds, "stu");//填充DataSet 并为当前表命名
DataTableReader rdr = ds.CreateDataReader();
while (rdr.Read())//读取表中数据
{
Response .Write("第n条数据");
}
}
}