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;

At current moment i use this:

Code Snippet

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

SqlCeParameter param = new SqlCeParameter("@.FAM", SqlDbType.NVarChar, 99);

cc.Parameters.Add(param);

cc.Parameters["@.FAM"].Size = 99;

cc.Prepare();

cc.Parameters["@.FAM"].Value = "1";

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;

private void FindRec(string ss)

{

cc.Parameters["@.FAM"].Value = ss;

rs=cc.ExecuteResultSet(ResultSetOptions.Scrollable);

rsv = rs.ResultSetView;

dataGrid1.DataSource = rsv;

}

But this like "filter". What about search?