<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"/> 
	through the <B>MySqlParameterCollection</B> collection within the <see cref="MySqlDataAdapter"/>.  
	These parameters are used to select data within the data source and place the data in 
	the <see cref="DataSet"/>. This code assumes that a <B>DataSet</B> and a <B>MySqlDataAdapter</B> 
	have already been created with the appropriate schema, commands, and connection.
<code lang="Visual Basic">
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>