If you are working on a website then there might be a chance to handle a large amount of data on a public site.

Generally, we are binding code with Gridview like this:

Gridview1.Datasource = dataset;
GridView.DataBind();

In this blog, we will see Active Directory Programming using C# code.
In other blogs, you can read ASP.Net Tutorial, .Net Core Tutorial.
We will first understand - What is Active Directory?

sp_addlinkedserver linked 2 servers. Once sp_addlinkedserver query executes, query can be run against these servers.Run below queries one by one to link, to provide login credentials and to access data
EXEC sp_addlinkedserver @server='ServerName' EXEC sp_addlinkedsrvlogin 'ServerName', 'false', NULL, 'username', 'password' select * from [ServerName].[DBName].[DBO].[TableName]
Once your requirement is done, you may drop the linking by running following query. EXEC sp_dropserver 'ServerName', 'droplogins'