I found this script very helpful while designing surveys for my organization. This post applies to:
\n– MS SQL server 2005+
\n– VB.NET
\n– VS2010
\n– .NET 4.0 Framework<\/p>\n
\r\nJavascript code\r\n\r\n<asp:content ID=\"Content1\" ContentPlaceHolderID=\"HeadContent\" Runat=\"Server\">\r\n <script type=\"text\/javascript\" language=\"javascript\">\r\n function CheckCheck() {\r\n var chkBoxList = document.getElementById('< %=CheckBoxList1.ClientID %>'); \r\n var chkBoxCount = chkBoxList.getElementsByTagName(\"input\");\r\n var btn = document.getElementById('< %=SubmitBtn.ClientID %>');\r\n var i = 0;\r\n var tot = 0;\r\n for (i = 0; i < chkBoxCount.length; i++) {\r\n if (chkBoxCount[i].checked) {\r\n tot = tot + 1;\r\n }\r\n }\r\n if (tot > 5) {\r\n alert('Cannot check more than 5 check boxes'); btn.disabled = true;\r\n }\r\n else {\r\n btn.disabled = false;\r\n }\r\n }\r\n<\/script>\r\n<\/asp:content>\r\n<\/code>\r\n<\/pre>\n\r\nForm page\r\n\r\n Chose top five <%= rg %> for < %= Date.Today.Year %>:
\r\n <asp:CheckBoxList ID=\"CheckBoxList1\" runat=\"server\" \r\n onclick=\"javascript:CheckCheck();\" class=\"datagrid\">\r\n <asp:ListItem>American Cancer Society<\/asp:ListItem>\r\n <asp:ListItem>Big Brothers\/Big Sisters of Central Iowa<\/asp:ListItem>\r\n <asp:ListItem>Blank Children\u2019s Hospital<\/asp:ListItem>\r\n <asp:ListItem>Susan G Komen Breast Cancer Foundation<\/asp:ListItem>\r\n <asp:ListItem>American Lung Association of Iowa<\/asp:ListItem>\r\n <asp:ListItem>Habitat for Humanity<\/asp:ListItem>\r\n <asp:ListItem>March of Dimes<\/asp:ListItem>\r\n <asp:ListItem>Children and Families of Iowa<\/asp:ListItem>\r\n <asp:ListItem>Candeo<\/asp:ListItem>\r\n <asp:ListItem>Neveln Center<\/asp:ListItem>\r\n <asp:ListItem>Orchard Place<\/asp:ListItem>\r\n <asp:ListItem>Animal Rescue League of Iowa<\/asp:ListItem>\r\n <\/asp:CheckBoxList> \r\n <table>\r\n <tr>\r\n <td>\r\n Other <asp:TextBox ID=\"TextBox1\" runat=\"server\"><\/asp:TextBox><\/td>\r\n <\/tr>\r\n <tr>\r\n <td><asp:Label ID=\"Label1\" runat=\"server\"><\/asp:Label><\/td>\r\n <\/tr>\r\n <tr>\r\n <td style=\"text-align: center;\">\r\n <asp:Button ID=\"ResetBtn\" runat=\"server\" Text=\"Reset\" \/> \r\n <asp:Button ID=\"SubmitBtn\" runat=\"server\" Text=\"Submit\" \/><\/td>\r\n \r\n <\/table>\r\n<\/code>\r\n<\/pre>\n\r\nCode behind\r\n\r\nImports System.IO\r\nImports System.Data.SqlClient\r\nImports System.Web.UI.WebControls\r\n\r\nPartial Class Docs_Apps_Surveys_EIC_Default\r\n Inherits System.Web.UI.Page\r\n Protected Sub ResetBtn_Click(sender As Object, e As System.EventArgs)_\r\n _ Handles ResetBtn.Click\r\n Me.Server.Transfer(\"Central.aspx?rg=Charities\")\r\n End Sub\r\n Protected Sub SubmitBtn_Click(sender As Object, e As System.EventArgs)_\r\n _ Handles SubmitBtn.Click\r\n 'define controls\r\n Dim Other As TextBox\r\n\r\n 'bind controls\r\n Other = SubmitBtn.FindControl(\"TextBox1\")\r\n\r\n 'define strings\r\n Dim dToday As String\r\n Dim cRegion As String\r\n Dim OtherEvent As String\r\n\r\n 'do the work\r\n dToday = Date.Today.ToShortDateString\r\n cRegion = \"Central\"\r\n OtherEvent = Other.Text.ToString\r\n \r\n 'define array strings\r\n Dim GroupEvent As New StringBuilder(\"\")\r\n Dim chosen As Integer = 0\r\n Dim i As Integer = 0\r\n\r\n 'create array\r\n For i = 0 To CheckBoxList1.Items.Count - 1\r\n If (CheckBoxList1.Items(i).Selected = True) Then\r\n chosen += 1\r\n If (chosen > 1) Then GroupEvent.Append(\",\")\r\n GroupEvent.Append(CheckBoxList1.Items(i).Text)\r\n End If\r\n Next\r\n\r\n 'do the sql staff\r\n If dToday = \"\" Then\r\n Label1.Text = \"Date inputbox cannot be empty!\"\r\n Else\r\n\r\n 'create db connection string\r\n Dim SQLString As String\r\n Dim ConnString As String\r\n\r\n ConnString = \"Data Source=my-super-srv;Initial_\r\n _Catalog=surveys;Persist Security Info=True;_\r\n _User ID=myUsr;Password=myPwd\"\r\n\r\n Try\r\n 'SQL statement\r\n SQLString = \"INSERT into eic_charities(date, region, events, other)_\r\n _ VALUES (@Date, @Region, @Events, @Other)\"\r\n 'write to SQL\r\n Dim SQLConn As New SqlConnection()\r\n Dim SQLCmd As New SqlCommand()\r\n\r\n SQLConn.ConnectionString = ConnString\r\n SQLConn.Open()\r\n\r\n SQLCmd.Parameters.AddWithValue(\"@Date\", dToday.ToString)\r\n SQLCmd.Parameters.AddWithValue(\"@Region\", cRegion.ToString)\r\n SQLCmd.Parameters.AddWithValue(\"@Events\", GroupEvent.ToString)\r\n SQLCmd.Parameters.AddWithValue(\"@Other\", OtherEvent.ToString)\r\n SQLCmd.Connection = SQLConn\r\n SQLCmd.CommandText = SQLString\r\n SQLCmd.ExecuteNonQuery()\r\n SQLConn.Close()\r\n\r\n Catch ex As Exception\r\n Label1.Text = \"Error: \" & ex.ToString()\r\n End Try\r\n Label1.Text = \"<font color='green'>Success <\/font>- click \r\n <a href='http:\/\/myHost.com\/Charities.aspx?rg=Central'>here<\/a> \r\n to continue.\"\r\n End If\r\n End Sub\r\nEnd Class\r\n<\/code>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"I found this script very helpful while designing surveys for my organization. This post applies to: – MS SQL server 2005+ – VB.NET – VS2010 – .NET 4.0 Framework Javascript code <asp:content ID=”Content1″ ContentPlaceHolderID=”HeadContent” Runat=”Server”> <script type=”text\/javascript” language=”javascript”> function CheckCheck() { var chkBoxList = document.getElementById(‘< %=CheckBoxList1.ClientID %>’); var chkBoxCount = chkBoxList.getElementsByTagName(“input”); var btn = document.getElementById(‘< […]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85,17,16,52,43,32,67,81,84],"tags":[82,83],"class_list":["post-1909","post","type-post","status-publish","format-standard","hentry","category-net-4-0","category-applications","category-net","category-controls","category-javascript-2","category-ms-sql","category-sql","category-survey-form","category-vs2010","tag-checkbox","tag-checkboxlist"],"_links":{"self":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/1909"}],"collection":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/users\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/comments?post=1909"}],"version-history":[{"count":24,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/1909\/revisions"}],"predecessor-version":[{"id":1934,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/1909\/revisions\/1934"}],"wp:attachment":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/media?parent=1909"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/categories?post=1909"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/tags?post=1909"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}