C# SqlDataAdapter SelectCommand:将参数传入TSQL 'execute‘

using System;
using System.Data;
using System.Data.SqlClient;

namespace SqlCommandExample
{
    class Program
    {
        static void Main(string[] args)
        {
            // 设置数据库连接字符串
            string connectionString = "your_connection_string";

            // 创建SqlConnection对象
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                // 创建SqlDataAdapter对象
                SqlDataAdapter dataAdapter = new SqlDataAdapter();

                // 创建SelectCommand对象
                SqlCommand selectCommand = new SqlCommand();
                selectCommand.CommandText = "your_tsql_execute_statement";
                selectCommand.CommandType = CommandType.Text;
                selectCommand.Connection = connection;

                // 设置参数
                selectCommand.Parameters.AddWithValue("parameter_name", parameter_value);

                // 设置SqlDataAdapter的SelectCommand
                dataAdapter.SelectCommand = selectCommand;

                // 创建DataSet对象
                DataSet dataSet = new DataSet();

                // 填充DataSet
                dataAdapter.Fill(dataSet);

                // 处理数据
                foreach (DataRow row in dataSet.Tables[0].Rows)
                {
                    Console.WriteLine(row["column_name"]);
                }
            }
        }
    }
}