MySqlParameterCollection Class
Collects all parameters relevant to a
MySqlCommand as well as their respective mappings to
System.Data.DataSet columns.
The following example adds instance of
MySqlParameter to collection.
|
|---|
public void AddMySqlParameters()
{
// Create mySqlConnection and mySqlCommand.
mySqlCommand.CommandText = "DELETE Test.Dept WHERE DeptNo = :DeptNo";
mySqlCommand.Parameters.Add("DeptNo", MySqlType.Int).Value = 50;
mySqlCommand.ExecuteNonQuery();
} |
|
|---|
Public Sub AddMySqlParameters()
// Create mySqlConnection and mySqlCommand.
mySqlCommand.CommandText = "DELETE Test.Dept WHERE DeptNo = :DeptNo"
mySqlCommand.Parameters.Add("DeptNo", MySqlType.Int).Value = 50
mySqlCommand.ExecuteNonQuery()
End Sub 'AddMySqlParameters |