• 

  #1 written by will~
  August 14, 2007 - 4:20 am

  Quote

  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

• 

  #2 written by mike
  October 18, 2007 - 1:49 pm

  Quote

  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);
  }
  

• 

  #3 written by Joel Clermont
  March 17, 2008 - 5:51 pm

  Quote

  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.

• 

  #4 written by Ryan Tremaine
  April 6, 2008 - 7:36 pm

  Quote

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

• 

  #5 written by Michael Bielski
  June 11, 2008 - 5:22 pm

  Quote

  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.

• 

  #6 written by Tim Phelps
  June 13, 2008 - 1:39 pm

  Quote

  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

• 

  #7 written by David J Bunge
  June 30, 2008 - 12:49 pm

  Quote

  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.

• 

  #8 written by Nigel
  August 5, 2008 - 11:43 am

  Quote

  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.

• 

  #9 written by wuz
  September 21, 2008 - 9:39 am

  Quote

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

• 

  #10 written by Chris
  October 3, 2008 - 3:55 am

  Quote

  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. :-)

• 

  #11 written by Andrew
  October 8, 2008 - 10:12 am

  Quote

  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.

• 

  #12 written by Andrew
  October 8, 2008 - 10:58 am

  Quote

  Sorry, it stripped out my asp code:

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

• 

  #13 written by Jason
  April 1, 2009 - 12:04 pm

  Quote

  I took what Ryan and WUZ provided and created a server control. This will appear in the toolbox.
  I had to convert it to VB for this web application.

  Option Strict On
  Option Explicit On
  
  Imports System
  Imports System.Collections.Generic
  Imports System.ComponentModel
  Imports System.Text
  Imports System.Web
  Imports System.Web.UI
  Imports System.Web.UI.WebControls
  
  Namespace UI.WebControls
      <ToolboxData("")> _
      Public Class CheckBoxWithValue
          Inherits System.Web.UI.WebControls.CheckBox
  
           Property Value() As String
              Get
                  Dim s As String = CStr(ViewState("Value"))
                  If s Is Nothing Then
                      Return String.Empty
                  Else
                      Return s
                  End If
              End Get
              Set(ByVal value As String)
                  ViewState("Value") = value
              End Set
          End Property
  
          Protected Overrides Sub OnPreRender(ByVal e As System.EventArgs)
              MyBase.OnPreRender(e)
              Me.InputAttributes("Value") = Me.Value
          End Sub
  
          Protected Overrides Sub RenderContents(ByVal writer As HtmlTextWriter)
              writer.Write(Text)
          End Sub
  
      End Class
  End Namespace
  

No trackbacks yet.