Problem in filtering the data table by filter string

give me some more information about your query and code

I having a data table with the column "Row No" and "Resource Name".

I like to bind this data table inside the grid order by Row No. 

I am also implementing some filtering concept in the data table.

I used to filter the records based on the Resource Name starting with the character A and order those records by their corresponding Row No.

I need a query string to achieve this logic.

This is the one what i expect is.

If my explanation is not clear means, please let me know.

Thanks.

I got the solution for this please find my code below.

string Filter = BuildFilterStringBasedCheckBoxCheck();==> Here I got the filter expression .

               if (Filter != string.Empty)

               {

                   //Filter = Filter + " ORDER BY UnitNumberInteger";(when i add this line i got the error i mentioned above. Now i remove thisa line)

               }

               DataTable dtFilter = new DataTable();

               DataTable dtMonthlyInvoiceResidentDetailss = new DataTable();

               DataRow[] drs = null;

               DataRow dr;

               dtFilter.Columns.Add("ConfidentLevel");

               dtFilter.Columns.Add("ResidentInvoiceStatus");

               dtFilter.Columns.Add("UnitNumberInteger");

               dtMonthlyInvoiceResidentDetailss = GetReviewResidentDetails();

               dtFilter = dtMonthlyInvoiceResidentDetailss.Clone();

               drs = dtMonthlyInvoiceResidentDetailss.Select(Filter, "UnitNumberInteger"); --> this is the correct one in order to order a records based on UnitNumberInteger in filter concept in data table.

               foreach (DataRow dr_loopVariable in drs)

               {

                   dr = dr_loopVariable;

                   dtFilter.ImportRow(dr);

               }