从C#应用程序动态调用SQL Server存储过程

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

namespace YourNamespace
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "YourConnectionString"; // 替换为你的数据库连接字符串

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

                using (SqlCommand command = new SqlCommand("YourStoredProcedureName", connection))
                {
                    command.CommandType = CommandType.StoredProcedure;

                    // 添加存储过程的参数
                    command.Parameters.AddWithValue("@Param1", value1);
                    command.Parameters.AddWithValue("@Param2", value2);

                    // 执行存储过程并获取结果
                    SqlDataReader reader = command.ExecuteReader();

                    while (reader.Read())
                    {
                        // 处理查询结果
                    }

                    reader.Close();
                }
            }
        }
    }
}