权限

        using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["shoppbook"].ConnectionString))
        {
            SqlDataAdapter ada = new SqlDataAdapter("select * from Books", conn);

            conn.Open();
            DataSet ds = new DataSet();
            ada.Fill(ds,"Books");
            conn.Close();
            this.GridView1.DataSource = ds.Tables[0];
            this.GridView1.DataBind();
        }

问题:  拒绝了对对象 'Books' (数据库 'shoppbook'，架构 'dbo')的 SELECT 权限。
答案:  数据库(shoppbook) --->安全性---->架构---->dbo(属性)--->权限--->添加--->浏览-->
[public]---->具有授予权限(select)