【C#】DATATABLE查詢

    
    //initial
            DataTable dt = new DataTable();
            dt.Columns.Add("ID");
            dt.Columns.Add("DATE");

            DataRow DR1 = dt.NewRow();
            DR1["ID"] = "T01";
            DR1["DATE"] = "2013-01-01";
            DataRow DR2 = dt.NewRow();
            DR2["ID"] = "T01";
            DR2["DATE"] = "2013-01-02";

            dt.Rows.Add(DR1);
            dt.Rows.Add(DR2);

            //使用ROWS.FIND
            dt.PrimaryKey = new DataColumn[] { dt.Columns["ID"], dt.Columns["DATE"] };
            object[] findTheseVals = new object[2];
            // Set the values of the keys to find.
            findTheseVals[0] = "T01";
            findTheseVals[1] = "2013-01-01";
            var foundRow = dt.Rows.Find(findTheseVals);
            

            //使用DEFAULTVIEW.FIND
            object[] ss=new object[2];
            ss[0]="T01";
             ss[1]="2013-01-02";
             dt.DefaultView.Sort = "ID,DATE Asc";
             int index = dt.DefaultView.Find(ss);

            //使用LINQ
             var linqRow = (from dto in dt.AsEnumerable()
                            where dto.Field("STORAGE_ID").ToString() == "TO1"
                            select dto).First();