[help]insert record into MySQL db using ASP.NET???

[suigion]

Hi expert,
I am having problem in inserting record into MySQL table. It just keep inserting NULL value to the table.
Below is my code: (I am using ODBC Connection)

insert into compensation (HP,System,AddDate,Times) values (@HP,@System,@AddDate,1)

MySQLODBCCmd.Parameters.Add("@HP", txtMobile.Text)
MySQLODBCCmd.Parameters.Add("@System", SystemList.SelectedValue.ToString)
MySQLODBCCmd.Parameters.Add("@AddDate", DateAdd(DateInterval.Day, -1, Now()))

I have tried to use " ? " instead of "@" but the problem is still there...
Can anyone resolve this problem??

thanks in advance,

Suigion

[suigion]

Problem is solved...

[DoN_UK]

Excellent ... please could you tell me the solution .. I have exactly the same problem .. keep on inserting null values to the database regarding names ... numbers are inserted though !!

Thank you in advance ..

[Ribeyed]

Your parameters need to match in your stored procedure so if you are passing in @HP then your stored procedure variable needs to be @HP.

regards


Ribs