传参方式

最新推荐文章于 2024-08-22 11:25:48 发布

happymagic

最新推荐文章于 2024-08-22 11:25:48 发布

阅读量601

点赞数

分类专栏： C#

本文链接：https://blog.csdn.net/happymagic/article/details/9134559

版权

C# 专栏收录该内容

70 篇文章 1 订阅

订阅专栏

public void CreateSqlCommand(SqlConnection myConnection,
    string queryString, SqlParameter[] paramArray) 
{
    SqlCommand command = new SqlCommand(queryString, myConnection);
    command.CommandText = 
        "SELECT CustomerID, CompanyName FROM Customers " 
        + "WHERE Country = @Country AND City = @City";    
    command.Parameters.Add(paramArray);

    for (int j=0; j<paramArray.Length; j++)
    {
        command.Parameters.Add(paramArray[j]) ;
    }

    string message = "";
    for (int i = 0; i < command.Parameters.Count; i++) 
    {
        message += command.Parameters[i].ToString() + "\n";
    }
    Console.WriteLine(message);
}