传递未知个数的同类型参数

通过params可以传递多个参数

static void Main(string[] args)
        {
            Test("a","aa","aaa");
            Test("insert into Table_1(name,age,sex) values(@name,@age,@sex)",new SqlParameter("name","nxqcnxq"),new SqlParameter("age", 18), new SqlParameter("sex", "男"));
            Console.ReadKey();
        }

 static private void Test(string str1, params String[] strs)
        {
            Console.WriteLine(str1);
            foreach (string s in strs)
            {
                Console.WriteLine(s);
            }
        }

 static private void Test(string sqlStr, params SqlParameter[] parameters)
        {
            string connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = sqlStr;
                    foreach (SqlParameter sp in parameters)
                    {
                        cmd.Parameters.Add(sp);
                    }
                    cmd.ExecuteNonQuery();
                }
            }
        }