<MyDocs>
  <MyMembers name="Class">
    <remarks>
      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.
    </remarks>

    <example>
      The following example creates multiple instances of <see cref="MySqlParameter"/>
      that are exposed as a collection through the <see cref="MySqlParameterCollection"/>
      object within <see cref="MySqlDataAdapter"/>.
      These parameters are used to select data within the data source and place the data in
      the <see cref="System.Data.DataSet"/>. This code example assumes that a <b>DataSet</b> 
      object and an instance of <see cref="MySqlDataAdapter"/> were created properly 
      with the appropriate schema, commands, and connection.
      <code lang="vbnet">
        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
      </code>
      <code lang="C#">
        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);
        }
      </code>
    </example>


  </MyMembers>



</MyDocs>