Malo je los al radi. Znaci ide ovako
Code:
DataTable AAADataTable = new DataTable();
private void populate_datagrid()
{
// Inicijaliziraj Lokacije2.mdb Pass: afmlb
string connection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= Lokacije2.mdb;Jet OLEDB:Database Password=AAA";
OleDbConnection AAAConnection = new OleDbConnection();
AAAConnection.ConnectionString = connection;
AAAConnection.Open();
OleDbDataAdapter AAADataAdapter = new OleDbDataAdapter("Select Lokacija from lok", AAAConnection);
OleDbCommandBuilder AAACommandBuilder = new OleDbCommandBuilder(AAADataAdapter);
// Populate DataGrid
AAADataAdapter.Fill(AAADataTable);
AAADataGrid.DataSource = AAADataTable;
AAAConnection.Close();
}
private void search_datagrid(string search)
{
DataView dv = new DataView(AAADataTable);
dv.RowFilter="Lokacija like '%"+search+"%'";
AAADataGrid.DataSource=dv;
}
private void btn_LokacijaSearch_Click(object sender, System.EventArgs e)
{
search_datagrid(txtAAASearch.Text);
}
private void txtAAASearch_TextChanged(object sender, System.EventArgs e)
{
search_datagrid(txtAAASearch.Text);
}
DataTable AAADataTable = new DataTable();
private void populate_datagrid()
{
// Inicijaliziraj Lokacije2.mdb Pass: afmlb
string connection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= Lokacije2.mdb;Jet OLEDB:Database Password=AAA";
OleDbConnection AAAConnection = new OleDbConnection();
AAAConnection.ConnectionString = connection;
AAAConnection.Open();
OleDbDataAdapter AAADataAdapter = new OleDbDataAdapter("Select Lokacija from lok", AAAConnection);
OleDbCommandBuilder AAACommandBuilder = new OleDbCommandBuilder(AAADataAdapter);
// Populate DataGrid
AAADataAdapter.Fill(AAADataTable);
AAADataGrid.DataSource = AAADataTable;
AAAConnection.Close();
}
private void search_datagrid(string search)
{
DataView dv = new DataView(AAADataTable);
dv.RowFilter="Lokacija like '%"+search+"%'";
AAADataGrid.DataSource=dv;
}
private void btn_LokacijaSearch_Click(object sender, System.EventArgs e)
{
search_datagrid(txtAAASearch.Text);
}
private void txtAAASearch_TextChanged(object sender, System.EventArgs e)
{
search_datagrid(txtAAASearch.Text);
}
E sad stvar je u tom. Da to serch-a u redu. Al pri svakom Searchu se digne iskoristenost RAM-a za pola megabajta al ga nista ne pocisti kada je OLD. Znaci zauzme na pocetku 18Mb. Onda serchas 5 puta i ode on preko 20Mb. i tako prema gore.
Znaci s kojom bi komandom nakon sto se odradi search moze napravit neki RAM UNUSED CLEANup za taj DataTable i DataView ili sta vec.
[Ovu poruku je menjao xxxrugby dana 15.11.2006. u 12:29 GMT+1]
xxxrugby: "We are all philosophers, when question is about politics!"