C# 循环DataSet表里的数据

cs:DataSet ds = DbSqlClient.Query(sql);

页面：
foreach (System.Data.DataRow dr in ds.Tables["ds"].Rows)
{
    Response.Write(dr["AreaID"].ToString());
    Response.Write(dr[1].ToString()+"<br>");

}



foreach (System.Data.DataRow dr in ds.Tables["ds"].Rows)
{
    Response.Write(dr["AreaID"].ToString());
    Response.Write(dr[1].ToString()+"<br>");

}

或：
页面：<%=getTable()%>

cs:
DataSet ds = DbSqlClient.Query(sql);

public string getTable()
    {
        StringBuilder str = new StringBuilder();
        str.Append("<select>");
        foreach (System.Data.DataTable dtrow in ds.Tables)
        {
            foreach (System.Data.DataRow dr in dtrow.Rows)
            {
                str.Append("<option value="+dr["AreaID"].ToString()+">" + dr[1].ToString() + "</option>");

            }
        }
        str.Append("</select>");
        return str.ToString();
    }