SqlDataReader的代码:

string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["ShoppingConnectionString"]);
        SqlConnection myconn = new SqlConnection(settings);
        myconn.Open();
        SqlCommand mycmd = new SqlCommand("bookcategory2", myconn);
        mycmd.CommandType = CommandType.StoredProcedure;
        SqlDataReader result = mycmd.ExecuteReader(CommandBehavior.CloseConnection);
        ProductView.DataSource = result;
        ProductView.DataBind();