Hi Guys,

I need for you guys who have vb.net 2008 and mysql 5 to please do me a favour. I have added a bindingsource, dataadapter, datagridview to my form.

I fill a datatable using the dataadapter. and i set the adapter.missingschemaaction = missingschemaaction.AddwithKey. i set the insertcommand,updatecommand and deletecommand for the adapter as well.

however, when i click on the datagridview to add new rows a new temporary primary key is not generated in my datatable.

Can someone please test this and let me know if their primary keys get generated. i will greatly appreciate it. then I can determine whether i am maming a mistake.

I've done this with access and sql server 2005 with no problems. im using MySQL.Net connector 6.1.2