DataSet与DataAdapter初步

来源:互联网 发布:上交所待遇知乎 编辑:程序博客网 时间:2024/05/25 01:34
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>");            }        }    }


原创粉丝点击