How to host web application in client site with SQL server DB

There is no need to give the database to client. You can host your database on the server and client application will directly access the database through the specified connections string.
But if you want to use client side database you can use SQL lite database which don't need to be installed on client which is running your application.