Is There Common Way To Search And Filter At Sqlcecommand

Hi.

I think that it's possible only when CommandType is set to TableDirect.

But I need subj for this:






cc.CommandText = "SELECT FAM+' '+IMA+' '+OTC AS FIO FROM LICO AS LIC";

rs = cc.ExecuteResultSet(ResultSetOptions.Scrollable);

DataGridTableStyle ts = new DataGridTableStyle();

ts.MappingName = "";

DataGridColumnStyle cs = new DataGridTextBoxColumn();

cs.MappingName = "FIO";

cs.Width = 400;

ts.GridColumnStyles.Add(cs);

dataGrid1.TableStyles.Add(ts);

rsv = rs.ResultSetView;

dataGrid1.DataSource = rsv;