当ID自动递增时如何将其他值插入到Visual Studio中的数据库中

using System;
using System.Data.SqlClient;

namespace ConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {
            // 连接数据库
            string connectionString = "Data Source=(local);Initial Catalog=YourDatabase;Integrated Security=True";
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();

                // 构建插入语句
                string insertQuery = "INSERT INTO YourTable (Column1, Column2) VALUES (@Value1, @Value2)";

                // 创建并配置SqlCommand对象
                using (SqlCommand command = new SqlCommand(insertQuery, connection))
                {
                    // 设置参数值
                    command.Parameters.AddWithValue("@Value1", "Value1");
                    command.Parameters.AddWithValue("@Value2", "Value2");

                    // 执行插入语句
                    command.ExecuteNonQuery();
                }
            }

            Console.WriteLine("数据插入成功！");
            Console.ReadLine();
        }
    }
}