Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • Last Modified:

What I'm doing wrong

I Know it's stupid but please take a look

in vb.net

With myCommand2
                        .Parameters.Add("@Examiner", SqlDbType.NVarChar)
                        .Parameters("@Examiner").Value = examiner2
                        .executeNonquery()

                    End With

and my sp

ALTER        procedure  spMDDeleteExaminer
@Examiner  integer
as

UPDATE [CorpDataTest].[dbo].[MDClaimsExaminers]
SET  [sActiveInactiveInd]='I'
WHERE lUserId=@Examiner


return

When I execute it, vb.net says that there is an error in my sp

SOS....I cann't see it
0
Ilianam
Asked:
Ilianam
1 Solution
 
bruintjeCommented:
Hello Ilianam,

it would certainly help to see the error message
but you say that SqlDbType is a varchar and the sp is expecting a integer, but not sure if thats the problem

hope this helps a bit
bruintje
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
.Parameters.Add("@Examiner", SqlDbType.NVarChar)  << nvarchar
but the procedure parameter is:
@Examiner  integer  << integer

hence:

.Parameters.Add("@Examiner", SqlDbType.integer)
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now