Update query u C#

• 0Niko još nije pohvalio poruku.
  Registruj se da bi pohvalio/la poruku!

Radim maturski u C#, napravio sam program za magacin, baza podataka sa proizvodima, id ime kolicina i cena, postoji pregled, ubacivanje novih proizvoda, brisanje postojecih i pretraga, i sve funkcionise bez problema.
Sada zelim da napravim izmenu, konkretno kolicine, dakle da moze da se upise sifra proizvoda, i nova kolicina. Napravio sam update query, stavio 2 textboxa, dugme, ali ne mogu nikako da skontam kako ide kod koji pisem za klik na dugme. Googlao sam, i vidim da mnogi koriste try/catch blokove, ali ne mogu bas da se snadjem u tome, jer moj kod za ubacivanje npr izgleda ovako :
this.table1TableAdapter.Brisi(Convert.ToInt32(textBox1.Text));
this.table1TableAdapter.Fill(this.database1DataSet.Table1);
this.tableAdapterManager.UpdateAll(this.database1DataSet);
pa u komplikovanijima ne mogu da se snadjem.

UPDATE Table1
SET Kolicina = @Kolicina
WHERE (Sifra = @Original_Sifra);
SELECT Sifra, [Ime Proizvoda], Kolicina, Cena FROM Table1 WHERE (Sifra = @Sifra)

Ovo mi je query, ali kad pisem kod, ne znam sta da stavljam za argumente, napisem :
this.table1TableAdapter.UpdateQuery();
ne znam sta u zagradu treba da stavim, trebalo bi 2 textboxa iz kojih ce citati vrednost primary keya, da prepozna koji row da gleda, i novu vrednost za kolicinu, ali mu fali jos nesto, a ne znam sta ..

• 1Ovo se svidja korisniku: mcrule
  
  Registruj se da bi pohvalio/la poruku!

Pozdrav, pročitaj sledeći članak:
http://www.mycity.rs/NET/9-C-Osnovni-rad-sa-formom-listom-i-bazom-podataka.html

• 0Niko još nije pohvalio poruku.
  Registruj se da bi pohvalio/la poruku!

Uspeo sam da napisem peske sve, ali nece da prepozna connection string, meni izbaci drugaciji nego svima koje sam gledao u tutorialima kako rade, izbaci mi putanju na hardu, posto nisam imao connection uopste, pa sam ga sada napravio.

SqlConnection con = new SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename="c:\users\mario\documents\visual studio 2010\Projects\Maturski\WindowsFormsApplication1\Database1.mdf";Integrated Security=True;User Instance=True");         SqlCommand cmd;         private void button1_Click(object sender, EventArgs e)         {             con.Open();             cmd = new SqlCommand("UPDATE Table1 SET Kolicina = Convert.ToInt32(textBox2.Text) WHERE Sifra = Convert.ToInt32(textBox1.Text);", con);             cmd.ExecuteNonQuery();              }


Problem je u :
Data Source=.\SQLEXPRESS;AttachDbFilename="c:\users\mario\documents\visual studio 2010\Projects\Maturski\WindowsFormsApplication1\Database1.mdf";Integrated Security=True;User Instance=True

jer tu izbaci 19 errora. Ne znam kako da dobijem normalan connection string, koji ce prepoznati, pomoc ?

• 1Ovo se svidja korisniku: amaterSRB
  
  Registruj se da bi pohvalio/la poruku!

Radis sa Accessovom bazom?
Iskopiraj greske ovde.

Imas u clanku dobar sajt za connection stringove.Naveo sam ga gore.

• 0Niko još nije pohvalio poruku.
  Registruj se da bi pohvalio/la poruku!

Radim sa bazom iz visual studia ( service based database ).

