C# MySQL Parameters.AddWithValue

Question

Hello I found this code snippet for Adding Values to MySQL Commands in C#

MySqlCommand command = connection.CreateCommand();
command.CommandText = "INSERT INTO tb_mitarbeiter (Vorname) VALUES (?name)";
command.Parameters.AddWithValue("?name", mitarbeiter);
connection.Open();
command.ExecuteNonQuery();

Now I want to add data to more than one coloumn, but if i try it like this:

command.Parameters.AddWithValue("?id", Projektid, "?projektnummer", Projektnummer, "?anlageDatumProjekt", Projektanlage, "?auftraggeberProjekt",Projektauftraggeber, "?bezeichnungProjekt", Projektbezeichnung, "?nachAufwand", nachAufwand, "?bemerkungProjekt",Projektbemerkung, "?matFremdKalk", matfremdkalk, "?maStundenKalk",mastundenkalk, "?maKostenKalk", makostenkalk, "?maZuschlagFixKalk", mazuschlagfixkalk, "?maZuschlagVarKalk",mazuschlagvarkalk, "?maschStundenKalk",maschstundenkalk, "?maschKostenKalk",maschkostenkalk, "?maschZuschlagFixKalk",maschzuschlagfixkalk, "?maschZuschlagVarKalk",maschzuschlagvarkalk, "?summeAuftragKalk",summeauftragkalk, "?matFremdErfasst",matfremderfasst, "?maStundenerfasst",mastundenerfasst, "?maSelbstkostenErfasst",maselbstkostenerfasst, "?maschStundenErfasst",maschstundenerfasst, "?maschKostenVariabelErfasst",maschkostenvariabelerfasst, "?maschKostenFixErfasst",maschkostenfixerfasst, "?gemeinKostenBerechnet",gemeinkostenberechnet, "?abschlagRechnungErfasst",abschlagrechnungerfasst, "?rabatt", rabatt);

it just says that

No Overload for AddWithValue with 52 Arguments.

What do I have to change to get the code running?

Soner Gönül · Accepted Answer · 2015-06-22 12:23:35Z

3

You try to add all your 52 parameter and their values with one AddWithValue method. You can't do that.

First of all, you need to define all your parameters in your command with your column names like;

command.CommandText = "INSERT INTO tb_mitarbeiter (Vorname, id, projectnummber....) VALUES (?name, ?id, ?projektnummer....)";

Then you need to add all your 52 parameters in a 52 different AddWithValue method.

command.Parameters.AddWithValue("?name", mitarbeiter);
command.Parameters.AddWithValue("?id", Projektid);
command.Parameters.AddWithValue("?projektnummer", Projektnummer);
...
...

Or add all of them in a one MySqlParameterCollection and add this collection to your command as;

command.Parameters.Add(MyParameterCollection);

edited Jun 22, 2015 at 12:23

answered Jun 22, 2015 at 12:20

Soner Gönül

99.1k103 gold badges224 silver badges375 bronze badges

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

1 Comment

SchMat Over a year ago

thanks that worked for me, the tb mitarbeiter was a copy mistake there is a tbprojects with coloums for each value

Sven Milewski · Accepted Answer · 2015-06-22 12:23:35Z

0

Try to only add one value per AddWidthValue like

command.Parameters.AddWithValue("?name", mitarbeiter);
command.Parameters.AddWithValue("?id", Projektid);
command.Parameters.AddWithValue("?projektnummer", Projektnummer)

and so on.

Sven

answered Jun 22, 2015 at 12:23

Sven Milewski

364 bronze badges

Comments

Soner Gönül · Accepted Answer · 2019-11-19 06:09:13Z

0

You need to add each sql paramater on its own. An example would be in your case;

command.Parameters.AddWithValue("?id", Projektid);
command.Parameters.AddWithValue("?pr1ojektnummer", Projektnummer);

finally call the

command.ExecuteNonQuery();

edited Nov 19, 2019 at 6:09

Soner Gönül

99.1k103 gold badges224 silver badges375 bronze badges

answered Jun 22, 2015 at 12:23

HeadJ.E.M.

1118 bronze badges

Collectives™ on Stack Overflow

C# MySQL Parameters.AddWithValue

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related