JavaScript insert statement

Question

Input Toggle button checkbox value insert into sql server

Prem Sudhan · Answer

i need check box toggle click event only insert the data into sql server

Mohammad Hussain · Answer

Insert function insertValue() { var toggleButton = document.getElementById("toggleButton"); var isChecked = toggleButton.checked; // Call a function to send the value to the server sendDataToServer(isChecked); } function sendDataToServer(value) { // Send the value to the server using AJAX // Example using fetch API fetch("/InsertToggleValue", { method: "POST", headers: { "Content-Type": "application/json" }, body: JSON.stringify({ value: value }) }) .then(response => response.json()) .then(data => { // Handle response from server if needed }) .catch(error => { console.error("Error:", error); }); } [HttpPost] public IHttpActionResult InsertToggleValue([FromBody] ToggleValueModel model) { if (model == null) { return BadRequest("Invalid data."); } // Insert the value into the SQL Server database using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); string query = "INSERT INTO YourTable (ToggleValueColumn) VALUES (@Value)"; using (SqlCommand command = new SqlCommand(query, connection)) { command.Parameters.AddWithValue("@Value", model.Value); command.ExecuteNonQuery(); } } return Ok("Value inserted successfully."); } public class ToggleValueModel { public bool Value { get; set; } }

Rathrola Prem Kumar · Answer

Can elaborate your issue with code snippet please?

JavaScript insert statement

Answers (3)