code for Insert Values Into a Single Column c# windows

Question

code for Insert checkedListBox Values Into a Single Column c# windows Application

Cr Bhargavi · Answer

using System; using System.Data.SqlClient; using System.Windows.Forms; namespace CheckedListBoxExample { public partial class Form1 : Form { private string connectionString = "Your_Connection_String_Here"; public Form1() { InitializeComponent(); } private void btnInsert_Click(object sender, EventArgs e) { try { using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); // Get selected items from CheckedListBox string selectedItems = string.Join(",", checkedListBox1.CheckedItems); // Insert selected items into the database //Replace "Your_Connection_String_Here" with your actual SQL Server connection //string and "YourTableName" with the table name to insert the values string query = "INSERT INTO YourTableName (YourColumnName) VALUES (@SelectedItems)"; using (SqlCommand command = new SqlCommand(query, connection)) { command.Parameters.AddWithValue("@SelectedItems", selectedItems); command.ExecuteNonQuery(); } MessageBox.Show("Selected items inserted successfully."); } } catch (Exception ex) { MessageBox.Show("An error occurred: " + ex.Message); } } } }

code for Insert Values Into a Single Column c# windows

Answers (1)