A website which is hosted on local but database on remote how i can access The database

for your reference..

ASP.NET as such does not differentiate local and remote database servers. The things you might want to take care though are

1. Have the connection string point to the database serverusing its IP address and port

2. You also need a user name and password to access the database since the Integrated Security cannot be used. You can use integrated security if both the web server and database server are running under a single network domain trust.

3. Ensure that the port used to access the database is opened for Outbound traffic in your web server's firewall

The real thing you have to pay attention on it is the SERVER NAME / IP ADDRESS : PORT of the server - so, your Web.config connection string should look like the following:

<connectionStrings>
  <add name="MyConnectionString" connectionString="Data Source=SERVER-IP:PORT;Database=DBName;User Name=<user>;Password=<pass>" providerName="System.Data.SqlClient" />
</connectionStrings>

more on connection strings is here http://www.connectionstrings.com/[^]

firstly you need to grant permission on sql database to access it to remote and the website webconfig used to ConnectionString with datasource="ip address of remote system/server name">

You can connect the DATABASE by connectionstring.

<connectionStrings>
<add name="ConnectionName" connectionString="Data Source=RemoteServerName;Initial Catalog=DBNAME; Integrated Security=True;/>
</connectionStrings>

Write the Code in Web.config