.NET Connector Output Values

[Colin Shreffler <suppressed>]

I have the following code:

...
query = "INSERT INTO a_test_table 
(a_test_table_id,name,last_mod_date,create_date) VALUES 
(?a_test_table_id,?name,?last_mod_date,?create_date)";
...
command.Prepare();
...
command.Parameters.Add("?a_test_table_id", MySqlDbType.Int32);
command.Parameters["?a_test_table_id"].Direction = 
ParameterDirection.Output;
command.Parameters.Add("?name", this._name);
command.Parameters.Add("?last_mod_date", DateTime.Now);
command.Parameters.Add("?create_date", DateTime.Now);

command.ExecuteNonQuery();

this.ID = 
System.Convert.ToInt32(command.Parameters["?a_test_table_id"].Value.ToString());

When I try to retrieve the return value for ?a_test_table_id, I get an 
error saying the Value property is NULL.

The column in the database is set to auto-increment.  Shouldn't this 
parameter be populated automatically?  Any ideas why this is happening?



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/suppressed