|
|
[ jejen83 @ 17.05.2004. 21:49 ] @
|
| Imam jedan problem vezan za access bazu i C#. Napravio sam program koji poseduje jedan data grid u kome se nalazi baza podataka.Baza podataka sadrzi informacije o diskovima, kao sto je redni broj, naslov diska, njegova kategorija, i naravno kome je disk i da li je uopste pozajmljen. Dodao sam na formu i jedan textBox. E, sad stvar je sledeca. Ocu da kad upisem u taj textBox, npr. slovo a da mi on u data gridu izbacuje odnosno ostavlja samo diskove ciji naslov pocinje sa "a:.U SQL- u to ide ovako:
Code:
private void textBox1_TextChanged(object sender, System.EventArgs e)
{
oleDbDataAdapter1.SelectCommand.CommandText="SELECT*FROM CD WHERE naslov LIKE '"+textBox1.Text+"*'";
MessageBox.Show("SELECT cd.* FROM cd WHERE (cd.Naslov LIKE '"+textBox1.Text+"*')");
dataSet11.Clear();
oleDbDataAdapter1.Fill( dataSet11);
}
Ako neko zna molim za pomoc.Hvala unapred. |
[ veljaradenkovic @ 17.05.2004. 22:37 ] @
Podatke koje si iscitao iz baze u DataSet sad treba da smestis u DataGrid.
A to ces ovako:
Code:
this.dataGrid1.DataSource=dataSet11.Tables[0];
Podrazumevam da te interesuje ova jedna tabela sto si je smestio u data set sa kodom tvojim.
Dakle dataSet11 moze da bude kolekcija tabela... a prvu i jedinu koju si iscitao iz baze pozivas preko indexa... indexi idu od nule pa ti je ovo dataSet11.Tables[0] bas ta tabela.
Ovo dataGrid1 je tvoj DataGrid pa tu stavi i njegovo ime ako se drukcije zove.
Pozdrav. [ jejen83 @ 17.05.2004. 23:31 ] @
Izgleda da se nismo razumeli. Ja sam vec napravio data grid i filovo ga, ali hocu da kad ukucam u textBoxu neki karakter, npr "a" da mi on update-uje dataGrid i ispise sve u ovom slucaju diskove koji pocinju sa slovom koje sam ukucao u textBoxu, u ovom slucaju "a".
[ Željko @ 18.05.2004. 08:49 ] @
Ono sto tebi treba je "Sorting and Filtering Data Using a DataView" pa stoga pogledaj ovaj link:
http://msdn.microsoft.com/libr...filteringdatausingdataview.asp
pozdrav Željko
[ jablan @ 18.05.2004. 08:58 ] @
Citat: jejen83:
Code:
oleDbDataAdapter1.SelectCommand.CommandText="SELECT*FROM CD WHERE naslov LIKE '"+textBox1.Text+"*'";
Džoker u SQL-u nije zvezdica već procenat. [ mmix @ 18.05.2004. 09:10 ] @
Citat: jablan:
Džoker u SQL-u nije zvezdica već procenat.
Zvezdica je za Access. Ako si sad pomislio "daj, nema šanse", znaj da sam i ja to pomislio  MS, go figure
[ jejen83 @ 18.05.2004. 13:05 ] @
Hvala vam puno, nisam jos probao ovo sto mi je jablan odgovorio, ali probacu, a iskreno, da je dzoker u SQL-u procenat nisam znao, hvala.Ako se negde zaglavim, eto mene ponovo, naravno ako budete voljni pomoci. Pozdrav.
[ jejen83 @ 18.05.2004. 13:40 ] @
Uf, momci probao sam ovo sto mi je jablan napisao i nece.Poludecu. evo sta sam uradio.
Code:
private void textBox3_TextChanged(object sender, System.EventArgs e)
{
oleDbDataAdapter1.SelectCommand.CommandText="SELECT * FROM Diskovi WHERE Naslov diska LIKE '"+textBox1.Text+"*'";
}
Eto, i kad kompajliram sve prodje ok, ali kad pokrenem i ukucam nesto u textBox3 nista se nedesava, bazsa ostaje kakva jeste, tj neodstranjuje podatke cije ime nepocinje sa karakterom koji je unet u texBox3. Ako je neko voljan da mi pomogne,poludecu. Samo mi jos to treba da zavrsim program.Hvala [ mmix @ 18.05.2004. 15:10 ] @
Citat: jejen83:
Uf, momci probao sam ovo sto mi je jablan napisao i nece.Poludecu. evo sta sam uradio.
Pazi ovako prijatelju, koncepcijski nisi dobro razumeo kako radi DataGrid. Onog trenutka kad uradiš DataBind nad gridom, grid povuče podatke i od tad pa nadalje koristi svoj interni "offline" set podataka za iscrtavanje. To što si ti promenio komandu u DataAdapteru kojim si punio grid ne utiče nikako na pomenute "offline" podatke. Da bi "osvežio" te podatke, moraš ponovo da uradiš Bind-ovanje:
Code:
private void textBox1_TextChanged(object sender, System.EventArgs e)
{
oleDbDataAdapter1.SelectCommand.CommandText="SELECT * FROM
CD WHERE naslov LIKE '"+textBox1.Text+"*'";
dataSet11.Clear();
oleDbDataAdapter1.Fill( dataSet11);
// sledeću liniju ne ubacuješ ako ti je grid statički vezan za dataSet
dataGrid1.DataSource=dataSet11;
// ova linije ja ono što tebi fali
dataGrid1.DataBind();
}
I još nešto, ako je ovo asp.net aplikacija (mada pretpostavljam da nije), TextChanged event za textBox kontrolu se okida tek na prvi sledeći postback, te stoga neće reagovati na inkrementalno ukucavanje teksta kao što to radi WinForms ekvivalent.
E sad, postoji i šema sa DataView za koju ti je link dao Željko, to je dobra fora (učitaš jedanput sve pa filtriraš offline) ali i u tom slučaju moraš dataGrid da re-binduješ da bi dataGrid osvežio svoj set podataka.
[ jejen83 @ 18.05.2004. 16:21 ] @
Probao sam da dodam ceo ovaj kod koji si mi dao, i kad sam pokrenuo program i upisao bilo sta u text box dobio sam poruku tipa:
....Syintax error (missing operator) in query expression 'Naslov diska LIKE CD Katalog by Bojan Mrdja' ???? Neznam kakve ovo ima veze, kad sam lepo u kodu naveo sledece:
Code:
private void textBox3_TextChanged(object sender, System.EventArgs e)
{
//oleDbDataAdapter1.SelectCommand.CommandText="SELECT * FROM Diskovi WHERE Naslov diska LIKE '"+textBox1.Text+"*'";
oleDbDataAdapter1.SelectCommand.CommandText="SELECT * FROM Diskovi WHERE Naslov diska LIKE '"+textBox1.Text+"*'";
dataSet11.Clear();
oleDbDataAdapter1.Fill( dataSet11);
// sledecu liniju ne ubacuješ ako ti je grid taticki vezan za dataSet
//dataGrid1.DataSource=dataSet11;
// ova linije ja ono što tebi fali
//dataGrid1.DataBind();
}
E, sad sam se stvarno zbunio.Nista mi nije jasno. [ mmix @ 18.05.2004. 16:28 ] @
Polje čiji naziv sadrži space mora da ide pod kockaste zagrade, plus access oce da luduje oko nedostatka zagrada u logičkim uslovima, probaj ovu liniju umesto postojeće:
Code:
oleDbDataAdapter1.SelectCommand.CommandText="SELECT * FROM Diskovi WHERE ([Naslov diska] LIKE '"+textBox1.Text+"*')";
BTW, jel se meni čini ili si ti komentirao liniju sa DataBind? [ jejen83 @ 18.05.2004. 17:34 ] @
Jedino sto se sad desava je nista, tj, kad ukucam bilo sta on mi izbrise celu bazi iz data grida i to je to.Neostavlja mi diskove koji pocinju sa karakterom koji sam ukucao u textBox. Porbao sam i da otkomentarisem liniju dataGrid1.dataBind() ali dobijam poruku tipa: 'System.Windows.Forms.DataGrid' does not contain a definition for 'DataBind'. Neznam vise sta da radim.Nemoj da se ljutis na mene, relativno sam skoro poceo da radim c#, pa sam jos pocetnik.Ako znas kako da uradis i hoces mogu ti poslati programce da probas. Pozdrav i veliko HVALA.
[ mmix @ 18.05.2004. 17:47 ] @
Nemoj da se izvinjavaš, moja krivica, predugo sam u asp.net vodama pa sam omanuo za naziv metode, umesto dataGrid1.DataBind linije stavi:
Code:
dataGrid1.SetDataBinding(dataSet11, "Diskovi");
[ jejen83 @ 18.05.2004. 20:44 ] @
E,probao sam ovo i opet nisam nista dobio.Opet mi obrise celu bazu, a nece da mi prikaze samo diskove koji poseduju taj karakter, i jos me sad da da samo jedan karakter unesem u texBox, pa onda moram ponovo da kliknem na textBox da bi mogao da dodam drugi.
kod sam napisao ovako:
Code:
private void textBox3_TextChanged(object sender, System.EventArgs e)
{
//oleDbDataAdapter1.SelectCommand.CommandText="SELECT * FROM Diskovi WHERE Naslov diska LIKE '"+textBox1.Text+"*'";
oleDbDataAdapter1.SelectCommand.CommandText="SELECT * FROM Diskovi WHERE ([Naslov diska] LIKE '"+textBox1.Text+"*')";
dataSet11.Clear();
oleDbDataAdapter1.Fill( dataSet11);
// sledecu liniju ne ubacuješ ako ti je grid staticki vezan za dataSet
//dataGrid1.DataSource=dataSet11;
//ova linije ja ono što tebi fali
dataGrid1.SetDataBinding(dataSet11, "Diskovi");
}
Uf, poludecu.I tako ti ja nema sanse da resim problem.Vise stvarno ne znam sta da radim.Niko pa cak ni moji profesori koji ovo predaju na mom faksu neznaju da urade, znaju kao sa sql-om, mada verujem da neznaju ni to, nego kao fora.Aj ako ti padne jos neko moguce resenje ti pomogaj.Hvala ti, pozdrav Bojan
[ degojs @ 18.05.2004. 21:30 ] @
Umesto * stavi % i rešena stvar (kako je jablan već napisao). Pozdrav.
[Ovu poruku je menjao degojs dana 18.05.2004. u 17:35 GMT]
[ sslavko @ 18.05.2004. 21:34 ] @
Citat: jejen83:
E,probao sam ovo i opet nisam nista dobio.Opet mi obrise celu bazu, a nece da mi prikaze samo diskove koji poseduju taj karakter, i jos me sad da da samo jedan karakter unesem u texBox, pa onda moram ponovo da kliknem na textBox da bi mogao da dodam drugi.
}
Moras da stavis procenat umesto zvezdice u SQL upitu i radice. Probao sam. I obavezno otkomentarisi ovaj deo:
dataGrid1.DataSource=dataSet11;
[ jejen83 @ 19.05.2004. 08:39 ] @
E,pa narode meni je baza u Accessu a ne u SQL - u sto bi stavljao procenat, koliko sam ukapirao to je za SQL, ili mozda gresim? U svakom slucaju sad cu da probam! Ne, nece da radi, opet mi program puca. uradio sam to sto ste rekli. Nista se nedesava, kako ukucam neko slovo u textBox, dsamo nestane cela baza i program pukne.Eto to je sve sto se desava.
[ mmix @ 19.05.2004. 09:15 ] @
Ovo je vec tumaranje po mraku. Ajde lepo okaci samo .cs fajl od forme ovde pa da vidimo gde je previd.
[ sslavko @ 19.05.2004. 12:58 ] @
Citat: jejen83:
E,pa narode meni je baza u Accessu a ne u SQL - u sto bi stavljao procenat, koliko sam ukapirao to je za SQL, ili mozda gresim? U svakom slucaju sad cu da probam! Ne, nece da radi, opet mi program puca. uradio sam to sto ste rekli. Nista se nedesava, kako ukucam neko slovo u textBox, dsamo nestane cela baza i program pukne.Eto to je sve sto se desava.
Pa i Access koristi SQL za upite. A da bi nesto bilo SQL mora da ispostuje standard. A u SQL specifikaciji pise da tu treba da stoji procenat a ne zvezdica i Microsoft to mora da ispostuje. Mogu oni da dodaju svoje specificnosti ali osnovni standard mora da se ispostuje. Dobar primer je MS Visual C++. Da bi uopste bio C++ mora da ispostuje ANSI C++ specifikaciju, a MS je uz to dodao i gomilu svojih stvari ali to ne narusava standard. Dobro, znam da ima odstupanja u ovome sto sam napisao i da nije bas 100% tako ali u nacelu to je logika. [ degojs @ 19.05.2004. 14:34 ] @
Citat: E,pa narode meni je baza u Accessu a ne u SQL - u sto bi stavljao procenat, koliko sam ukapirao to je za SQL, ili mozda gresim?
Grešiš u ovom slučaju..
Citat: Ne, nece da radi, opet mi program puca. uradio sam to sto ste rekli.
Onda je neki drugi problem u pitanju pošto provereno radi sa %. Sad sam napravio i primer baš kakav tebi treba i radi bez problema. Sa % radi, a sa * ne. [ degojs @ 19.05.2004. 15:02 ] @
Da razrašimo dilemu, evo koda (pisanog na brzinu čisto primera radi), koji radi:
Code:
private void textBox1_TextChanged(object sender, System.EventArgs e)
{
string cs = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=w:\\temp\\temp\\serviceshop.mdb";
OleDbConnection con = new System.Data.OleDb.OleDbConnection( cs );
string SQL = "SELECT * FROM Vehicles WHERE Make LIKE '" + textBox1.Text + "%'";
OleDbCommand cmd = new OleDbCommand( SQL, con);
OleDbDataAdapter da;
da = new OleDbDataAdapter( cmd );
DataSet ds = new DataSet();
da.Fill( ds, "Vehicles");
this.dataGrid1.DataSource = ds.Tables["Vehicles"];
this.dataGrid1.Refresh();
}
[ mmix @ 19.05.2004. 16:26 ] @
Ajde da ne bude da sam veverica, evo izvod iz Help-a za Access 2003:
http://office.microsoft.com/as...7011033&QueryID=fqR5H0yKW0
Osim ako na neki misteriozni način Jet drajver ne zameni % sa * pre nego izvrši skriptu, na Accessu procenat ne prolazi, bar ne kod mene i bar nije ni na Office 2000 ni Xp ni 2003. Štaviše Access-ov SQL nema mnogo veze sa standardnim SQLom, i ide do te mere u boleštinu da u njemu rade built-in VBScript funkcije tipa CStr, Cint, itd. [ degojs @ 19.05.2004. 17:16 ] @
Nisi veverica :) ali ovde se ne radi direktno u Access-u.
Svega ovog ne bi bilo da je Perica još na početku poslušao Jablana i zamenio * sa % ... :)
[ jejen83 @ 19.05.2004. 18:40 ] @
Nisam probao sve ovo sto ste rekli, ali perica je poslusao jablana ali nije uspeo.Veruj mi.Nisam imao vremena danas da okacim moj .cs fajl od forme, sutra cu, pa ako budete imali vremena pogledajte ga, pa vidite gde je previd.
Svega ovoga nebi bilo da Perica (ja) nije ni poceo da pravi program.
Pozdrav i hvala!
[ sslavko @ 19.05.2004. 23:01 ] @
Citat:
Ajde da ne bude da sam veverica, evo izvod iz Help-a za Access 2003:
http://office.microsoft.com/as...7011033&QueryID=fqR5H0yKW0
Osim ako na neki misteriozni način Jet drajver ne zameni % sa * pre nego izvrši skriptu, na Accessu procenat ne prolazi, bar ne kod mene i bar nije ni na Office 2000 ni Xp ni 2003. Štaviše Access-ov SQL nema mnogo veze sa standardnim SQLom, i ide do te mere u boleštinu da u njemu rade built-in VBScript funkcije tipa CStr, Cint, itd.
Ovde zaista pise da treba zvezdica, ali to se ocigledno ne odnosi na pristup iz .NET-a. Evo kod mene to definitivno ne prolazi, mora procenat. Jedino logicno objasnjenje je da postoji razlika kada se mdb-u pristupa iz Access-a i programski kroz JET drajver. [ Mrav @ 20.05.2004. 01:13 ] @
Prosto i jednostavno:
Code:
private void unos_TextChanged(object sender, System.EventArgs e)
{
DataView pogled = new DataView(podaci);
pogled.RowFilter = "Ime LIKE '"+unos.Text+"%'";
prikaz.DataSource = pogled;
}
dobro, ovo je f-ja koja odgovara na TextChanged za TextBox.
podaci je objekat tipa DataTable u koji smo učitali neku tabelu iz baze (Ukoliko koristiš DataSet popunićeš DataView sa mojdataset.Tables["nekatabela"]).
postavi RowFilter property i postavi data source za tvoj prikaz (DataGrid, ListBox, nije bitno).
Kao što vidiš koristi se %. [ ZokiR @ 20.05.2004. 01:35 ] @
http://msdn.microsoft.com/libr...en-us/dnima01/html/ima0601.asp
Using the Right Wildcard Characters in SQL Statements
In Access 2000, Access SQL was updated to more closely emulate the SQL-92 standard through syntax exposed by ADO and the Microsoft Jet OLE DB Provider. This impacts many aspects of using SQL statements in code, one of which is wildcard behavior. The pattern-matching characters we looked at last month were provided through DAO. Rather than using the asterisk (*) and question mark (?) symbols as wildcards, ADO requires that you use the percent sign (%) to match multiple characters and the underscore (_) to match a single character.
[ jejen83 @ 20.05.2004. 10:51 ] @
Evo mog koda, pa vi vididte gde sta nestima:
Code:
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Diagnostics;
namespace CD_Katalog
{
/// <summary>
/// Summary description for Form1.
/// </summary>
public class Forma1 : System.Windows.Forms.Form
{
private System.Windows.Forms.MainMenu mainMenu1;
private System.Windows.Forms.MenuItem menuItem1;
private System.Windows.Forms.MenuItem menuItem2;
private System.Windows.Forms.MenuItem menuItem9;
private System.Windows.Forms.MenuItem menuItem10;
private System.Windows.Forms.GroupBox groupBox1;
private System.Windows.Forms.StatusBar statusBar1;
private System.Windows.Forms.GroupBox groupBox2;
private System.Windows.Forms.GroupBox groupBox3;
private System.Windows.Forms.Button button2;
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.TextBox textBox2;
private System.Windows.Forms.ComboBox comboBox1;
private System.Windows.Forms.Button button3;
private System.Windows.Forms.Button button4;
private System.Windows.Forms.DataGrid dataGrid1;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.GroupBox groupBox4;
private System.Data.OleDb.OleDbCommand oleDbSelectCommand1;
private System.Data.OleDb.OleDbCommand oleDbInsertCommand1;
private System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;
private System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;
private System.Data.OleDb.OleDbConnection oleDbConnection1;
private System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1;
public CD_Katalog.DataSet1 dataSet11;
private System.Data.OleDb.OleDbCommand oleDbSelectCommand2;
private System.Data.OleDb.OleDbCommand oleDbInsertCommand2;
private System.Data.OleDb.OleDbCommand oleDbUpdateCommand2;
private System.Data.OleDb.OleDbCommand oleDbDeleteCommand2;
private System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter2;
private System.Windows.Forms.Button osveziBbutton;
private System.Windows.Forms.DataGridTableStyle dataGridTableStyle1;
private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn1;
private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn2;
private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn3;
private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn4;
private System.Windows.Forms.ToolTip toolTip1;
private System.Windows.Forms.TextBox textBox3;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.MenuItem menuItem3;
private System.Windows.Forms.CheckBox checkBox1;
private System.Windows.Forms.Label label3;
private System.ComponentModel.IContainer components;
public Forma1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
//
// TODO: Add any constructor code after InitializeComponent call
//
}
/// <summary>
/// Clean up any resources being used.
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(Forma1));
this.mainMenu1 = new System.Windows.Forms.MainMenu();
this.menuItem1 = new System.Windows.Forms.MenuItem();
this.menuItem2 = new System.Windows.Forms.MenuItem();
this.menuItem3 = new System.Windows.Forms.MenuItem();
this.menuItem9 = new System.Windows.Forms.MenuItem();
this.menuItem10 = new System.Windows.Forms.MenuItem();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.label2 = new System.Windows.Forms.Label();
this.textBox3 = new System.Windows.Forms.TextBox();
this.dataGrid1 = new System.Windows.Forms.DataGrid();
this.dataSet11 = new CD_Katalog.DataSet1();
this.dataGridTableStyle1 = new System.Windows.Forms.DataGridTableStyle();
this.dataGridTextBoxColumn1 = new System.Windows.Forms.DataGridTextBoxColumn();
this.dataGridTextBoxColumn2 = new System.Windows.Forms.DataGridTextBoxColumn();
this.dataGridTextBoxColumn3 = new System.Windows.Forms.DataGridTextBoxColumn();
this.dataGridTextBoxColumn4 = new System.Windows.Forms.DataGridTextBoxColumn();
this.statusBar1 = new System.Windows.Forms.StatusBar();
this.groupBox2 = new System.Windows.Forms.GroupBox();
this.label3 = new System.Windows.Forms.Label();
this.checkBox1 = new System.Windows.Forms.CheckBox();
this.button4 = new System.Windows.Forms.Button();
this.button3 = new System.Windows.Forms.Button();
this.comboBox1 = new System.Windows.Forms.ComboBox();
this.textBox2 = new System.Windows.Forms.TextBox();
this.groupBox3 = new System.Windows.Forms.GroupBox();
this.button2 = new System.Windows.Forms.Button();
this.textBox1 = new System.Windows.Forms.TextBox();
this.osveziBbutton = new System.Windows.Forms.Button();
this.label1 = new System.Windows.Forms.Label();
this.groupBox4 = new System.Windows.Forms.GroupBox();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
this.oleDbInsertCommand2 = new System.Data.OleDb.OleDbCommand();
this.oleDbUpdateCommand2 = new System.Data.OleDb.OleDbCommand();
this.oleDbDeleteCommand2 = new System.Data.OleDb.OleDbCommand();
this.oleDbDataAdapter2 = new System.Data.OleDb.OleDbDataAdapter();
this.toolTip1 = new System.Windows.Forms.ToolTip(this.components);
this.groupBox1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
this.groupBox2.SuspendLayout();
this.groupBox3.SuspendLayout();
this.groupBox4.SuspendLayout();
this.SuspendLayout();
//
// mainMenu1
//
this.mainMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem1,
this.menuItem9});
//
// menuItem1
//
this.menuItem1.Index = 0;
this.menuItem1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem2,
this.menuItem3});
this.menuItem1.Text = "Ba&za Podataka";
//
// menuItem2
//
this.menuItem2.Index = 0;
this.menuItem2.Shortcut = System.Windows.Forms.Shortcut.AltF10;
this.menuItem2.Text = "Snimi &bazu podataka";
//
// menuItem3
//
this.menuItem3.Index = 1;
this.menuItem3.Shortcut = System.Windows.Forms.Shortcut.AltF4;
this.menuItem3.Text = "I&zlaz";
this.menuItem3.Click += new System.EventHandler(this.menuItem3_Click_1);
//
// menuItem9
//
this.menuItem9.Index = 1;
this.menuItem9.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem10});
this.menuItem9.Text = "&O programu";
//
// menuItem10
//
this.menuItem10.Index = 0;
this.menuItem10.Shortcut = System.Windows.Forms.Shortcut.F1;
this.menuItem10.Text = "O &Cd Katalogu...";
this.menuItem10.Click += new System.EventHandler(this.menuItem10_Click);
//
// groupBox1
//
this.groupBox1.Controls.Add(this.label2);
this.groupBox1.Controls.Add(this.textBox3);
this.groupBox1.Controls.Add(this.dataGrid1);
this.groupBox1.Location = new System.Drawing.Point(8, 8);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(472, 320);
this.groupBox1.TabIndex = 0;
this.groupBox1.TabStop = false;
this.groupBox1.Text = "Diskovi";
//
// label2
//
this.label2.Location = new System.Drawing.Point(64, 16);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(56, 23);
this.label2.TabIndex = 2;
this.label2.Text = "Traži disk:";
this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// textBox3
//
this.textBox3.Location = new System.Drawing.Point(120, 16);
this.textBox3.Name = "textBox3";
this.textBox3.Size = new System.Drawing.Size(224, 20);
this.textBox3.TabIndex = 1;
this.textBox3.Text = "";
this.textBox3.TextChanged += new System.EventHandler(this.textBox3_TextChanged);
//
// dataGrid1
//
this.dataGrid1.BackgroundColor = System.Drawing.Color.Lavender;
this.dataGrid1.DataMember = "Diskovi";
this.dataGrid1.DataSource = this.dataSet11;
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(8, 48);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.Size = new System.Drawing.Size(456, 264);
this.dataGrid1.TabIndex = 0;
this.dataGrid1.TableStyles.AddRange(new System.Windows.Forms.DataGridTableStyle[] {
this.dataGridTableStyle1});
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.Locale = new System.Globalization.CultureInfo("sr-SP-Latn");
//
// dataGridTableStyle1
//
this.dataGridTableStyle1.DataGrid = this.dataGrid1;
this.dataGridTableStyle1.GridColumnStyles.AddRange(new System.Windows.Forms.DataGridColumnStyle[] {
this.dataGridTextBoxColumn1,
this.dataGridTextBoxColumn2,
this.dataGridTextBoxColumn3,
this.dataGridTextBoxColumn4});
this.dataGridTableStyle1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGridTableStyle1.MappingName = "Diskovi";
//
// dataGridTextBoxColumn1
//
this.dataGridTextBoxColumn1.Alignment = System.Windows.Forms.HorizontalAlignment.Center;
this.dataGridTextBoxColumn1.Format = "";
this.dataGridTextBoxColumn1.FormatInfo = null;
this.dataGridTextBoxColumn1.HeaderText = "R.b.";
this.dataGridTextBoxColumn1.MappingName = "Redni broj";
this.dataGridTextBoxColumn1.NullText = "";
this.dataGridTextBoxColumn1.ReadOnly = true;
this.dataGridTextBoxColumn1.Width = 60;
//
// dataGridTextBoxColumn2
//
this.dataGridTextBoxColumn2.Alignment = System.Windows.Forms.HorizontalAlignment.Center;
this.dataGridTextBoxColumn2.Format = "";
this.dataGridTextBoxColumn2.FormatInfo = null;
this.dataGridTextBoxColumn2.HeaderText = "Naslov Diska";
this.dataGridTextBoxColumn2.MappingName = "Naslov diska";
this.dataGridTextBoxColumn2.NullText = "";
this.dataGridTextBoxColumn2.Width = 170;
//
// dataGridTextBoxColumn3
//
this.dataGridTextBoxColumn3.Alignment = System.Windows.Forms.HorizontalAlignment.Center;
this.dataGridTextBoxColumn3.Format = "";
this.dataGridTextBoxColumn3.FormatInfo = null;
this.dataGridTextBoxColumn3.HeaderText = "Kategorija";
this.dataGridTextBoxColumn3.MappingName = "Kategorija";
this.dataGridTextBoxColumn3.NullText = "";
this.dataGridTextBoxColumn3.Width = 78;
//
// dataGridTextBoxColumn4
//
this.dataGridTextBoxColumn4.Alignment = System.Windows.Forms.HorizontalAlignment.Center;
this.dataGridTextBoxColumn4.Format = "";
this.dataGridTextBoxColumn4.FormatInfo = null;
this.dataGridTextBoxColumn4.HeaderText = "Pozajmica";
this.dataGridTextBoxColumn4.MappingName = "Nadimak";
this.dataGridTextBoxColumn4.NullText = "";
this.dataGridTextBoxColumn4.Width = 105;
//
// statusBar1
//
this.statusBar1.Location = new System.Drawing.Point(0, 342);
this.statusBar1.Name = "statusBar1";
this.statusBar1.Size = new System.Drawing.Size(744, 22);
this.statusBar1.TabIndex = 1;
//
// groupBox2
//
this.groupBox2.Controls.Add(this.label3);
this.groupBox2.Controls.Add(this.checkBox1);
this.groupBox2.Controls.Add(this.button4);
this.groupBox2.Controls.Add(this.button3);
this.groupBox2.Controls.Add(this.comboBox1);
this.groupBox2.Controls.Add(this.textBox2);
this.groupBox2.Location = new System.Drawing.Point(488, 8);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(248, 144);
this.groupBox2.TabIndex = 2;
this.groupBox2.TabStop = false;
this.groupBox2.Text = "Dodavanje diskova";
//
// label3
//
this.label3.Location = new System.Drawing.Point(32, 104);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(120, 23);
this.label3.TabIndex = 5;
this.label3.Text = "Dodavanje diskova";
this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
this.toolTip1.SetToolTip(this.label3, "Ukljucite da bi ste omogucili dodavanje diskova");
//
// checkBox1
//
this.checkBox1.Location = new System.Drawing.Point(16, 104);
this.checkBox1.Name = "checkBox1";
this.checkBox1.Size = new System.Drawing.Size(16, 24);
this.checkBox1.TabIndex = 4;
this.checkBox1.CheckStateChanged += new System.EventHandler(this.checkBox1_CheckStateChanged);
//
// button4
//
this.button4.Enabled = false;
this.button4.Location = new System.Drawing.Point(160, 104);
this.button4.Name = "button4";
this.button4.Size = new System.Drawing.Size(80, 23);
this.button4.TabIndex = 3;
this.button4.Text = "Snimi u bazu";
this.toolTip1.SetToolTip(this.button4, "Po izvrsenju promena pritisni za update baze");
this.button4.Click += new System.EventHandler(this.button4_Click);
//
// button3
//
this.button3.Enabled = false;
this.button3.Location = new System.Drawing.Point(160, 64);
this.button3.Name = "button3";
this.button3.Size = new System.Drawing.Size(80, 24);
this.button3.TabIndex = 2;
this.button3.Text = "Dodaj CD";
this.toolTip1.SetToolTip(this.button3, "Po unosenju podataka pritisni dugme za dodavanje diskova");
this.button3.Click += new System.EventHandler(this.button3_Click);
//
// comboBox1
//
this.comboBox1.CausesValidation = false;
this.comboBox1.DataSource = this.dataSet11;
this.comboBox1.DisplayMember = "Kategorija.Kategorija";
this.comboBox1.Enabled = false;
this.comboBox1.ImeMode = System.Windows.Forms.ImeMode.NoControl;
this.comboBox1.Location = new System.Drawing.Point(16, 64);
this.comboBox1.Name = "comboBox1";
this.comboBox1.Size = new System.Drawing.Size(136, 21);
this.comboBox1.TabIndex = 1;
this.comboBox1.ValueMember = "Kategorija.Kategorija";
//
// textBox2
//
this.textBox2.Enabled = false;
this.textBox2.Location = new System.Drawing.Point(16, 24);
this.textBox2.Name = "textBox2";
this.textBox2.Size = new System.Drawing.Size(216, 20);
this.textBox2.TabIndex = 0;
this.textBox2.Text = "";
//
// groupBox3
//
this.groupBox3.Controls.Add(this.button2);
this.groupBox3.Location = new System.Drawing.Point(488, 256);
this.groupBox3.Name = "groupBox3";
this.groupBox3.Size = new System.Drawing.Size(248, 72);
this.groupBox3.TabIndex = 3;
this.groupBox3.TabStop = false;
this.groupBox3.Text = "Drugari";
//
// button2
//
this.button2.Image = ((System.Drawing.Image)(resources.GetObject("button2.Image")));
this.button2.ImageAlign = System.Drawing.ContentAlignment.MiddleRight;
this.button2.Location = new System.Drawing.Point(80, 32);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(88, 23);
this.button2.TabIndex = 1;
this.button2.Text = "Info o drugu";
this.button2.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
this.toolTip1.SetToolTip(this.button2, "Informacije vezane za drugove");
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// textBox1
//
this.textBox1.Cursor = System.Windows.Forms.Cursors.Default;
this.textBox1.Location = new System.Drawing.Point(8, 336);
this.textBox1.Name = "textBox1";
this.textBox1.ReadOnly = true;
this.textBox1.Size = new System.Drawing.Size(736, 20);
this.textBox1.TabIndex = 4;
this.textBox1.Text = "CD Katalog by Mrdja Bojan";
this.textBox1.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
//
// osveziBbutton
//
this.osveziBbutton.Image = ((System.Drawing.Image)(resources.GetObject("osveziBbutton.Image")));
this.osveziBbutton.Location = new System.Drawing.Point(176, 24);
this.osveziBbutton.Name = "osveziBbutton";
this.osveziBbutton.Size = new System.Drawing.Size(56, 48);
this.osveziBbutton.TabIndex = 4;
this.toolTip1.SetToolTip(this.osveziBbutton, "Osvezi bazu");
this.osveziBbutton.Click += new System.EventHandler(this.osveziBbutton_Click);
//
// label1
//
this.label1.Location = new System.Drawing.Point(8, 32);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(152, 23);
this.label1.TabIndex = 5;
this.label1.Text = "Osveži bazu podataka";
this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
//
// groupBox4
//
this.groupBox4.Controls.Add(this.osveziBbutton);
this.groupBox4.Controls.Add(this.label1);
this.groupBox4.Location = new System.Drawing.Point(488, 160);
this.groupBox4.Name = "groupBox4";
this.groupBox4.Size = new System.Drawing.Size(248, 88);
this.groupBox4.TabIndex = 5;
this.groupBox4.TabStop = false;
this.groupBox4.Text = "Baza podataka";
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = "SELECT Kategorija, Nadimak, [Naslov diska], [Redni broj] FROM Diskovi";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;Data Source=""D:\CD Katalog\cdkatalog.mdb"";Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False";
//
// oleDbInsertCommand1
//
this.oleDbInsertCommand1.CommandText = "INSERT INTO Diskovi(Kategorija, Nadimak, [Naslov diska]) VALUES (?, ?, ?)";
this.oleDbInsertCommand1.Connection = this.oleDbConnection1;
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Kategorija", System.Data.OleDb.OleDbType.VarWChar, 50, "Kategorija"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Nadimak", System.Data.OleDb.OleDbType.VarWChar, 50, "Nadimak"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Naslov_diska", System.Data.OleDb.OleDbType.VarWChar, 50, "Naslov diska"));
//
// oleDbUpdateCommand1
//
this.oleDbUpdateCommand1.CommandText = @"UPDATE Diskovi SET Kategorija = ?, Nadimak = ?, [Naslov diska] = ? WHERE ([Redni broj] = ?) AND (Kategorija = ? OR ? IS NULL AND Kategorija IS NULL) AND (Nadimak = ? OR ? IS NULL AND Nadimak IS NULL) AND ([Naslov diska] = ? OR ? IS NULL AND [Naslov diska] IS NULL)";
this.oleDbUpdateCommand1.Connection = this.oleDbConnection1;
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Kategorija", System.Data.OleDb.OleDbType.VarWChar, 50, "Kategorija"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Nadimak", System.Data.OleDb.OleDbType.VarWChar, 50, "Nadimak"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Naslov_diska", System.Data.OleDb.OleDbType.VarWChar, 50, "Naslov diska"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Redni_broj", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Redni broj", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Kategorija", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Kategorija", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Kategorija1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Kategorija", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Nadimak", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Nadimak", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Nadimak1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Nadimak", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Naslov_diska", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Naslov diska", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Naslov_diska1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Naslov diska", System.Data.DataRowVersion.Original, null));
//
// oleDbDeleteCommand1
//
this.oleDbDeleteCommand1.CommandText = "DELETE FROM Diskovi WHERE ([Redni broj] = ?) AND (Kategorija = ? OR ? IS NULL AND" +
" Kategorija IS NULL) AND (Nadimak = ? OR ? IS NULL AND Nadimak IS NULL) AND ([Na" +
"slov diska] = ? OR ? IS NULL AND [Naslov diska] IS NULL)";
this.oleDbDeleteCommand1.Connection = this.oleDbConnection1;
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Redni_broj", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Redni broj", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Kategorija", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Kategorija", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Kategorija1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Kategorija", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Nadimak", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Nadimak", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Nadimak1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Nadimak", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Naslov_diska", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Naslov diska", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Naslov_diska1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Naslov diska", System.Data.DataRowVersion.Original, null));
//
// oleDbDataAdapter1
//
this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand1;
this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1;
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Diskovi", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("Kategorija", "Kategorija"),
new System.Data.Common.DataColumnMapping("Nadimak", "Nadimak"),
new System.Data.Common.DataColumnMapping("Naslov diska", "Naslov diska"),
new System.Data.Common.DataColumnMapping("Redni broj", "Redni broj")})});
this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1;
//
// oleDbSelectCommand2
//
this.oleDbSelectCommand2.CommandText = "SELECT Kategorija FROM Kategorija";
this.oleDbSelectCommand2.Connection = this.oleDbConnection1;
//
// oleDbInsertCommand2
//
this.oleDbInsertCommand2.CommandText = "INSERT INTO Kategorija(Kategorija) VALUES (?)";
this.oleDbInsertCommand2.Connection = this.oleDbConnection1;
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Kategorija", System.Data.OleDb.OleDbType.VarWChar, 50, "Kategorija"));
//
// oleDbUpdateCommand2
//
this.oleDbUpdateCommand2.CommandText = "UPDATE Kategorija SET Kategorija = ? WHERE (Kategorija = ?)";
this.oleDbUpdateCommand2.Connection = this.oleDbConnection1;
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Kategorija", System.Data.OleDb.OleDbType.VarWChar, 50, "Kategorija"));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Kategorija", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Kategorija", System.Data.DataRowVersion.Original, null));
//
// oleDbDeleteCommand2
//
this.oleDbDeleteCommand2.CommandText = "DELETE FROM Kategorija WHERE (Kategorija = ?)";
this.oleDbDeleteCommand2.Connection = this.oleDbConnection1;
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Kategorija", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Kategorija", System.Data.DataRowVersion.Original, null));
//
// oleDbDataAdapter2
//
this.oleDbDataAdapter2.DeleteCommand = this.oleDbDeleteCommand2;
this.oleDbDataAdapter2.InsertCommand = this.oleDbInsertCommand2;
this.oleDbDataAdapter2.SelectCommand = this.oleDbSelectCommand2;
this.oleDbDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Kategorija", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("Kategorija", "Kategorija")})});
this.oleDbDataAdapter2.UpdateCommand = this.oleDbUpdateCommand2;
//
// Forma1
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(744, 364);
this.Controls.Add(this.groupBox4);
this.Controls.Add(this.textBox1);
this.Controls.Add(this.groupBox3);
this.Controls.Add(this.groupBox2);
this.Controls.Add(this.statusBar1);
this.Controls.Add(this.groupBox1);
this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
this.MaximizeBox = false;
this.Menu = this.mainMenu1;
this.Name = "Forma1";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "CD Katalog";
this.Closing += new System.ComponentModel.CancelEventHandler(this.Forma1_Closing);
this.Load += new System.EventHandler(this.Forma1_Load);
this.groupBox1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
this.groupBox2.ResumeLayout(false);
this.groupBox3.ResumeLayout(false);
this.groupBox4.ResumeLayout(false);
this.ResumeLayout(false);
}
#endregion
/// <summary>
/// The main entry point for the application.
/// </summary>
[STAThread]
static void Main()
{
//ucitavanje frm = new ucitavanje();
Application.Run(new Forma1());
}
private void menuItem10_Click(object sender, System.EventArgs e)
{
oMeni prvaForma=new oMeni();
prvaForma.Show();
}
private void button3_Click(object sender, System.EventArgs e)
{
string temp=textBox1.Text.Trim();
if(temp=="")
{
MessageBox.Show("Morate uneti ime diska","Obaveštenje",MessageBoxButtons.OK,MessageBoxIcon.Warning);
return;
}
dataSet11.Diskovi.AddDiskoviRow(comboBox1.SelectedValue.ToString(),"",textBox2.Text);
textBox2.Clear();
}
private void Forma1_Closing(object sender, System.ComponentModel.CancelEventArgs e)
{
if (MessageBox.Show("Da li ste sigurni da želite da napustite program?",
"Potvrda izlaza",MessageBoxButtons.YesNo,MessageBoxIcon.Warning)==DialogResult.No)
e.Cancel=true;
}
private void Forma1_Load(object sender, System.EventArgs e)
{
try
{
oleDbDataAdapter1.Fill(dataSet11);
}
catch
{
MessageBox.Show("Nemogu da nadem bazu podataka!","Greška",MessageBoxButtons.OK,MessageBoxIcon.Error);
Application.Exit();
}
try
{
oleDbDataAdapter2.Fill(dataSet11);
}
catch
{
MessageBox.Show("Nemogu da nadem bazu podataka!","Greška",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
}
private void button2_Click(object sender, System.EventArgs e)
{
drugovi drugaForma=new drugovi();
drugaForma.Show();
}
private void osveziBbutton_Click(object sender, System.EventArgs e)
{
oleDbDataAdapter1.Update(dataSet11);
}
private void button4_Click(object sender, System.EventArgs e)
{
oleDbDataAdapter1.Update(dataSet11);
}
private void menuItem3_Click_1(object sender, System.EventArgs e)
{
this.Close();
}
private void textBox3_TextChanged(object sender, System.EventArgs e)
{
try
{
oleDbDataAdapter1.SelectCommand.CommandText="SELECT * FROM Diskovi WHERE ([Naslov diska] LIKE '"+textBox3.Text+"*')";
//MessageBox.Show("SELECT [Naslov diska]* FROM Diskovi WHERE (Diskovi.Naslov diska LIKE '"+textBox3.Text+"*')");
dataSet11.Clear();
oleDbDataAdapter1.Fill( dataSet11);
//oleDbDataAdapter1.SelectCommand.CommandText="SELECT * FROM Diskovi WHERE Naslov diska LIKE '"+textBox1.Text+"*'";
//oleDbDataAdapter1.SelectCommand.CommandText="SELECT * FROM Diskovi WHERE ([Naslov diska] LIKE '"+textBox3.Text+"*')";
//dataSet11.Clear();
//oleDbDataAdapter1.Fill( dataSet11);
// sledecu liniju ne ubacuješ ako ti je grid staticki vezan za dataSet
//dataGrid1.DataSource=dataSet11;
//ova linije ja ono što tebi fali
//dataGrid1.SetDataBinding(dataSet11, "Diskovi");
}
catch
{
MessageBox.Show("Greska","Greska",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
}
private void checkBox1_CheckStateChanged(object sender, System.EventArgs e)
{
if (checkBox1.Checked==true)
{
this.textBox2.Enabled=true;
this.button3.Enabled=true;
this.button4.Enabled=true;
this.comboBox1.Enabled=true;
}
else
{
this.textBox2.Enabled=false;
this.button3.Enabled=false;
this.button4.Enabled=false;
this.comboBox1.Enabled=false;
}
}
}
}
e, pa ovo je sve, ako nekom nesto jos treba da provali sta je, neka kaze sta jos da okacim na forum.Hvala [ ZokiR @ 20.05.2004. 15:41 ] @
Dobro, i šta se desi kada staviš % umesto *? Znači, ovako: Code:
oleDbDataAdapter1.SelectCommand.CommandText="SELECT * FROM Diskovi WHERE ([Naslov diska] LIKE '"+textBox3.Text+"%')";
Ako javlja neku grešku, kaži koju.
Inače, nije dobra ideja da se podaci ponovo čitaju iz baze svaki put kada korisnik pritine taster. Pošto već imaš učitane sve podatke u DataSet, koristi DataView da prikažeš podskup podataka koji zadovoljavaju kriterijume, kao što je Mrav napisao gore. [ jejen83 @ 21.05.2004. 13:38 ] @
Uf, care bas ti hvala radi.E, imam jos jedno pitanjce.Imam jednu bazu gde mi se nalaze informacije o drugovima.imam i jedan button i kad kliknem na njega dobijam novu formu gde treba da unesem podatke o njima.kad kliknem dodaj treba da ih unese u bazu.E,sad kako da mi u toj novootvorenoj formi budu dostupni datasetovi koji se nalaze u formi gde i baza. Ja stavim svojstvo da je public, ali opet nemogu da pristupim iz novootvorene forme. HVALA VAM PUNO SVIMA ZA POMOC OKO PRETRAZIVANJA BAZE.
[ degojs @ 21.05.2004. 19:24 ] @
Ako ćeš da ideš pomoću public, potrebno je da drugoj formi proslediš referencu na prvu. Dakle, negde u prvoj formi ti imaš:
Code:
public class Forma1 : System.Windows.Forms.Form
{
public DataSet ds; // ovom DataSet-u ćemo pristupati iz druge forme
...
...
Forma2 druga = new Forma2();
druga.ShowDialog();
...
}
E sad, ono new Forma2() možeš da izmeniš u new Forma2(this) čime prosleđuješ referencu na prvu formu (this). Potrebno je i da izmeniš formu 2:
Code:
public class Forma2 : System.Windows.Forms.Form
{
private Forma1 prva; // polje koje će čuvati referencu na prvu formu
// novi konstruktor
public Forma2( Forma1 f1 )
{
prva = f1;
}
....
}
I sad lepo u drugoj možeš da koristiš nešto tipa:
prva.ds....
Naravno, možeš da proslediš i referencu na DataSet umesto na čitavu formu, možeš da koristiš i Properties... ima više načina. [ jejen83 @ 23.05.2004. 09:56 ] @
Hvala puno, proradilo je.Imao sam manjih problema oko onoga sa pretrazivanjem baze iz textboxa,ali resio sam i to.Morao sam ponovo da je fillujem, a i drigi dataadapter je gubio sve iz baze, ali resio sam to nekako.U svakom slucaju hvala vam svima na pomoci!Pozdrav Bojan.
[ jejen83 @ 24.05.2004. 17:59 ] @
E, narode jel zna neko kako da sortiram bazu.Kad god startujem program on mi sortira na jedan nacin, a kako da ako pritisnem dugme koje bi sluzilo samo za to on sortira naprimer po rednom broju, a ne po diskovima? Znam da sam dosadan, ali kroz ovo ucim!
[ degojs @ 24.05.2004. 18:07 ] @
SELECT .. FROM .. ORDER BY polje [, polje2, .. ]
[ jejen83 @ 24.05.2004. 19:51 ] @
Jel mozes da budes malo precizniji molim te, nesnalazim se bas najbolje. Ocu da kad mi se ucitava baza ujedno i sortira.Znaci meni ide ovako:
Code:
private void Forma1_Load(object sender, System.EventArgs e)
{
//Pri startovanju forme fill-uejm dataGrid
try
{
oleDbDataAdapter1.Fill(dataSet11);
oleDbDataAdapter2.Fill(dataSet11);
e, ja sam mislio da treba posle fillovanja da ide nesto tipa dataset11.select from ....
[ Ovu poruku je menjao jejen83 dana 24.05.2004. u 22:40 GMT] [ jejen83 @ 24.05.2004. 20:38 ] @
E, pazi nesto sam ceprko, mislim da bi trebalo ovako, ali kad probam nista se nedesava.Evo kako sam ja to odradio:
Code:
oleDbDataAdapter1.SelectCommand.CommandText="SELECT Diskovi.[Redni broj], Diskovi.[Naslov diska], Diskovi.Kategorija, Diskovi.Nadimak FROM Diskovi ORDER BY Diskovi.[Redni broj]";
Valjda bi trebalo tako, ali nece.Sto jedan moj drug kaze: "Dobrodosao u svet Microsofta" [ degojs @ 24.05.2004. 21:08 ] @
Trebalo bi da radi tako, kod mene nikad ne pravi probleme ako se koristi ORDER BY. Ako baš neće pogledaj TOP temu ovde na .NET forumu, onu vezanu za ADO.NET i DataSet, poslednja stvar objašnjena jeste 2.7. - Sortiranje i filtriranje, možeš i tako da sortiraš već postojeći DataSet. Takođe možeš da napraviš i upit (query) u samom Access-u koji bi davao potrebne podatke već sortirane pa bi onda imao samo SELECT * FROM Query1;
Naravno postavljanje SELECT .. FROM .. ORDER BY.. se radi pre pozivanja Fill metode DataAdapter objekta.
[ jejen83 @ 24.05.2004. 23:26 ] @
Super, proradilo je.Trebao sam samo da ok za sortiranje stavim ispred fillovanja.E, to je glupo, kako da sortiram nesto sto jos nemam, jel tako, pa nisam fillovo dataset.Ali dobro,vazno je da radi. E,sad imam jos jedno pitanjce.Imam jednu dormu u kojoj je data grid.Imam jedno dugme na njoj i kad ga pritisnom treba da mi otvori novu formu.U novoj formi imam textBox.E, kad ga popunim i kliknem na dugme koje se nalazi na novoj formi da mi on to iz textBoxa upise u odredjenu kolonu.Ja sam mislio da to ide ovako, ali nikako nemogu da uradim.Ako ima neko neku predstavu kako bi to islo, please help! Evo koda:
Code:
// Za textBox 1
string temp1=textBox1.Text.Trim();
if(temp1=="")
{
MessageBox.Show("Morate uneti ime","Obaveštenje",MessageBoxButtons.OK,MessageBoxIcon.Warning);
return;
}
dataSet31.Drugari.AddDrugariRow("",textBox1.Text);
textBox1.Clear();
[ degojs @ 24.05.2004. 23:40 ] @
E drugari, bez ljutnje, a kako bi bilo da malo pročitaš neko uputstvo iz Help-a (ili čak TOP ovde na .NET forumu temu koju sam već pomenuo) pošto ovako već prelazi u to da mi programiramo za tebe, što i nije baš namena ovog foruma.
[ jejen83 @ 25.05.2004. 08:52 ] @
Upravu si degojs, moje izkreno izvinjenje.Necu vise dosadjivati.Hvala vam i za ovo dosad.Pozdrav
[ esnaf @ 27.05.2004. 17:47 ] @
Evo ti nacin da filtriras vise tabela jednom procedurom.
[code]private void trazi_Click(object sender, System.EventArgs e)
{
if(text.Text!="")
{
DataView dw=new DataView(novi.Ds.Tables[0]);
if(novi.Ds.Tables[0]==novi.Ds.Tables["Artikal"])
{
dw.RowFilter="sifa="+text.Text+"";
prikaz.DataSource=dw;
}
else if(novi.Ds.Tables[0]==novi.Ds.Tables["Kupac"])
{
dw.RowFilter="sifk="+text.Text+"";
prikaz.DataSource=dw;
}
else if(novi.Ds.Tables[0]==novi.Ds.Tables["Racun"])
{
dw.RowFilter="sifr="+text.Text+"";
prikaz.DataSource=dw;
}
else if(novi.Ds.Tables[0]==novi.Ds.Tables["Nabavljaci"])
{
dw.RowFilter="id_d="+text.Text+"";
prikaz.DataSource=dw;
}
}
Copyright (C) 2001-2024 by www.elitesecurity.org. All rights reserved.
|