Update specific sql record using values

Question

I have a bit of a trouble, writing a query string, to update a specific sql record. I have all my respective values stores in strings, and whebn i add them (values as parameters), it will convert the primary id to an int. So far, so good.

The problem lies in my query string it self. I can do deleting and creation of sql records (select and insert) yet the problem here, lies in updating. That i have no real experience in.

Now... For the query string that i have all ready...

SqlCommand DerGemmesMedarbejder = new SqlCommand("UPDATE MyTableInQuestion VALUES (@Tittel, @FuldeNavn, @MailAdresse, @TelefonNummer, @MedarbejderType) WHERE PersonaleID = @PersonaleID_FraRepeateren", GemDetAendredeIndhold);

I just can not seem to get it right. The debugger is telling me that the problem is "incorrect syntax near jeyword 'VALUES'

Amit · Accepted Answer · 2013-06-04 07:41:58Z

4

Try this

SqlCommand DerGemmesMedarbejder = new SqlCommand("UPDATE MyTableInQuestion set title=@Tittel, FuldeNavn=@FuldeNavn, ... WHERE PersonaleID = @PersonaleID_FraRepeateren", GemDetAendredeIndhold);

answered Jun 4, 2013 at 7:41

Amit

15.4k8 gold badges49 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Devart · Accepted Answer · 2013-06-04 07:43:33Z

2

Try this query -

UPDATE MyTableInQuestion 
SET 
      Tittel = @Tittel
    , FuldeNavn = @FuldeNavn
    , MailAdresse = @MailAdresse
    , TelefonNummer = @TelefonNummer
    , MedarbejderType = @MedarbejderType
WHERE PersonaleID = @PersonaleID_FraRepeateren

answered Jun 4, 2013 at 7:43

Devart

120k23 gold badges171 silver badges189 bronze badges

1 Comment

Anders Over a year ago

Sorry... Forgot "Tittel" not "@Tittle" in Tittle=@Tittle.

Sachin · Accepted Answer · 2013-06-04 07:43:52Z

0

Your syntax for update command is not valid. You may confused with Insert and Update command

Update command would be like this

UPDATE MyTableInQuestion set title=@Tittel, FuldeNavn=@FuldeNavn where PersonaleID = @PersonaleID_FraRepeateren

answered Jun 4, 2013 at 7:43

Sachin

41.1k7 gold badges93 silver badges107 bronze badges

3 Comments

Anders Over a year ago

FuldeNavn=@FuldeNavn Should be TheStringNameIUse=@FuldeNavn ?

Sachin Over a year ago

@FuldeNavn is the parameter which holds the value, which will used as a value of FuldeNavn column.

Anders Over a year ago

So. If i draw this "DerGemmesMedarbejder.Parameters.AddWithValue("@Tittel", Tittel_DerSkalGemmes);" from my strings that holds the values to be stored, then i should be ok with using "Tittle=@Tittle", as the values are drawn from my variables? (strings and an int)

whastupduck · Accepted Answer · 2013-06-04 07:43:41Z

0

Because the syntax is incorrect. Syntax here

For update statements, you must change your query to this:

UPDATE MyTableInQuestion SET Column1 = @Tittel, Column2 = @FuldeNavn, Column3 = @MailAdresse, Column4 = @TelefonNummer, Column5 = @MedarbejderType WHERE PersonaleID = @PersonaleID_FraRepeateren"

Where Column1-5 is your column names

answered Jun 4, 2013 at 7:43

whastupduck

1,16611 silver badges25 bronze badges

Collectives™ on Stack Overflow

Update specific sql record using values

4 Answers 4

Comments

1 Comment

3 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

3 Comments

Comments

Related