Sto usando il metodo in oggetto
in questo modo
connord.Open()
Dim cmd As New SqlCommand("spDeleteId", connord)
cmd.CommandType = CommandType.StoredProcedure
Dim id As SqlParameter = New SqlParameter("@id", Me.TextBox1.Text.Trim)
id.Direction = ParameterDirection.Input
cmd.Parameters.Add(id)
Dim read As SqlDataReader
read = cmd.ExecuteReader(CommandBehavior.CloseConnection)
read.Close()
Dim ra As Integer = read.RecordsAffected.tostring
ma mi ritorna sempre -1
non riesco a capire l'errore
idee?
--------------------
Vincenzo PESANTE
System Engineer