Where to set provider name in web.config or page itself

If i set provider in sql connection string in web.config file then should i also write
using System.Providername in page level coding.

Can i code without using statement i.e. using provider name from sql conn string in web.config?

Please explain.