Using BCS i want records from SQL Server (ex-Employee) and after that in a page i need to use a Webpart where a user can search a record .

(employee detail only from external DB) Can anybody suggest how to do or the procedure to achieve this ?