c# DataGrid Item Get Values

c# DataGrid Item Get Values 20.11.2006. u 11:10 · pre 242 meseca #1

Imam ovako podeseno DataTable i DataGrid

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();
        }

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;
        }

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();

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

Potpis

xxxrugby: "We are all philosophers, when question is about politics!"

Re: c# DataGrid Item Get Values 28.11.2006. u 11:04 · pre 242 meseca #2

ima'l tko kakav hint.

Potpis

xxxrugby: "We are all philosophers, when question is about politics!"

Re: c# DataGrid Item Get Values 28.11.2006. u 11:51 · pre 242 meseca #3

Dont miks grandmoders and frogs

Prijatelju, ti radis sa DataGridom preko DataView-a, ostavi dataTable na miru (dv.Table.Rows ....) !

Znaci :

Code:

string s = dv[DGDataGrid.CurrentCell.RowNumber].Row["Lokacija"];

Potpis

America national sport is called baseballs. It very similar to our sport, shurik, where we take dogs, shoot them in a field and then have a party.

Re: c# DataGrid Item Get Values 28.11.2006. u 14:43 · pre 242 meseca #4

Hvala puno. Ubilo me to vec tjedan dana nisam otkrio kako.

E da sam se ucim C#. pa ono mi ide malo sporije. he hehe.

Potpis

xxxrugby: "We are all philosophers, when question is about politics!"

Forum kao aplikacija na telefonu

Srodne teme