EnjoySharePoint YouTube Channel

DataAdapter in Asp.Net

In this article, we will discuss what is a DataAdapter in asp.net and how to use DataAdapter in asp.net.

Get Office 365 Enterprise E3 Or Business Premium Subscription & Try out all the features

Also, you can check out my previous posts on

Adding meta tags to aspx pages in asp.net,

Bind grid view using data reader in asp.net 

Method Overloading in C#.Net.

DataAdapter will act as a mediator between dataset and database server. This will perform 2 things:

– It will read data from database and place within dataset in the form of datatables.

– The manipulation on the dataset table will be updated with database.

string conn = “You connection string will goes here”;


SqlConnection conn = new SqlConnection(conn);

SqlDataAdapter da = new SqlDataAdapter(strSQL, conn);

DataSet ds = new DataSet();

da.Fill(ds, “Employees”);

Here Employees is the datatable name.

Check out the below diagram how it is working:

Check out Best Alternative to InfoPath -> Try Now
You May Also like the Following SharePoint Tutorials:

About Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SharePointSky.com

View all posts by Bijay Kumar →