Re: Lots of problems with VB.NET and MySQL

[Sammy Age]

Erika, Im a newbie in MySQL as well but i know the @@identity is not supported in mySQL. to get the same results you need to use LAST_INSERT_ID()

'this assumes you already added your data to the database
Dim StrSql as String = "Select LAST_INSERT_ID()"
        objSqlCommand = New MySqlCommand(StrSql, objSqlConn)
        objSqlCommand.ExecuteScalar()
        Response.Write("RESULT IS " & objSqlCommand.ExecuteScalar().ToString())

hope this helps