// paramins.cs using System; using System.Data.SqlClient; public class ParameterInsert { public static void Main(string[] args) { if (args.Length != 2) return; string connStr = "Server=(local)\\NetSDK;" + "Trusted_Connection=yes;" + "database=pubs"; string sqlStr = "INSERT INTO publishers(pub_id, pub_name) " + " VALUES (@PubId, @PubName)"; SqlConnection conn = new SqlConnection(connStr); SqlCommand cmd = new SqlCommand(sqlStr, conn); SqlParameter p1 = new SqlParameter("@PubId", args[0]); cmd.Parameters.Add(p1); SqlParameter p2 = new SqlParameter("@PubName", args[1]); cmd.Parameters.Add(p2); conn.Open(); int num = cmd.ExecuteNonQuery(); Console.WriteLine(num); conn.Close(); } } // コンパイル方法:csc paramins.cs