Code:
DataTable DTDataTable = new DataTable();
private void populate_datagrid()
{
// Inicijaliziraj Lokacije2.mdb Pass: xxxxxx
string connection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= Lokacije2.mdb;Jet OLEDB:Database Password=xxxxxx";
OleDbConnection Connection = new OleDbConnection();
Connection.ConnectionString = connection;
Connection.Open();
OleDbDataAdapter DADataAdapter = new OleDbDataAdapter("Select * from lok", Connection);
OleDbCommandBuilder CBCommandBuilder = new OleDbCommandBuilder(DADataAdapter);
// Populate DataGrid
DADataAdapter.Fill(DTDataTable);
Connection.Close();
}
DataTable DTDataTable = new DataTable();
private void populate_datagrid()
{
// Inicijaliziraj Lokacije2.mdb Pass: xxxxxx
string connection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= Lokacije2.mdb;Jet OLEDB:Database Password=xxxxxx";
OleDbConnection Connection = new OleDbConnection();
Connection.ConnectionString = connection;
Connection.Open();
OleDbDataAdapter DADataAdapter = new OleDbDataAdapter("Select * from lok", Connection);
OleDbCommandBuilder CBCommandBuilder = new OleDbCommandBuilder(DADataAdapter);
// Populate DataGrid
DADataAdapter.Fill(DTDataTable);
Connection.Close();
}
Filtriram s
Code:
private void search_datagrid(string search)
{
DataView dv = new DataView(DTDataTable);
string btntext = this.btn_LokacijaSearch.Text ;
if (btntext == "Lokacija")
{
dv.RowFilter="Lokacija like '%"+search+"%'";
} else {
dv.RowFilter="lan like '%"+search+"%'";
}
CURHDataGrid.DataSource = dv;
}
private void search_datagrid(string search)
{
DataView dv = new DataView(DTDataTable);
string btntext = this.btn_LokacijaSearch.Text ;
if (btntext == "Lokacija")
{
dv.RowFilter="Lokacija like '%"+search+"%'";
} else {
dv.RowFilter="lan like '%"+search+"%'";
}
CURHDataGrid.DataSource = dv;
}
E sad je problem sto pri tom filteru u DataGrid ostane ono sto ja zelim. Filtriran izgled. Samo njih par.
E al kad kliknes na neki od tih filtriranih izgleda on ima krivi Index. tj. u datagrid npr. ima index 1 onaj filtriran al kad pokusam gledat s
Code:
DataView dv = (DataView) DGDataGrid.DataSource;
int dc = DGDataGrid.CurrentCell.RowNumber;
this.txtLokacija.Text = dv.Table.Rows [dc]["Lokacija"].ToString();
DataView dv = (DataView) DGDataGrid.DataSource;
int dc = DGDataGrid.CurrentCell.RowNumber;
this.txtLokacija.Text = dv.Table.Rows [dc]["Lokacija"].ToString();
On zapravo i dalje gleda DataTAble pa mi daje krivi rezultat.
Ako ima koja sintaksa da on uzima vrijednosti iz DataGrid. Neki event handler ili nesto.
Hvala
xxxrugby: "We are all philosophers, when question is about politics!"