I have created a single checkbox in the DetailsView of my Asp page. I then created VB code behind to set the value =1 if the checkbox is checked and value =0 if checkbox is not checked. I cannot get the code to work. The record will get created in my SQL database, but the checkbox field remains NULL
In SQL table, my field and datatype is: Greenfield, bit, NULL
The beginning code for DetailsView1 is:
Code:
<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" BackColor="White" BorderColor="White" BorderStyle="None" BorderWidth="1px" CellPadding="3" CellSpacing="2" DataKeyNames="ID" DataSourceID="tblEntryFormDS" style="text-align: left; margin-bottom: 0px;" Font-Bold="False" Font-Names="Arial" Font-Size="Small" DefaultMode="Insert" GridLines="Horizontal" CssClass="auto-style47">
<AlternatingRowStyle BorderStyle="None" />
The code for the checkbox within DetailsView1:
Code:
<asp:CheckBox ID="CheckBox1" runat="server" Text=" Greenfield" AutoPostBack="True" />
And the VB code behind. I originally used OnCheckedChanged but that wasnt working and it was suggested of me to use DetailsView1_ItemInserting instead: (The Dropdownlists in the code are working)
Code:
Protected Sub DetailsView1_ItemInserting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DetailsViewInsertEventArgs) Handles DetailsView1.ItemInserting
Dim DropDownList6 As DropDownList = CType(DetailsView1.FindControl("DropDownList6"), DropDownList)
Dim DropDownlist9 As DropDownList = CType(DetailsView1.FindControl("DropDownList9"), DropDownList)
Dim CheckBox1 As CheckBox = DirectCast(DetailsView1.FindControl("CheckBox1"), CheckBox)
Dim strOutput As String = String.Empty
If CheckBox1.Checked = True Then
strOutput += 1
Else
strOutput = 0
End If
e.Values("DP_Facility") = DropDownList6.SelectedValue
e.Values("Facility") = DropDownlist9.SelectedValue
e.Values("Greenfield") = strOutput
End Sub