asp.net and remote sql server database

How do I add a sql server remote database connection to some asp.net code on my computer?
michaeldean99Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

quizwedgeCommented:
Are you looking to view the remote database in Visual Studio? If so, check out http://weblogs.asp.net/nannettethacker/creating-a-database-connection-to-a-remote-sql-server-database-within-visual-web-developer

If you're looking to add a connection string to your code so that your code can access the remote server, check out http://msdn.microsoft.com/en-us/library/jj653752(v=vs.110).aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ramkisan JagtapLead DeveloperCommented:
Modify your connection string as below :

<connectionStrings>                                
  <add name="DefaultConnection" providerName="System.Data.SqlClient"
       connectionString="ServerName ,port;Integrated Security=False;User ID=XXXX;Password=XXXX" />
</connectionStrings>
0
VijayBalkawadeCommented:
It is same as you do for your local database. You have to provide remote SQL server instance name in connectionstring.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

LordWabbitCommented:
You could also add a linked server.
0
Mandeep SinghDatabase AdministratorCommented:
HI,

if sql server box is located on a remote area, then you have to open Port between two machines on which sql server is running.

also make a connection like this.

<?xml version="1.0"?>
<configuration>

    <system.web>
      <compilation debug="true" targetFramework="4.5" />
      <httpRuntime targetFramework="4.5" />
    </system.web>
  <connectionStrings>
    <add name="con" connectionString="Data Source=.;User ID=abc;Password=abc@123;Initial Catalog=AdventureWorks2008R2"/>
  </connectionStrings>

</configuration>
0
michaeldean99Author Commented:
hi
Using ms visual studio express 2013 for Web.
Have added the remote sql sever definition using the server explorer.
I assume that I have to add sql queries to the sql server object explorer?

Sample page
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <title>xxxxxx</title>  etc.

</head>
<body>
    <table style="width:100%" align="center">.....
     
How do I add the query results to the code?

thanks
0
quizwedgeCommented:
Saw that no one has responded yet. There are a bunch of different ways to add database query results to the code.

Some people prefer LINQ (https://code.msdn.microsoft.com/LINQ-Sample-Queries-13a42a54)

You can also use data layers. See the YouTube video at https://www.youtube.com/watch?v=JOJV-Z7cmkc starting at around 19:44

Yet another way is using OleDbDataAdapter (https://support.microsoft.com/kb/821765?wa=wsignin1.0)

I'd look over those three and choose the one that seems easiest and best for your project.
0
michaeldean99Author Commented:
thanks
Linq seems to be the obvious
0
LordWabbitCommented:
Well LINQ to SQL is a bit outdated (would still work though) the Entity Framework has replaced it.
0
michaeldean99Author Commented:
thanks LordWabbit
Entity Framework looks interesting
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.