>>>><asp:GridView ID="GridView1" >>>> runat="server" >>>> AutoGenerateColumns="False"> >>>> >>>> <Columns> >>>> >>>> <asp:BoundField DataField="RightKey" HeaderText="RightKey" /> >>>> >>>> <asp:TemplateField HeaderText="Allow / Deny"> >>>> <ItemTemplate> >>>> <asp:DropDownList DataSource='<# GetAllowDenyValues() >' DataTextField="AllowDeny" >>>> DataValueField="AllowDeny" ID="AllowDeny" runat="server"></asp:DropDownList> >>>> </ItemTemplate> >>>> </asp:TemplateField> >>>> >>>> <asp:BoundField DataField="RightName" HeaderText="Right Name" /> >>>> >>>> </Columns> >>>> >>>></asp:GridView> >>>>>>>>
>>>>private string ConnectionString = string.Empty; >>>> >>>>protected void Page_Load(object sender, EventArgs e) >>>>{ >>>> if (!IsPostBack) >>>> { >>>> ConnectionString = ConfigurationManager.ConnectionStrings["MyConnStr"].ConnectionString; >>>> BindData(); >>>> } >>>>} >>>> >>>>public DataSet GetAllowDenyValues() >>>>{ >>>> SqlConnection myConnection = new SqlConnection(ConnectionString); >>>> SqlDataAdapter ad = new SqlDataAdapter("SELECT DISTINCT CASE WHEN AllowDeny = 0 " + >>>> " THEN 'No' WHEN AllowDeny = 1 THEN 'Yes'END AS AllowDeny FROM sec_Rights ", myConnection); >>>> DataSet ds = new DataSet(); >>>> ad.Fill(ds, "AllowDeny"); >>>> return ds; >>>>} >>>> >>>>private void BindData() >>>>{ >>>> SqlConnection conn = new SqlConnection(ConnectionString); >>>> SqlParameter pUserKey = new SqlParameter("@UserKey", 2); >>>> SqlCommand cmd = new SqlCommand(); >>>> cmd.Parameters.Add(pUserKey); >>>> cmd.Connection = conn; >>>> cmd.CommandText = "as_GetRightsForUserEx"; >>>> cmd.CommandType = CommandType.StoredProcedure; >>>> >>>> SqlDataAdapter ad = new SqlDataAdapter(); >>>> ad.SelectCommand = cmd; >>>> DataSet ds = new DataSet(); >>>> ad.Fill(ds, "Rights"); >>>> GridView1.DataSource = ds; >>>> GridView1.DataBind(); >>>>} >>>> >>>>>>>>
<asp:TemplateField HeaderText="Allow / Deny"> > <ItemTemplate> > <asp:DropDownList Id="AllowDeny" runat="server" > SelectedValue='< %# Bind("AllowDeny") % >' > > <asp:ListItem Value="1">Yes</asp:ListItem> > <asp:ListItem Value="0">No</asp:ListItem> > </asp:DropDownList> > </ItemTemplate> ></asp:TemplateField>What I want to do is create a grid with the name of an access right and a combo that says "Yes" or "No". In the dataset there is a