C# SQL Update Current Insert Method Parameters.AddWithValue

Question

I wrote an SQL insert method in C # and would like to convert it, so that the rubrics (username, victories, defeats) can be changed with @ and Parameters.AddWithValue. How can I solve this problem

SqlConnection con = new SqlConnection(@"Data Source=******;Initial Catalog=UserDB;Integrated Security=True");

SqlCommand cmdinsert = new SqlCommand("Insert UserTabelle values('" + 0 + "','" + 0 + "','" + txtBenutzerName.Text + "')", con);
con.Open();                    
cmdinsert.CommandType = CommandType.Text;

cmdinsert.ExecuteNonQuery();
con.Close();

MessageBox.Show("Account erfolgreich erstellt");

Login login = new Login(txtBenutzerName.Text);
login.Show();
this.Close();

Did you look at a prepared statement tutorial? If so - what did you not understand about it? — juergen d
– juergen d, Commented Apr 24, 2018 at 7:06
As an advice, always do write the fields that will be inserted. It table has new columns added your code would fail. — Cleptus
– Cleptus, Commented Apr 24, 2018 at 8:13

Sergey L · Accepted Answer · 2018-04-25 10:50:01Z

1

Use the following code as an example.

            using (var connection =
                new SqlConnection(
                    @"Data Source=******;Initial Catalog=UserDB;Integrated Security=True"))
            {
                connection.Open();
                using (var command =
                        new SqlCommand(
                            @"
insert into UserTabelle([Name], [Other])
values (@name, @other)",
                            connection)){
                    command.Parameters.AddWithValue("@name", txtBenutzerName.Text);
                    command.Parameters.AddWithValue("@other", "some value");
                    command.ExecuteNonQuery();
                }
                connection.Close();
            }

edited Apr 25, 2018 at 10:50

answered Apr 24, 2018 at 7:59

Sergey L

1,5021 gold badge9 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

C# SQL Update Current Insert Method Parameters.AddWithValue

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related