You must Sign In to post a response.
  • Category: ASP.NET

    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.
  • #769377
    Hi,

    In Web.Config is used for database connection declaration for entire solution project.
    using System.Data.SQLClient is used for that access SQL in that page.
    you can write Seperate class file to write connection instead of web.config file.

    hope this will help

    Regards
    Sriram.R


  • Sign In to post your comments