对DBGrid的数据进行排序和过滤

这个是显示数据常用的操作，按道理看看CB的帮助就很容易找到答案，可是还有很多的人利用构造新的SQL重新检索的方法实现，实在是非～常～的不理解，利用ADO控件的Sort、Filter或者ClientDataSet的index、filter可以很容易在本地实现且效率很高的处理方式为什么不留意呐。

附CB帮助的内容：

过滤的：

//State = 'CA' OR State = 'MA'

ADODataSet1->Filtered = false;
ADODataSet1->Filter = "State = " + QuotedStr("CA") + " OR " + "State = " + QuotedStr("CA");

ADODataSet1->Filtered = true;

When a filter is set, Blank records do not appear unless explicitly included in the filter. To include rows based on blank, (or "NULL") values in table columns, compare the column to NULL in the expression. For example:

ADODataSet1->Filtered = false;
ADODataSet1->Filter = "State = " + QuotedStr("CA") + " OR " + "State = NULL";

ADODataSet1->Filtered = true;

排序的
ADOQuery1->Sort = "LastName ASC, DateDue DESC"

Read Sort to determine the field (or fields) on which the recordset is sorted.