imam bazu u kojoj zelim da radim filtriranje ali da mi radi zajedno, medjutim ja sam napravio da radi odvojeno, ali kako to sad ukombinovati da radi zajedno?
REcimo kada ukucam korisnika i dogadjaj i raspon datuma da mi nadje za to, a ne kao sad, da mi radi posebno sve?
Evo koda cele forme
Code:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
namespace zadatak2
{
public partial class Izvestaj : Form
{
private OleDbConnection connection = new OleDbConnection();
private BindingSource bs;
public Izvestaj()
{
InitializeComponent();
}
OleDbDataAdapter sda;
DataTable dt;
private void Izvestaj_Load(object sender, EventArgs e)
{
connection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Tomy\Desktop\zadatak2\zadatak2\fedek_OldVersion(2002-2003).mdb;User Id=admin;Password=;";
dt = new DataTable();
sda = new OleDbDataAdapter("SELECT * FROM (SELECT korisnici.korisnik,dogadjaji.dogadjaj,Tomislav.Datum FROM dogadjaji INNER JOIN (korisnici INNER JOIN Tomislav ON korisnici.ID = Tomislav.korisnik_ID) ON dogadjaji.ID = Tomislav.dogadjaj_ID) WHERE korisnik like '%" + textBox1.Text + "%' AND dogadjaj like '%" + textBox3.Text + "%'", connection);
sda.Fill(dt);
dataGridView1.DataSource = dt;
dataGridView1.Columns[0].Width = 120;
dataGridView1.Columns[1].Width = 150;
dataGridView1.Columns[2].Width = 150;
bs = new BindingSource(dt,null);
}
private void button1_Click(object sender, EventArgs e)
{
if(dateTimePicker1.Value>dateTimePicker2.Value)
{
MessageBox.Show("Takav opseg nije moguc. Datum Od mora biti veci od datuma Do.", "Opseg datuma", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else{
string query = "select korisnici.korisnik, dogadjaji.dogadjaj, Datum from korisnici, dogadjaji, Tomislav where Datum BETWEEN ? AND ?";
OleDbCommand cmd = new OleDbCommand(query, connection);
cmd.Parameters.AddWithValue("SDate", DbType.DateTime).Value = dateTimePicker1.Value;
cmd.Parameters.AddWithValue("EDate", DbType.DateTime).Value = dateTimePicker2.Value;
DataSet ds = new DataSet();
sda= new OleDbDataAdapter();
connection.Open();
sda.SelectCommand = cmd;
sda.Fill(ds, "Tomislav");
dataGridView1.DataSource = ds.Tables[0];
connection.Close();
}
}
private void unosUBazuToolStripMenuItem_Click(object sender, EventArgs e)
{
this.Hide();
Form1 baza = new Form1();
baza.ShowDialog();
}
private void exitToolStripMenuItem1_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Da li ste sigurni?", "Exit", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
Application.Exit();
}
}
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
namespace zadatak2
{
public partial class Izvestaj : Form
{
private OleDbConnection connection = new OleDbConnection();
private BindingSource bs;
public Izvestaj()
{
InitializeComponent();
}
OleDbDataAdapter sda;
DataTable dt;
private void Izvestaj_Load(object sender, EventArgs e)
{
connection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Tomy\Desktop\zadatak2\zadatak2\fedek_OldVersion(2002-2003).mdb;User Id=admin;Password=;";
dt = new DataTable();
sda = new OleDbDataAdapter("SELECT * FROM (SELECT korisnici.korisnik,dogadjaji.dogadjaj,Tomislav.Datum FROM dogadjaji INNER JOIN (korisnici INNER JOIN Tomislav ON korisnici.ID = Tomislav.korisnik_ID) ON dogadjaji.ID = Tomislav.dogadjaj_ID) WHERE korisnik like '%" + textBox1.Text + "%' AND dogadjaj like '%" + textBox3.Text + "%'", connection);
sda.Fill(dt);
dataGridView1.DataSource = dt;
dataGridView1.Columns[0].Width = 120;
dataGridView1.Columns[1].Width = 150;
dataGridView1.Columns[2].Width = 150;
bs = new BindingSource(dt,null);
}
private void button1_Click(object sender, EventArgs e)
{
if(dateTimePicker1.Value>dateTimePicker2.Value)
{
MessageBox.Show("Takav opseg nije moguc. Datum Od mora biti veci od datuma Do.", "Opseg datuma", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else{
string query = "select korisnici.korisnik, dogadjaji.dogadjaj, Datum from korisnici, dogadjaji, Tomislav where Datum BETWEEN ? AND ?";
OleDbCommand cmd = new OleDbCommand(query, connection);
cmd.Parameters.AddWithValue("SDate", DbType.DateTime).Value = dateTimePicker1.Value;
cmd.Parameters.AddWithValue("EDate", DbType.DateTime).Value = dateTimePicker2.Value;
DataSet ds = new DataSet();
sda= new OleDbDataAdapter();
connection.Open();
sda.SelectCommand = cmd;
sda.Fill(ds, "Tomislav");
dataGridView1.DataSource = ds.Tables[0];
connection.Close();
}
}
private void unosUBazuToolStripMenuItem_Click(object sender, EventArgs e)
{
this.Hide();
Form1 baza = new Form1();
baza.ShowDialog();
}
private void exitToolStripMenuItem1_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Da li ste sigurni?", "Exit", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
Application.Exit();
}
}
}
}