MyCity » Visual Studio -> .NET » Update query u C#

Update query u C#

Napisano na dan: 12.4.2013

Update query u C#
Sledeća strana Pagination

Idi na vrh

Poslao: 12 Apr 2013 14:15
Idi na vrh
offline
  • Pridružio: 16 Okt 2004
  • Poruke: 907
  • Gde živiš: Subotica

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 ..



Registruj se da bi učestvovao u diskusiji. Registrovanim korisnicima se NE prikazuju reklame unutar poruka.
Poslao: 12 Apr 2013 14:23
Idi na vrh
offline
  • Fil  Male
  • Legendarni građanin
  • Pridružio: 11 Jun 2009
  • Poruke: 16586

Pozdrav, pročitaj sledeći članak:
[Link mogu videti samo ulogovani korisnici]



Poslao: 12 Apr 2013 20:36
Idi na vrh
offline
  • Pridružio: 16 Okt 2004
  • Poruke: 907
  • Gde živiš: Subotica

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 ?

Poslao: 12 Apr 2013 20:48
Idi na vrh
offline
  • Fil  Male
  • Legendarni građanin
  • Pridružio: 11 Jun 2009
  • Poruke: 16586

Radis sa Accessovom bazom?
Iskopiraj greske ovde.

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

Poslao: 12 Apr 2013 20:57
Idi na vrh
offline
  • Pridružio: 16 Okt 2004
  • Poruke: 907
  • Gde živiš: Subotica

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.

Poslao: 12 Apr 2013 23:55
Idi na vrh
offline
  • Fil  Male
  • Legendarni građanin
  • Pridružio: 11 Jun 2009
  • Poruke: 16586

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...

Poslao: 13 Apr 2013 13:24
Idi na vrh
offline
  • Pridružio: 24 Dec 2007
  • Poruke: 1592
  • Gde živiš: Beograd

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?

Poslao: 13 Apr 2013 20:44
Idi na vrh
offline
  • Pridružio: 16 Okt 2004
  • Poruke: 907
  • Gde živiš: Subotica

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.

Poslao: 14 Apr 2013 02:05
Idi na vrh
offline
  • Pridružio: 24 Dec 2007
  • Poruke: 1592
  • Gde živiš: Beograd

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.....

MyCity » Visual Studio -> .NET » Update query u C#

Ko je trenutno na forumu
 

Ukupno su 1011 korisnika na forumu :: 87 registrovanih, 7 sakrivenih i 917 gosta   ::   [ Administrator ] [ Supermoderator ] [ Moderator ] :: Detaljnije

Najviše korisnika na forumu ikad bilo je 3466 - dana 01 Jun 2021 17:07

Korisnici koji su trenutno na forumu:
Korisnici trenutno na forumu: 33 bren, A.R.Chafee.Jr., airsuba, ALFASPORTIVO, Apok, aramis s, Asparagus, Azzo, Belac91, bestguarder, Bob.Rock, bojank, Bubimir, Cicumile, Cigi, cvale, darionis, darkangel, DeerHunter, doom83, Dorcolac, E_Kurir, Faki-Valjevo, GeoM, Georgius, goranjovic, GUARIN, Haris, havoc995, Insan, ivan979, JankoS, joca83, Jose, kihot, kovinacc, Kubovac, lafa008, laurusri, lega, Lep1na, lord sir giga, M74AB3, MarijaC84, Markoni958, Mercury, Miki01, Miki281, mikrimaus, monomah, Mrav Obrad, mrvica78, mux, nebidrag, neno panic, neutrino, nick79, nuke92, opt1, Paklenica, Papadubi, Parker, radovanstojkov023, rr559, S-lash, SamostalniReferent, Shinobi, Simonsen23, sol, Srle993, Stoorb, su27, synergia, Tandrkalo, tecataki, Token, ujke, Vatreni Zmaj, vedko, Vlada1389, Vrač, vukovi, W123, Yellow Pinky, Zoca, Zvrk, šumar bk2