>>>>><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>>