Add(String,MySqlType,Int32) Method
Adds a
MySqlParameter to the
MySqlParameterCollection given the parameter name, data type, and data size.
The following example creates a
MySqlParameterCollection, adds instances of
MySqlParameter to the collection, and returns a reference to the new
MySqlParameter.
|
|---|
public void CreateMySqlParamColl(MySqlConnection myConn) {
MySqlCommand mySqlCommand = new MySqlCommand("SELECT * FROM Test.Dept WHERE DeptNo = :DeptNo", myConn);
MySqlParameterCollection myParamCollection = mySqlCommand.Parameters;
MySqlParameter myNewParameter = myParamCollection.Add("DeptNo", MySqlType.Int, 40);
} |
|
|---|
Public Sub CreateMySqlParamColl(myConn As MySqlConnection)
Dim mySqlCommand As MySqlCommand = New MySqlCommand("SELECT * FROM Test.Dept WHERE DeptNo = :DeptNo", myConn)
Dim myParamCollection As MySqlParameterCollection = mySqlCommand.Parameters
Dim myNewParameter As MySqlParameter = myParamCollection.Add("DeptNo", MySqlType.Int, 40)
End Sub |