Exemple #1
0
        public DataTable TimKiemTheoTen(string input)
        {
            DataTable dt     = sinhVienDAO.Search().Copy();
            DataTable ketqua = new DataTable();

            ketqua.Columns.Add("MaSV");
            ketqua.Columns.Add("HoTen");
            ketqua.Columns.Add("NgaySinh");
            ketqua.Columns.Add("GioiTinh");
            ketqua.Columns.Add("Sdt");
            ketqua.Columns.Add("MaLop");

            for (int r = 0; r < dt.Rows.Count; r++)
            {
                string hoten = dt.Rows[r]["HoTen"].ToString();
                if (hoten.ToLower().Contains(input.ToLower()))
                {
                    DataRow row    = dt.Rows[r];
                    DataRow newrow = ketqua.NewRow();
                    for (int i = 0; i < ketqua.Columns.Count; i++)
                    {
                        newrow[i] = row[i];
                    }
                    ketqua.Rows.Add(newrow);
                }
            }

            return(ketqua);
        }