如何使用C#将数据插入MSSQL表中

using System;
using System.Data.SqlClient;

namespace InsertDataToMSSQL
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Data Source=YourServerName;Initial Catalog=YourDatabaseName;User ID=YourUsername;Password=YourPassword";

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                try
                {
                    connection.Open();

                    string insertQuery = "INSERT INTO YourTableName (Column1, Column2, Column3) VALUES (@Value1, @Value2, @Value3)";

                    using (SqlCommand command = new SqlCommand(insertQuery, connection))
                    {
                        command.Parameters.AddWithValue("@Value1", "InsertValue1");
                        command.Parameters.AddWithValue("@Value2", "InsertValue2");
                        command.Parameters.AddWithValue("@Value3", "InsertValue3");

                        int rowsAffected = command.ExecuteNonQuery();

                        Console.WriteLine("Rows Inserted: " + rowsAffected);
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine("Error: " + ex.Message);
                }
            }
        }
    }
}