Hi there,
i'm getting this error when i'm Updating a Stored Procedure
ex = {"Operand type clash: int is incompatible with text"}
this is my Update Function:
Sub Update_PRS(ByVal stts As String)
If con.State = ConnectionState.Closed Then
con.Open()
End If
cnt = 1
Try
Dim cmd As New SqlCommand("Update_PRS", con)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@Form_no", SqlDbType.Int).Value = sno
cmd.Parameters.Add("@Entity", SqlDbType.VarChar).Value = ddcompany.SelectedValue
cmd.Parameters.Add("@Review_Period", SqlDbType.VarChar).Value = txtrperiod.Text
cmd.Parameters.Add("@ename", SqlDbType.VarChar).Value = Trim(txtename.Text)
cmd.Parameters.Add("@Join_Date ", SqlDbType.VarChar).Value = Trim(txtjdate.Text)
cmd.Parameters.Add("@dept", SqlDbTy ...
Go to the complete details ...