C#开发学习——ADO.NET几个重要对象
第一种:String connectionString="";SqlConnection con = new SqlConnection(connectionString);con.open();SqlCommand cmd = new SqlCommand("select/等CRUD语句....";con);SqlDataReader reader = cmd.ExecuteReader();while(reader.Reader()){Response.Write(reader["列名"]);.....}reader.close();con.close();展示可以借用GirdView实现:GirdView.DataSource=reader;GirdView.DataBind();第二种:
String connectionString="";
SqlConnection con = new SqlConnection(connectionString);
con.open();SqlDataAdapter da = new SqlDataAdapter("CRUD语句",con);DataSet ds = new DataSet();da.Fill(ds);或
String connectionString="";
SqlConnection con = new SqlConnection(connectionString);
con.open();
SqlCommand cmd = new SqlCommand("select/等CRUD语句....";con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
或
String connectionString="";
SqlConnection con = new SqlConnection(connectionString);
con.open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("select/等CRUD语句....";con);
DataSet ds = new DataSet();
da.Fill(ds);
GirdView.DataSource = ds;
GirdView.DataBind();
来源: