Retrieve value of checkbox from database

Question

how to Retrieve value of checkbox from database I mean when an item is checked then i assign 3 to that value. Now i need to populate the items as checked in dropdownlist back from database according to that number.

Manas Mohapatra · Answer

protected void Page_Load(object sender EventArgs e) { SqlConnection con = new SqlConnection(str); string com = Select * from UserDetail; SqlDataAdapter adpt = new SqlDataAdapter(com con); DataTable dt = new DataTable(); adpt.Fill(dt); DropDownList1.DataSource = dt; DropDownList1.DataTextField = Name; DropDownList1.DataValueField = ID; DropDownList1.DataBind(); // Dropdown select an element ListItem item = DropDownList1 .Items.FindByValue( vivek ); if (item != null) { DropDownList1 .SelectedValue = vivek ; } } Note: I used vivek name will be selected in dropdown as default. DropDownList1 is ID of your dropdownlist. Please see below link how to fetch data from DB and bind it to dropdown. http://www.c-sharpcorner.com/UploadFile/rohatash/binding-dropdownlist-with-database-and-display-data-in-gridv/