(mysql) connector-net-examples-mysqlparametercollection

Info Catalog

(mysql) connector-net-examples-mysqlparameter

(mysql) connector-net-examples

(mysql) connector-net-examples-mysqltransaction

 
 23.2.3.75 Using `MySqlParameterCollection'
 ..........................................
 
 The number of the parameters in the collection must be equal to the
 number of parameter placeholders within the command text, or an
 exception will be generated.
 
 *Examples*
 
 The following example creates multiple instances of `MySqlParameter'
 through the `MySqlParameterCollection' collection within the
 `MySqlDataAdapter'. These parameters are used to select data within the
 data source and place the data in the `DataSet'. This code assumes that
 a `DataSet' and a `MySqlDataAdapter' have already been created with the
 appropriate schema, commands, and connection.
 
 Visual Basic example:
 
      Public Sub AddParameters()
          ' ...
          ' create myDataSet and myDataAdapter
          ' ...
          myDataAdapter.SelectCommand.Parameters.Add("@CategoryName", MySqlDbType.VarChar, 80).Value = "toasters"
          myDataAdapter.SelectCommand.Parameters.Add("@SerialNum", MySqlDbType.Long).Value = 239
 
          myDataAdapter.Fill(myDataSet)
      End Sub 'AddSqlParameters
 
 C# example:
 
      public void AddSqlParameters()
      {
      // ...
      // create myDataSet and myDataAdapter
      // ...
        myDataAdapter.SelectCommand.Parameters.Add("@CategoryName", MySqlDbType.VarChar, 80).Value = "toasters";
        myDataAdapter.SelectCommand.Parameters.Add("@SerialNum", MySqlDbType.Long).Value = 239;
        myDataAdapter.Fill(myDataSet);
      }
 

Info Catalog

(mysql) connector-net-examples-mysqlparameter

(mysql) connector-net-examples

(mysql) connector-net-examples-mysqltransaction