MySQL adapter test: Need Testers

[Nitesh]

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

[jmcilhinney]

Does the MySQL table have an identity column set, or whatever the MySQL equivalent is?

While I understand that, if there's a problem with your code, you'd like to fix it, do keep in mind that there's nothing to stop your setting the AutoIncrementSeed and AutoIncrementStep properties of your DataColumn manually after populating the DataTable.

[Nitesh]

thanks JM. afaik you just have to set the column to the primary key and autoincrement gets ticked in the database.

i've tried this, and it has no effect:

Private Function GetGrandParentTable() As DataTable
        Dim table As New DataTable("GrandParent")
    
        CatAdapter.Fill(table)
        table.Columns(0).AutoIncrementStep = 1
        table.Columns(0).AutoIncrementSeed = 1
        Return table
    End Function

i've tried this in my immediate window:

?table.Columns(0).AutoIncrement

and it returns false.

when I try to set the value:

table.Columns(0).AutoIncrement = True

i get this error:

Cannot change AutoIncrement of a DataColumn with type 'UInt32' once it has data.

[jmcilhinney]

Hmmm... maybe there IS something to stop your doing that. You could add the column yourself first but that is certainly not the way it SHOULD have to be done. I don't think I can help further I'm afraid as I don't use MySQL. That said, I wouldn't be surprised if you had to set the autoincrement property on the column yourself. The identity property of a column certainly doesn't get set automatically in SQL Server.

[Nitesh]

no prob. thanks for the suggestion though

the id columns on all my tables autoincrement when i do an insert though, so i doubt that is the issue.