1 reply to this topic

[qqq2qqq]

i con't insert into ozv table
this is my code:
Dim strcon AsString = "data source=localhost;initial catalog=library;integrated security=true"
Dim cn AsNew SqlConnection(strcon)
PrivateSub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim cominsert AsNew SqlCommand
cominsert.Connection = cn
cominsert.CommandText = "insert into ozv values(@t2,@t3,@t4,@t5,@t6,@t7,@t8)"
'cominsert.Parameters.AddWithValue("@t1", Me.txtcodeozv.Text)
cominsert.Parameters.AddWithValue("@t2", Me.txtnameozv.Text)
cominsert.Parameters.AddWithValue("@t3", Me.txtfamilyozv.Text)
cominsert.Parameters.AddWithValue("@t4", Me.txtFnameozv.Text)
cominsert.Parameters.AddWithValue("@t5", Me.txtFnameozv.Text)
cominsert.Parameters.AddWithValue("@t6", Me.txtcodemeliozv.Text)
cominsert.Parameters.AddWithValue("@t7", Me.txttdateozv.Text)
cominsert.Parameters.AddWithValue("@t8", Me.txtadresozv.Text)
cn.Open()
cominsert.ExecuteNonQuery()
cn.Close()
EndSub

and this is error:
An explicit value for the identity column in table 'ozv' can only be specified when a column list is used and IDENTITY_INSERT is ON
and my firs fields is identity,please help me

[Ray Tawil]

your adding a parameter @t1 but you are not using it in the insert, why is that?

if the first field is an id that is auto-increment, let it go do not insert it, when a new row is inserted it will automatically be added.