C#hercules_x_x

❔ many to many database cant update the 3rd table

cant update the 3rd table who had the cust id and drink id

Angius•509d ago

You're not doing any updating in those screenshots, so that's probably why nothing gets updated

hercules_x_x•509d ago

i already did but when i take the screen shot i was empety

Angius•509d ago

Well, I can't see how you're doing the update I can't see any errors Any code that does (or doesn't do) what you think it does

hercules_x_x•509d ago

wait i will update now

Angius•509d ago

It's like going to the doctor, saying "me hurt but I have good eyesight" Zero information besides unrelated one

hercules_x_x•509d ago

hercules_x_x•509d ago

u see the many to many table stay empty the third one

Angius•509d ago

That's still a bunch of selects How are you updating the data? How are you inserting it? With EF Core? With raw SQL? With NHibernate? With a sproc?

hercules_x_x•509d ago

wuth visual studio

Angius•509d ago

Show me the code you use to update the data

hercules_x_x•509d ago

https://paste.mod.gg/wkqsuzkalyeh/0

BlazeBin - wkqsuzkalyeh

A tool for sharing your source code with the world!

hercules_x_x•509d ago

private void buttonSubmit_Click(object sender, EventArgs e) { string Gender = ""; MySqlCommand command1, command2; string value1 = "", value2 = ""; if (radioButtonMale.Checked) { Gender = "Male"; } else { Gender = "Female"; } try { conn.Open(); MySqlCommand cmd1 = new MySqlCommand("Insert into customer(Name,Gender,Age,PhoneNo) values('" + textBoxName.Text + "','" + Gender + "','" + textBoxAge.Text + "','" + textBoxPhone_No.Text + "');", conn); MySqlCommand cmd2 = new MySqlCommand("Insert into drink(Drink_Option,Price) values('" + this.comboBoxDrink_Option.SelectedItem.ToString() + "','Rm3.50')", conn); string sql_Customer = "selectfrom customer order by customer_ID"; command1 = new MySqlCommand(sql_Customer, conn); MySqlDataReader reader1 = command1.ExecuteReader();
cmd1.ExecuteNonQuery(); cmd2.ExecuteNonQuery(); /cmd3.ExecuteNonQuery();*/ MessageBox.Show("Thank you for your feedback (◎≧v≦)人(≧v≦●))"); conn.Close(); } catch (MySqlException ex) { MessageBox.Show(ex.Message); } }

Angius•509d ago

Any exceptions thrown?

hercules_x_x•509d ago

i dont understand this all under the sumbet button

Angius•509d ago

When you submit the form or whatever, do you get any error?

hercules_x_x•509d ago

no no errors

Angius•509d ago

My bet would be that string concatenation somehow makes the query malformed I'd use parametrized queries instead

hercules_x_x•509d ago

how to chamge to parameterz they didnt teach us would help a lot if u guid lol guide me

Angius•509d ago

https://stackoverflow.com/a/652999/6042255

Stack Overflow

Parameterized Query for MySQL with C#

I have the code below (I've included what I believe are all relevant sections): private String readCommand = "SELECT LEVEL FROM USERS WHERE VAL1 = ? AND VAL@ = ?;"; public bool read(string id) {...

hercules_x_x•509d ago

i am lost... what part is need to change in my code to be parameterd

Angius•509d ago

Instead of string concatenation, use the @ parameter names Then, bind the parameters with query.Parameters.AddWithValue()

hercules_x_x•509d ago

i know u dont want spone feed me but can at least change some of my cod so i understand

Angius•509d ago

var command = new MySqlCommand("INSERT INTO things (name, count) VALUES (@name, @count)");
command.Parameters.AddWithValue("@name", name);
command.Parameters.AddWithValue("@count", count);
command.ExecuteNonQuery();

var command = new MySqlCommand("INSERT INTO things (name, count) VALUES (@name, @count)");
command.Parameters.AddWithValue("@name", name);
command.Parameters.AddWithValue("@count", count);
command.ExecuteNonQuery();