且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在SQL查询使用多个参数

更新时间:2023-01-31 14:58:32

像之前您可以添加parammeter。
这是你的code将如何魔神这样的:

You can add parammeter as you did before. This is how your code will loke like:

sqlCode = "SELECT * FROM [db].[dbo].[TablePDFTest] WHERE [name] = @name AND [ssn3] =@ssn3";

using (SqlCommand command = new SqlCommand(sqlCode, Conn))
{
      //command.CommandType = CommandType.Text;
      command.Parameters.AddWithValue("@name", nameE);
      command.Parameters.AddWithValue("@ssn3", c);

      using (reader = command.ExecuteReader())
      {
        // some action goes here...
      }
 }