DataSet與DataAdapter初步

protected void Page_Load(object sender, EventArgs e)
    {
        String connStr = System.Configuration.ConfigurationSettings.AppSettings["connstring"].ToString();
        SqlConnection myStr = new SqlConnection(connStr);
        myStr.Open();

        SqlDataAdapter da = new SqlDataAdapter("select * from info",myStr);
        DataSet ds = new DataSet();
        da.Fill(ds,"info");
        if(ds.Tables[0].Rows.Count == 0){
            Response.Write("資料庫中無資料");            
        }else{
            for (int i = 0; i < ds.Tables[0].Rows.Count;i++ )
            {
                Response.Write(ds.Tables["info"].Rows[i]["name"]);
                Response.Write(ds.Tables["info"].Rows[i]["sex"]);
                Response.Write("<br>");
            }
        }
    }