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()

I found it:
the executenonquery command must be removed ...