Error   1   Unrecognized escape sequence   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   62   WindowsFormsApplication1 Error   2   Unrecognized escape sequence   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   93   WindowsFormsApplication1 Error   3   Unexpected character '\'   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   99   WindowsFormsApplication1 Error   4   Unexpected character '\'   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   105   WindowsFormsApplication1 Error   5   Unexpected character '\'   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   115   WindowsFormsApplication1 Error   6   Unexpected character '\'   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   134   WindowsFormsApplication1 Error   7   Unexpected character '\'   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   143   WindowsFormsApplication1 Error   8   Unexpected character '\'   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   152   WindowsFormsApplication1 Error   9   Unexpected character '\'   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   177   WindowsFormsApplication1 Error   10   ) expected   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   91   WindowsFormsApplication1 Error   11   Invalid token ':' in class, struct, or interface member declaration   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   92   WindowsFormsApplication1 Error   12   Invalid token '\' in class, struct, or interface member declaration   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   99   WindowsFormsApplication1 Error   13   Invalid token '\' in class, struct, or interface member declaration   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   105   WindowsFormsApplication1 Error   14   Invalid token '\' in class, struct, or interface member declaration   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   115   WindowsFormsApplication1 Error   15   ; expected   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   130   WindowsFormsApplication1 Error   16   Invalid token '\' in class, struct, or interface member declaration   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   143   WindowsFormsApplication1 Error   17   Invalid token '\' in class, struct, or interface member declaration   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   152   WindowsFormsApplication1 Error   18   Invalid token '\' in class, struct, or interface member declaration   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   177   WindowsFormsApplication1 Error   19   Invalid token '";Integrated Security=True;...' in class, struct, or interface member declaration   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   191   WindowsFormsApplication1 Error   20   The type or namespace name 'c' could not be found (are you missing a using directive or an assembly reference?)   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   91   WindowsFormsApplication1 Error   21   The type or namespace name 'users' could not be found (are you missing a using directive or an assembly reference?)   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   93   WindowsFormsApplication1 Error   22   The type or namespace name 'mario' could not be found (are you missing a using directive or an assembly reference?)   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   100   WindowsFormsApplication1 Error   23   The type or namespace name 'documents' could not be found (are you missing a using directive or an assembly reference?)   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   106   WindowsFormsApplication1 Error   24   The type or namespace name 'visual' could not be found (are you missing a using directive or an assembly reference?)   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   116   WindowsFormsApplication1 Error   25   The type or namespace name 'Projects' could not be found (are you missing a using directive or an assembly reference?)   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   135   WindowsFormsApplication1 Error   26   The type or namespace name 'Maturski' could not be found (are you missing a using directive or an assembly reference?)   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   144   WindowsFormsApplication1 Error   27   'WindowsFormsApplication1' is a 'namespace' but is used like a 'type'   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   153   WindowsFormsApplication1 Error   28   The type or namespace name 'Database1' could not be found (are you missing a using directive or an assembly reference?)   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   178   WindowsFormsApplication1

Znaci, nece da prepozna connection string, moguce da sam ga pogresno napravio.

• 0Niko još nije pohvalio poruku.
  Registruj se da bi pohvalio/la poruku!

Pisem sa telefona.
Radis sa SQL bazom.Koja ti je verzija SQL (expresa)?

Po ovome sto vidim,ima gresaka i za connection string.
Vidi clanak koji sam linkovao kako sam to ja uradio.

Takodje,bruka gresaka imas i nevezano za connection string...

• 0Niko još nije pohvalio poruku.
  Registruj se da bi pohvalio/la poruku!

Napisano: 13 Apr 2013 13:20

Wolf13 ::Radim sa bazom iz visual studia ( service based database ).

