ASP.NET Database Connection

Introduction :

Now we discuss about Asp.net Database Connection Asp.net provide several type of classes to connection from ADO.NET here we discuss some classes ...

To Access the ADO.Net you must import  Namespaces

System.Data 

System.Data this namespace hold some type of objects if you want to use this classes or method first you must import this Namespace every page in .net

• DataSet
• DataTable
• DataRow
• DataRelation

System.Data.OleDb

This namespace it’s general namespace one you import and you can easly use every database like sql.server.mysql,even you can use excel sheet it provide some usefull objects..

• OleDbConnectin
• OleDbCommand
• OleDbDataSet
• OleDbDataReader
• OleDbDataAdapter

System.Data.SQLClient

This is same OleDb but this  specially for sqlserver and it hold this type of objects

• SQLConnection
• SQLCommand
• SQLDataSet
• SQLDataReader
• SQLDataAdapter

You must Login to comment.