// Creating a SqlCommand object SqlCommand cmd = new SqlCommand("SELECT * FROM myTable WHERE name=@name", connection); // Adding a parameter to the command cmd.Parameters.AddWithValue("@name", "John");
// Creating an OracleCommand object OracleCommand cmd = new OracleCommand("SELECT * FROM myTable WHERE name=:name", connection); // Adding a parameter to the command cmd.Parameters.Add("name", OracleDbType.Varchar2).Value = "John";In this example, we create an OracleCommand object and use the Add method to add a parameter called "name" with a type of OracleDbType.Varchar2 and a value of "John". Both of these examples demonstrate how to use the AddParameter method to add a parameter to a command or query in different package libraries.