how to get values in gridview when checkboxlist selected

Question

When i select the checkbox lists and the checkbox list value should reflect dynamically in gridview on a button click. How to do this?? Any suggestion.. Ex: i have 3 Checkbox list values A.India B.Austrelia C.Brazil Here i have one button ok,when i click any checkbox and click on button that time the the selected checkbox list value will shown in my Gridview. .

Rupesh Kahane · Answer

Your View page code asp:CheckBoxList ID = "chkCountries" runat = "server" AutoPostBack = "true" OnSelectedIndexChanged = "Country_Selected" > asp:ListItem Text = "Argentina" Value = "Argentina" > asp:ListItem > asp:ListItem Text = "Austria" Value = "Austria" > asp:ListItem > asp:ListItem Text = "Belgium" Value = "Belgium" > asp:ListItem > asp:ListItem Text = "Brazil" Value = "Brazil" > asp:ListItem > asp:ListItem Text = "Canada" Value = "Canada" > asp:ListItem > asp:CheckBoxList > asp:Button runat = "server" id = "btnLogin" Text = "Log In" OnClick = "btnLogin_Click" /> hr /> asp:GridView ID = "GridView1" runat = "server" AutoGenerateColumns = "false" CssClass = "grid" AllowPaging = "true" > Columns > asp:BoundField HeaderText = "Contact Name" DataField = "ContactName" /> asp:BoundField HeaderText = "Country" DataField = "Country" /> Columns > asp:GridView > C# Code using System.Data; using System.Data.SqlClient; using System.Configuration; protected void Page_Load( object sender, EventArgs e) { if (! this .IsPostBack) { this .BindGrid(); } } private void BindGrid() { string constr = ConfigurationManager.ConnectionStrings[ "constr" ].ConnectionString; string query = "SELECT ContactName, Country FROM Customers" ; string condition = string .Empty; foreach (ListItem item in chkCountries.Items) { condition += item.Selected ? string .Format( "'{0}'," , item.Value) : string .Empty; } if (! string .IsNullOrEmpty(condition)) { condition = string .Format( " WHERE Country IN ({0})" , condition.Substring(0, condition.Length - 1)); } using (SqlConnection con = new SqlConnection(constr)) { using (SqlCommand cmd = new SqlCommand(query + condition)) { using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) { cmd.Connection = con; using (DataTable dt = new DataTable()) { sda.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); } } } } } protected void btnLogin_Click( object sender, GridViewPageEventArgs e) { GridView1.PageIndex = e.NewPageIndex; this .BindGrid(); } This works properly

Bala S · Answer

if you just want to listitem.value List selectedValues = CBLGold.Items.Cast () .Where(li => li.Selected) .Select(li => li.Value) .ToList();

how to get values in gridview when checkboxlist selected

Answers (2)