Csharp/C Sharp/Database ADO.net/SqlCommand Parameters

Материал из .Net Framework эксперт
Перейти к: навигация, поиск

Run an INSERT statement that uses parameters

<source lang="csharp"> using System; using System.Data; using System.Data.SqlClient; class UsingParameters {

 public static void Main()
 {
  SqlConnection mySqlConnection =new SqlConnection("server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;");
   mySqlConnection.Open();
   SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
   mySqlCommand.rumandText =
     "INSERT INTO Employee (" +
     "  ID, FirstName, LastName" +
     ") VALUES (" +
     "  @ID, @FirstName, @LastName" +
     ")";
   mySqlCommand.Parameters.Add("@ID", SqlDbType.NChar, 2);
   mySqlCommand.Parameters.Add("@FirstName", SqlDbType.NVarChar, 10);
   mySqlCommand.Parameters.Add("@LastName", SqlDbType.NVarChar, 10);
   mySqlCommand.Parameters["@ID"].Value = "9";
   mySqlCommand.Parameters["@FirstName"].Value = "New";
   mySqlCommand.Parameters["@LastName"].IsNullable = true;
   mySqlCommand.Parameters["@LastName"].Value = "New";
   mySqlCommand.ExecuteNonQuery();
   Console.WriteLine("Successfully added row to Customers table");
   mySqlConnection.Close();
 }

}


      </source>