Database Connectivity in .NET Framework

Database Connectivity

So basically, what is database connectivity?

In the most simple and easy words I can say that database connectivity is nothing but an interface, bridge or a communication medium between your database and your web through which you can manage various applications or functionalities of your web.

Functionalities | Connectivity

The major functionalities of database connectivity are:

  • Helps in Session mechanism
  • Helps in solving puzzles of user registration pages
  • In database binding
  • Accessing files/data/information that is already stored in database
  • Basic operation of SQL

Coding | Web Configuration

For creating database connectivity (I am giving you guidelines on the basis of the tools in Visual Studio):

  • Open Visual Studio
  • Access your desired website
  • Access the main page of your website; the main page will be like this:



  • Now click on Solution Explorer at the very right corner; a box like this will be opened:



  • Now click on web.config link
  • A web.config page will be opened
  • Create a connection string in this page


[connection string]



The following shows how to establish a connection string.

Web configuration Page

(Code like this)

<?xml version="1.0"?>
   <!--
      For more information on how to configure your ASP.NET application, please visit http://go.microsoft.com/fwlink/?LinkId=169433
   -->
<configuration>
   <connectionStrings>
      <
add name="ABC" connectionString="Data Source=ABHI-PC; Initial Catalog=Reg; Integrated Security=true"/>
   </
connectionStrings>
   <system.web>
      <
compilation debug="false" targetFramework="4.0" />
   </
system.web>
</
configuration>