数据未写入数据库

我正在为CheckboxProcess_CheckedChanged事件中的数据库写一些值。 但是，实际上没有任何内容被写出来。 我有一些代码填充适配器，但我把它拿出来。 任何人都可以看到这出错的地方吗？

protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (SqlConnection connection = new SqlConnection(connectionString.ToString())) { connection.Open(); dataAdapter = new SqlDataAdapter("SELECT * FROM SecureOrders", connection); dataSet = new DataSet(); dataAdapter.Fill(dataSet, "SecureOrders"); DataView source = new DataView(dataSet.Tables[0]); DefaultGrid.DataSource = source; DefaultGrid.DataBind(); connection.Close(); } } } protected void CheckBoxProcess_CheckedChanged(object sender, EventArgs e) { bool update; string checkedString = "UPDATE SecureOrders SET processed = 1 WHERE fName LIKE '%" + DefaultGrid.SelectedRow.Cells[2].Text + "%' AND lName LIKE '% " + DefaultGrid.SelectedRow.Cells[3].Text + "%'"; string uncheckedString = "UPDATE SecureOrders SET processed = 0 WHERE fName LIKE '%" + DefaultGrid.SelectedRow.Cells[2].Text + "%' AND lName LIKE '% " + DefaultGrid.SelectedRow.Cells[3].Text + "%'"; CheckBox cb = (CheckBox)sender; GridViewRow gvr = (GridViewRow)cb.Parent.Parent; DefaultGrid.SelectedIndex = gvr.RowIndex; update = Convert.ToBoolean(DefaultGrid.SelectedValue); orderByString = orderByList.SelectedItem.Value; fieldString = searchTextBox.Text; connectionString = rootWebConfig.ConnectionStrings.ConnectionStrings["secureodb"]; using (SqlConnection connection = new SqlConnection(connectionString.ToString())) { connection.Open(); SqlCommand checkedCmd = new SqlCommand(checkedString, connection); SqlCommand uncheckedCmd = new SqlCommand(uncheckedString, connection); if (cb.Checked == true) { checkedCmd.ExecuteNonQuery(); } else { uncheckedCmd.ExecuteNonQuery(); } connection.Close(); } 

 string checkedString = "UPDATE SecureOrders SET processed = 1 WHERE fName LIKE '%" + DefaultGrid.SelectedRow.Cells[2].Text + "%' AND lName LIKE '% " + DefaultGrid.SelectedRow.Cells[3].Text + "%'"; 

 string checkedString = "UPDATE SecureOrders SET processed = 1 WHERE fName LIKE '%" + DefaultGrid.SelectedRow.Cells[2].Text + "%' AND lName LIKE '%" + DefaultGrid.SelectedRow.Cells[3].Text + "%'"; 

 protected void CheckBoxProcess_CheckedChanged(object sender, EventArgs e) { bool update = Convert.ToBoolean(DefaultGrid.SelectedValue); // determine your first name and last name values string firstName = .......; string lastName = .......; UpdateYourData(update, firstName, lastName); } private void UpdateYourData(bool isProcessed, string firstName, string lastName) { Configuration rootWebConfig = WebConfigurationManager.OpenWebConfiguration("/Cabot3"); ConnectionStringSettings connectionString = rootWebConfig.ConnectionStrings.ConnectionStrings["secureodb"]; string updateStmt = "UPDATE dbo.SecureOrders SET processed = @Processed " + "WHERE fName LIKE @firstName AND lName LIKE @lastName"; using (SqlConnection connection = new SqlConnection(connectionString.ToString())) using (SqlCommand _update = new SqlCommand(updateStmt, connection)) { _upate.Parameters.Add("@Processed", SqlDbType.Bit).Value = isProcessed; _upate.Parameters.Add("@firstName", SqlDbType.VarChar, 100).Value = firstName; _upate.Parameters.Add("@lastName", SqlDbType.VarChar, 100).Value = lastName; connection.Open(); _update.ExecuteNonQuery(); connection.Close(); } }