Hi Craig -
I understand that the disabled items technically do not exist and no values are submitted for them. What I don't understand is that this being the case, where is the call coming from to update the fields displayed in the disabled checkboxes (see my code).
Thanks


>Values of disabled objects are not sent back as part of the Submit. It's in the standard. Could this be the problem?
>
>>OK - Let's do this a little more basic. I removed the checkboxes from the formview and just placed them on the page. They are not bound to anything. They are populated with this routine.
>>

>>Private Sub Page_PreRenderComplete(sender As Object, e As System.EventArgs) Handles Me.PreRenderComplete
>>					
>>			Dim Basecase_ck As CheckBox = Basecase_CheckBox
>>			Dim Scenario1_ck As CheckBox = Scenario1_CheckBox
>>			Dim Scenario2_ck As CheckBox = Scenario2_CheckBox
>>			Dim Scenario3_ck As CheckBox = Scenario3_CheckBox
>>			Dim Scenario4_ck As CheckBox = Scenario4_CheckBox
>>			Dim Scenario5_ck As CheckBox = Scenario5_CheckBox
>>			Dim Scenario6_ck As CheckBox = Scenario6_CheckBox
>>
>>			If Not User.IsInRole("CanEditBasecase") Then
>>				Basecase_ck.Enabled = False
>>			End If
>>			If Not User.IsInRole("CanEditScenario1") Then
>>				Scenario1_ck.Enabled = False
>>			End If
>>			If Not User.IsInRole("CanEditScenario2") Then
>>				Scenario2_ck.Enabled = False
>>			End If
>>			If Not User.IsInRole("CanEditScenario3") Then
>>				Scenario3_ck.Enabled = False
>>			End If
>>			If Not User.IsInRole("CanEditScenario4") Then
>>				Scenario4_ck.Enabled = False
>>			End If
>>			If Not User.IsInRole("CanEditScenario5") Then
>>				Scenario5_ck.Enabled = False
>>			End If
>>			If Not User.IsInRole("CanEditScenario6") Then
>>				Scenario6_ck.Enabled = False
>>			End If
>>
>>			Dim oConn As New SqlConnection(ConfigurationManager.ConnectionStrings("sqlRTPConnectionString").ConnectionString)
>>			Dim oCommand As New SqlClient.SqlCommand("SELECT rtp_id, [basecase], scenario1, scenario2, scenario3, scenario4, scenario5, scenario6 FROM rtp_projects WHERE rtp_id = @rtp_id", oConn)
>>			oConn.Open()
>>			oCommand.Parameters.AddWithValue("@rtp_id", FormView1.SelectedValue)
>>			Dim oReader As SqlDataReader = oCommand.ExecuteReader
>>			oReader.Read()
>>			Basecase_ck.Checked = oReader("Basecase")
>>			Scenario1_ck.Checked = oReader("Scenario1")
>>			Scenario2_ck.Checked = oReader("Scenario2")
>>			Scenario3_ck.Checked = oReader("Scenario3")
>>			Scenario4_ck.Checked = oReader("Scenario4")
>>			Scenario5_ck.Checked = oReader("Scenario5")
>>			Scenario6_ck.Checked = oReader("Scenario6")
>>
>>			oReader.Close()
>>			oCommand.Dispose()
>>			oConn.Close()
>>			End Sub
>>

>>and updated with this:
>>

>>	Public Sub SaveCheckBoxes(sender As Object, e As EventArgs)
>>		Dim oConn As New SqlConnection(ConfigurationManager.ConnectionStrings("sqlRTPConnectionString").ConnectionString)
>>		Dim oCommand As New SqlClient.SqlCommand("", oConn)
>>		oConn.Open()
>>
>>		Select Case sender.ID.ToString
>>			Case "Basecase_CheckBox"
>>				oCommand.CommandText = "UPDATE [rtp_projects] SET [basecase] = @basecase WHERE rtp_id = @rtp_id"
>>				oCommand.Parameters.AddWithValue("@basecase", sender.Checked)
>>				oCommand.Parameters.AddWithValue("@RTP_ID", FormView1.SelectedValue)
>>			Case "Scenario1_CheckBox"
>>				oCommand.CommandText = "UPDATE [rtp_projects] SET [Scenario1] = @Scenario1 WHERE rtp_id = @rtp_id"
>>				oCommand.Parameters.AddWithValue("@Scenario1", sender.Checked)
>>				oCommand.Parameters.AddWithValue("@RTP_ID", FormView1.SelectedValue)
>>			Case "Scenario2_CheckBox"
>>				oCommand.CommandText = "UPDATE [rtp_projects] SET [Scenario2] = @Scenario2 WHERE rtp_id = @rtp_id"
>>				oCommand.Parameters.AddWithValue("@Scenario2", sender.Checked)
>>				oCommand.Parameters.AddWithValue("@RTP_ID", FormView1.SelectedValue)
>>			Case "Scenario3_CheckBox"
>>				oCommand.CommandText = "UPDATE [rtp_projects] SET [Scenario3] = @Scenario3 WHERE rtp_id = @rtp_id"
>>				oCommand.Parameters.AddWithValue("@Scenario3", sender.Checked)
>>				oCommand.Parameters.AddWithValue("@RTP_ID", FormView1.SelectedValue)
>>			Case "Scenario4_CheckBox"
>>				oCommand.CommandText = "UPDATE [rtp_projects] SET [Scenario4] = @Scenario4 WHERE rtp_id = @rtp_id"
>>				oCommand.Parameters.AddWithValue("@Scenario4", sender.Checked)
>>				oCommand.Parameters.AddWithValue("@RTP_ID", FormView1.SelectedValue)
>>			Case "Scenario5_CheckBox"
>>				oCommand.CommandText = "UPDATE [rtp_projects] SET [Scenario5] = @Scenario5 WHERE rtp_id = @rtp_id"
>>				oCommand.Parameters.AddWithValue("@Scenario5", sender.Checked)
>>				oCommand.Parameters.AddWithValue("@RTP_ID", FormView1.SelectedValue)
>>			Case "Scenario6_CheckBox"
>>				oCommand.CommandText = "UPDATE [rtp_projects] SET [Scenario6] = @Scenario6 WHERE rtp_id = @rtp_id"
>>				oCommand.Parameters.AddWithValue("@Scenario6", sender.Checked)
>>				oCommand.Parameters.AddWithValue("@RTP_ID", FormView1.SelectedValue)
>>
>>		End Select
>>
>>		oCommand.ExecuteNonQuery()
>>		oCommand.Dispose()
>>		oConn.Close()
>>		'MsgBox("Updated")
>>
>>	End Sub
>>

>>Each checkbox looks like this:
>>

>><asp:CheckBox ID="Basecase_CheckBox" runat="server" Enabled="true" Text="Basecase" OnCheckedChanged="SaveCheckBoxes" />
>>

>>This all works fine if all of the checkboxes are enabled. However, if a couple of them are disabled, as soon as I edit one of the remaining ones the status of the disabled ones goes to UnChecked and the table is updated to unchecked. I can't figure this out because there is NO binding and No call to the disabled checkboxes or their fields. I suspect it has something to do with viewstate but can't figure it out.
>>