using (SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=123;database=test"))

            {

                using (SqlDataAdapter adp = new SqlDataAdapter("select * from AA_Car", con))

                {

                    DataTable dt = new DataTable();

                    adp.Fill(dt);

                    DataRow[] drs = dt.Select(" id in (2,3)");

                    DataTable dtNew = dt.Clone();//drs中的一个datarow克隆也可以

                    foreach (DataRow dr in drs)

                    {

                        dtNew.ImportRow(dr);

                    }

                }

            }

     DataTable dt = new DataTable();

            dt.Columns.Add("Code");

            dt.Columns.Add("Name");

            dt.Columns.Add("Driver");

            dt.Rows.Add(new object[] {"","a","张" });

            dt.Rows.Add(new object[] { "", "a", "王" });

            dt.Rows.Add(new object[] { "", "a", "李" });

            Car car = new Car();

            Type info = typeof(Car);

            foreach (var m in info.GetMembers())

            {

                if (m.MemberType == MemberTypes.Property)

                {

                    var p = info.GetProperty(m.Name);

                    p.SetValue(car, Convert.ChangeType(dt.Rows[][m.Name], p.PropertyType), null);

                }

            }