Error   1   Unrecognized escape sequence   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   62   WindowsFormsApplication1 Error   2   Unrecognized escape sequence   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   93   WindowsFormsApplication1 Error   3   Unexpected character '\'   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   99   WindowsFormsApplication1 Error   4   Unexpected character '\'   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   105   WindowsFormsApplication1 Error   5   Unexpected character '\'   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   115   WindowsFormsApplication1 Error   6   Unexpected character '\'   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   134   WindowsFormsApplication1 Error   7   Unexpected character '\'   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   143   WindowsFormsApplication1 Error   8   Unexpected character '\'   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   152   WindowsFormsApplication1 Error   9   Unexpected character '\'   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   177   WindowsFormsApplication1 Error   10   ) expected   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   91   WindowsFormsApplication1 Error   11   Invalid token ':' in class, struct, or interface member declaration   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   92   WindowsFormsApplication1 Error   12   Invalid token '\' in class, struct, or interface member declaration   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   99   WindowsFormsApplication1 Error   13   Invalid token '\' in class, struct, or interface member declaration   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   105   WindowsFormsApplication1 Error   14   Invalid token '\' in class, struct, or interface member declaration   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   115   WindowsFormsApplication1 Error   15   ; expected   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   130   WindowsFormsApplication1 Error   16   Invalid token '\' in class, struct, or interface member declaration   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   143   WindowsFormsApplication1 Error   17   Invalid token '\' in class, struct, or interface member declaration   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   152   WindowsFormsApplication1 Error   18   Invalid token '\' in class, struct, or interface member declaration   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   177   WindowsFormsApplication1 Error   19   Invalid token '";Integrated Security=True;...' in class, struct, or interface member declaration   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   191   WindowsFormsApplication1 Error   20   The type or namespace name 'c' could not be found (are you missing a using directive or an assembly reference?)   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   91   WindowsFormsApplication1 Error   21   The type or namespace name 'users' could not be found (are you missing a using directive or an assembly reference?)   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   93   WindowsFormsApplication1 Error   22   The type or namespace name 'mario' could not be found (are you missing a using directive or an assembly reference?)   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   100   WindowsFormsApplication1 Error   23   The type or namespace name 'documents' could not be found (are you missing a using directive or an assembly reference?)   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   106   WindowsFormsApplication1 Error   24   The type or namespace name 'visual' could not be found (are you missing a using directive or an assembly reference?)   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   116   WindowsFormsApplication1 Error   25   The type or namespace name 'Projects' could not be found (are you missing a using directive or an assembly reference?)   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   135   WindowsFormsApplication1 Error   26   The type or namespace name 'Maturski' could not be found (are you missing a using directive or an assembly reference?)   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   144   WindowsFormsApplication1 Error   27   'WindowsFormsApplication1' is a 'namespace' but is used like a 'type'   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   153   WindowsFormsApplication1 Error   28   The type or namespace name 'Database1' could not be found (are you missing a using directive or an assembly reference?)   C:\Users\Mario\Documents\Visual Studio 2010\Projects\Maturski\WindowsFormsApplication1\izmena.cs   34   178   WindowsFormsApplication1

Znaci, nece da prepozna connection string, moguce da sam ga pogresno napravio.


Pogresno si ga napravio,uradi ponovo,ne bi bilo lose kada pises kod da sto vise kompajliras,i da izbegnes ovolike greske,imas ih bas puno....

Dopuna: 13 Apr 2013 13:24

Jesi ga pravio u dizajnu ili u kodu?

• 0Niko još nije pohvalio poruku.
  Registruj se da bi pohvalio/la poruku!

Samo je u connection stringu bila greska, evo kako radi :
"Data Source=.\\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|MojaBaza.mdf"

Pravio sam ga u kodu.

• 1Ovo se svidja korisniku: ThePhilosopher
  
  Registruj se da bi pohvalio/la poruku!

Mada si mogao I preko stringbulidera,ja vise volim tako....

SqlConnectionStringBuilder cnnSb = new SqlConnectionStringBuilder cnnSb ();
cnnSb .DataSource = @"(local)\SqlExpress";
cnnSb .InitialCatalog = "Northwind";
cnnSb .IntefratedSecurity = true;

I tako dalje.....