Hi,

this code inserts twice the same record. I thin it is due to the "Selet
Scope_Identity" in the sqlcommand.
If i remove the Select part, the inserts occurs only once. If i remove the
line "comd.ExecuteNonQuery()", then the inserts also occurs once.

Is there something wrong in my code?

Thanks
H.

Dim connection As SqlConnection
        Dim comd As SqlCommand
        Dim connectionstr, sql As String
        Dim iden As Integer
        connectionstr =
ConfigurationManager.ConnectionStrings("econn").Co nnectionString.ToString()
        connection = New SqlConnection(connectionstr)
        comd = New SqlCommand()
        comd.Connection = connection
       sql = "INSERT INTO table(field,...) VALUES (@fld,...); SELECT
SCOPE_IDENTITY()"
        comd.Parameters.Add("@var1", SqlDbType.NVarChar, 10).Value =
txtvnm.Text
        ...
        connection.Open()
        iden = Convert.ToInt32(comd.ExecuteScalar())
        comd.ExecuteNonQuery()
        connection.Close()

       iden = Convert.ToInt32(comd.ExecuteScalar())
        comd.ExecuteNonQuery()

Both of the above lines perform the insert statement. You need to decide If you are going to ExecuteScalar or ExecuteNonQuery.