Getting my Web Form on the Internet

Hi all.

I really apologise if these are really stupid questions but I just don't get how
this works having never done it before.

I have built a web form that interacts with SQL Server that runs on my home
computer to submit data. I just want to get this simple form on the internet but
have no idea how to go about it. Can someone please give me a idea where to
start. Do I need to buy webspace? If so how does publishing my web site on the
webspace server let it submit data to my SQL Server on my computer? Or do I have
to turn my computer in to a Web Server? If so how would I do that?

If anyone can just post a couple of relevent websites or papers that would be
great, I don't mind doing my own research. I'm comfortable with the coding and
getting it to run on IIS but it's deploying it to the internet where I become
clueless.

Thanks for any help you can give.

Rob

Yes you'll need to get hold of some web space, some are free, but I prefer to
buy mine.

You'll also need to check with the ISP is they support the version of SQL Server
you are running, or if it is SQL Express then if they support that.  SQL Express
might be a little easier as your configuration will remain the same on the
remote server.  However your connection string to SQL Server will be different
depending upon your ISP.

As to links check the front page of http://asp.net or the forums section for
possible options

Hope this helps?

Many thanks for that very quick response. I'll mark it as answered.

Can you just clarify the point on the connection string? Will my tables and
stored procedures be transfered to the ISPs SQL Server or will the connection
string route the query through the ISP and then to my SQL Server? It's SQL
Server 2005.

I've been using SQL Server and VB for 4 years but only been on .NET for about 3
months and ASP is just totally alien which will explain my questions.

Thanks again.

Yes you are right, your tables and stored procedures will be transfered to the
hosting providers SQL Server and you will need to update your web.config file
with the new credentials. You will get your database name, username, password,
and I.P while creating the database through your hosting providers control
panel. You will only be able to connect to a SQL server which is hosted on a
static ip, and that is the reason why you will not be able to access your local
system SQL Server as the IP your system uses while connecting to the net is
Dynamic. By dynamic ip it means that your ip changes every time you connect to
the net.

Hi,

I have a doubt. If we are uploading our web project to the server wont our
web.config file conflicts with the one that already exists in the server...

 

Thanks in advance 

Regards,

Rev..