Question About MySQL and .NET

[Michael C#]

Hi all, writing a VB.NET app using the MySqlConnection client and having a
hard time with MySqlCommand Parameter queries. I create a query like this:
cmd.CommandText = "INSERT INTO Location_Lookup (Description, ID) VALUES
(@desc, @id)"
cmd.Parameters.Add("@desc", MySqlDbType.VarChar, 128).Value = val
cmd.Parameters.Add("@id", MySqlDbType.Int32).Value = seedid
cmd.ExecuteNonQuery()

I keep getting the following error mesasge: Column 'Description' cannot be
null

I've verified the values of the val ("Armenia") and seedid (10) variables.
Neither is null. I've also verified the two MySqlParameters added to the
MySqlCommand.

Can anyone offer a solution or point me in the right direction to find MySQL
sample code for the .NET connector?

TIA

[Michael C#]

Never mind, I think I solved the problem. Instead of the @ sign, it looks
like parameter names are preceded with ?.

Thanks

"Michael C#" <xy*@abcdef.com> wrote in message
news:fo*****************@fe08.lga...

Hi all, writing a VB.NET app using the MySqlConnection client and having a
hard time with MySqlCommand Parameter queries. I create a query like
this:
cmd.CommandText = "INSERT INTO Location_Lookup (Description, ID) VALUES
(@desc, @id)"
cmd.Parameters.Add("@desc", MySqlDbType.VarChar, 128).Value = val
cmd.Parameters.Add("@id", MySqlDbType.Int32).Value = seedid
cmd.ExecuteNonQuery()

I keep getting the following error mesasge: Column 'Description' cannot
be null

I've verified the values of the val ("Armenia") and seedid (10) variables.
Neither is null. I've also verified the two MySqlParameters added to the
MySqlCommand.

Can anyone offer a solution or point me in the right direction to find
MySQL sample code for the .NET connector?

TIA