filter for grid

[Hrvoje]

I'm using this code to filter data...
In comment area I would like to fill grid with filtered data. How?

string sFilter ="";
DataRow[] afrows = db.dataSetKolekcija.Akcioni.Select("Naziv LIKE '" + filter + "%'" );

if (afrows.Length != 0)
{
foreach (DataSetKolekcija.AkcioniRow arow in
afrows)
{
sFilter += arow;
// Here I would like to filter and fill grid...
}
}

[Administrator]

What grid do you want to use?

GridControl, GridDataBoundGrid, or GridGroupingControl?

Here is some code for a GridGroupingControl.

            DataRow[] drs = dt.Select("[Col1] = 5");


            DataTable newtable = new DataTable();
            int c = 0;
            foreach (object o in drs[0].ItemArray)
            {
                newtable.Columns.Add(new DataColumn(string.Format("col{0}", c++), o.GetType()));
            }
            foreach(DataRow dr in drs)
            {
                newtable.Rows.Add(dr.ItemArray);
            }
            this.gridGroupingControl1.DataSource = newtable;

[Hrvoje Voda]

This code is not good for me.
I'm using GridDataBoundGrid.

[Administrator]

In the code above, changing

   this.gridGroupingControl1.DataSource = newtable;

to

   this.gridDataboundGrid1.DataSource = newtable;

should put the rows into a GridDataBoundGrid.

[Hrvoje Voda]

I'm using it like that, but I get a grid with one empty row. No results.

[Administrator]

Here is a sample showing transferring a DataRow[] into a DataTable and setting it as the DataSource of a GridDataBoundGrid. What are you doing differently?

WindowsApplication1450.zip