Resolved Returns ID 0 when inserted

[jillyclaire]

Hi i would like to ask what's the possible problem of why the item i inserted in c# is always 0? is there also a possible way to not make it 0 and make it as auto_incremented? , i already assigned the auto_increment syntax on mysql.

 

[jmcilhinney]

If it doesn't work then you did it wrong. As you haven't shown us what you did, it would require magic for us to tell you what's wrong with it. You need to provide a FULL and CLEAR explanation of the problem, which includes what you're trying to achieve, how you're trying to achieve it and what happens when you try. That would also include the specific design of the database table in question.

 

[jmcilhinney]

I just realised that this thread is marked Resolved. If you resolve the issue yourself, please provide your solution in case it might help someone else with a similar problem.

 

[Skydiver]

Yes, we'd like to know if you used one the techniques listed below or if you had a different approach.

C# Get insert id with Auto Increment

I am using this method to insert a row into a table: MySqlConnection connect = new MySqlConnection(connectionStringMySql); MySqlCommand cmd = new MySqlCommand(); ...

stackoverflow.com

 

[jmcilhinney]

There's also the possibility that your solution is suboptimal and, in that case, we be able to help you improve it.