CreateParameter Method (MySqlCommand)
Creates a new instance of a
MySqlParameter object.
This sample shows how to create a parameter using
CreateParameter function.
|
|---|
Public void CreateParam(MySqlConnection mySqlConnection)
{
MySqlCommand mySqlCommand = new MySqlCommand("SELECT * FROM Test.Dept WHERE DeptNo=:Deptno",mySqlConnection);
MySqlParameter myParam = mySqlCommand.CreateParameter();
myParam.MySqlType = Devart.Data.MySql.MySqlType.Int;
myParam.Value = 10;
myParam.ParameterName = "Deptno";
mySqlCommand.Parameters.Add(myParam);
mySqlConnection.Open();
MySqlDataReader mySqlReader = null;
try
{
mySqlReader = mySqlCommand.ExecuteReader();
while (mySqlReader.Read())
{
Console.WriteLine(mySqlReader.GetInt32(0) + ", " + mySqlReader.GetString(1) + ", " + mySqlReader.GetString(2));
}
}
finally
{
mySqlReader.Close();
mySqlConnection.Close();
}
} |
|
|---|
Public Sub CreateParam(ByVal mySqlConnection As MySqlConnection)
Dim mySqlCommand As New MySqlCommand("SELECT * FROM Test.Dept WHERE DeptNo=:Deptno", mySqlConnection)
Dim myParam As MySqlParameter = mySqlCommand.CreateParameter()
myParam.MySqlType = Devart.Data.MySql.MySqlType.Int
myParam.Value = 10
myParam.ParameterName = "Deptno"
mySqlCommand.Parameters.Add(myParam)
mySqlConnection.Open()
Dim mySqlReader As MySqlDataReader = Nothing
Try
mySqlReader = mySqlCommand.ExecuteReader()
While mySqlReader.Read()
Console.WriteLine(mySqlReader.GetInt32(0).ToString() + ", " _
+ mySqlReader.GetString(1) + ", " _
+ mySqlReader.GetString(2))
End While
Finally
mySqlReader.Close()
mySqlConnection.Close()
End Try
End Sub |