c# Database update and insert

Question

Im having a databse with some customer information (customer_nr(primary key), name, address and so on)

The informaton comes from an xml file and is stored in the databse called customer_info. Now i want to update this table, example if the customer changes his address i want to update the table or, if an customer does not exist i want to insert a new row with the information. Now how do I do this? Ive tried alot of diffrent things but nothing seems to work.

example code:

my insert looks like this:

using (var cmd = new SqlCommand("insert into [customer_info] (custoner_nr, firstName,lastName, adress_1....(and so on))", connection)) {
              cmd.Parameters.AddWithValue("@customer_nr", customerNr);
              cmd.Parameters.AddWithValue("@firstName", fName);
              cmd.Parameters.AddWithValue("@lastName", lName); 
              cmd.ExecuteNonQuery();

my update looks like this:

using (var cmd = new SqlCommand("UPDATE [customer_info] SET [customer_nr] = @customer_nr [firstName] = @firstName, [lastName] = @lastName, WHERE (([customer_nr] = @customer_nr))", connection)) {
                cmd.Parameters.AddWithValue("@custmer_nr", customerNr);
                cmd.Parameters.AddWithValue("@fornamn", fName);
                cmd.Parameters.AddWithValue("@efternamn", lName);
                cmd.ExecuteNonQuery();

I've tried to match the customer_nr, something like this:

DataRow row = dataSet.custmer_info.FindBycustomer_nr(t.customerNr);
if (bla != null) {
   updateCustomer(t.kontoNr,t.fName,t.lastname....);
} else {
   insertCustomer(t.kontoNr,t.fName,t.lastname....);
}

If someone understands my problem and could help me i would be so greatful, im really stuck and what ive been testing does not work. =(

So, what does your code do? What errors are you getting? What behaviour? — Oded
– Oded, Commented Apr 13, 2011 at 11:32
How is your DataSet getting updated with the inserted or updated records? How are you determining that your code doesn't work? — Mufaka
– Mufaka, Commented Apr 13, 2011 at 11:43

Kenneth Jakobsen · Accepted Answer · 2011-04-13 11:55:10Z

1

As far as i can see you are not opening an closing the connection

using (var cmd = new SqlCommand("UPDATE [customer_info] SET [customer_nr] = @customer_nr [firstName] = @firstName, [lastName] = @lastName, WHERE (([customer_nr] = @customer_nr))", connection)) {
                cmd.Parameters.AddWithValue("@custmer_nr", customerNr);
                cmd.Parameters.AddWithValue("@fornamn", fName);
                cmd.Parameters.AddWithValue("@efternamn", lName);
                connection.Open();
                cmd.ExecuteNonQuery();
                connection.Close();

answered Apr 13, 2011 at 11:55

Kenneth Jakobsen

4483 silver badges11 bronze badges

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

Comments

AbdouMoumen · Accepted Answer · 2011-04-13 11:42:47Z

1

you should try using an O/RM tool such as EntityFramework. you can get started here

answered Apr 13, 2011 at 11:42

AbdouMoumen

3,8541 gold badge22 silver badges28 bronze badges

Collectives™ on Stack Overflow

c# Database update and insert

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related