dev|sushi

13 Comments »

• will~ — August 14, 2007 at 4:20 am

  Could you let me know how to collect checked values from a checkboxlist and store them in a database? [C#}

  I am working on a survey using VS 2005, connected to a MS SQL 2005 database. The survey consists of textbox and checkboxlist. Using a submit button, “SqlDataSource1.Insert(); ” is run. Individual collected fields are matched to their corresponding fields in to be stored in the database.

  The checkboxlist look like this…

  a
  b
  c

  Could you tell me how to put store these values? (there are fields in the database for these).

  Database
  ID
  Name
  Q1a
  Q1b
  Q1c

• mike — October 18, 2007 at 1:49 pm

  I have discovered that you can render the “value” attribute. You add the following code to your inherited checkbox custom control class:

  protected override void AddAttributesToRender(HtmlTextWriter writer)
  {
    writer.AddAttribute(HtmlTextWriterAttribute.Value, this.DataSource.ToString());
    base.AddAttributesToRender(writer);
  }
  

• Joel Clermont — March 17, 2008 at 5:51 pm

  What about the following?

  Dim chkTest As New CheckBox
  chkTest.InputAttributes(”value”) = “my custom value”

  When the page renders, if you look at the source the value attribute is there as declared. I hope this helps.

• Ryan Tremaine — April 6, 2008 at 7:36 pm

  I agree they should have included it. Easy to get around however:

  public class CheckBoxWithValue : CheckBox
  {
  public string Value
  {
  get { return ViewState["Value"] as string; }
  set { ViewState["Value"] = value; }
  }
  }

• Michael Bielski — June 11, 2008 at 5:22 pm

  Ryan, your custom class doesn’t work. The value attribute is STILL not rendered in the final HTML on the page. It may be in the viewstate, but the tag doesn’t have it. If I ever find a solution, I’ll post it.

• Tim Phelps — June 13, 2008 at 1:39 pm

  Here’s the solution:

  Use the InputAttributes property rather than the Attributes property of the CheckBox class.

  cb.InputAttributes["value"] = “foo”;

  Works like a charm.

  Found this on Dave Parslow’s blog:

  http://www.daveparslow.com/2007/08/assigning-value-to-aspnet-checkbox.html

• David J Bunge — June 30, 2008 at 12:49 pm

  The “Value” attribute shows in my browser.
  In my ASPX page:

  Rendered HTML:
  Family

  So, the value shows in HTML for me. I’m using ASP.Net 2.0, and I do get the Validation Warning on Visual Studio. However, I’m ignoring it, as the attribute is rendered. Just wanted to share.

• Nigel — August 5, 2008 at 11:43 am

  There is a similar problem with the name attribute. I’d like to render checkbox controls for use with client side scripts.

  Although ChkBox.InputAttributes["name"] = “customName”; does add the name attribute to the HTML page. ASP makes this usless as it also puts in it’s duplicate name attribute.

• n01r3n3x — August 12, 2008 at 10:49 am

  You know the checkboxlist, well, even though the values don’t render on the page, you can still access them from the code on the serverside using asp.net, because you can select more than one value from a checkboxlist, there cannot be a single SelectedValue, somewhere along the way Microsoft stuffed up there inheritance, or thought it would be okay to leave it as is (Which, it is, really…)

  You can get around this quite simply by iterating through the checkboxlist as follows.

  for (int i = 0; i < cbo.Items.Count; i++)
  {
  if (cbo.Items[i].Selected)
  {
  cbo.Items[i].Value)
  }
  }

  To locate the control on the page I’ve used a recursive script that goes through all the controls within a placeholder, (Or the whole page if you want), then if it finds a checkbox list, it classifies it and uses the above code to obtain the values.

  Any questions contact me info at noirenex dot com

• wuz — September 21, 2008 at 9:39 am

  I think Ryan’s custom class is the way to go, and as heared 100 times before we can just use InputAttributes to render the property to html:

  public class CheckBoxWithValue : CheckBox
  {
  public string Value
  {
  get { return ViewState["Value"] as string; }
  set { ViewState["Value"] = value; }
  }

  protected override void OnPreRender(EventArgs e)
  {
  base.OnPreRender(e);
  this.InputAttributes["value"] = this.Value;
  }
  }

• Chris — October 3, 2008 at 3:55 am

  I managed to sort this out by using the CheckedChanged event handler. All you need to do is programmatically change the checked value, then you can reference the checkbox.checked value directly because it fires before the page load event

  like so….

  protected void yourcheckbox_CheckedChanged(object sender, EventArgs e)
  {
  if (yourcheckbox.Checked == true)
  {
  yourcheckbox.Checked = false;
  }
  else
  {
  yourcheckbox.Checked = true;
  }
  }

  Hope this helps. :-)

• Andrew — October 8, 2008 at 10:12 am

  I found an almost decent way of doing this:

  Declare your checkbox:

  Then you can programatically add any values by looping through your controls, looking for checkboxes, and doing this:

  Control.InputAttributes.Add(”value”, Control.Attributes(”value”))

  It will complain that value is not a valid attribute on the asp:checkbox tag, but it works.

• Andrew — October 8, 2008 at 10:58 am

  Sorry, it stripped out my asp code:

  asp:CheckBox runat=”server” value=”04″ id=”control”

RSS feed for comments on this post. TrackBack URI

Leave a comment