An ASP.NET NOOB

[Raziiq]

Hi People.
Uptil now i have only made the ASP.Net applications on the LAN. But now i want to make an ASP.NET website and upload that website. The Purpose of that website is to keep track of all the sales and purchase of our company. The ASP.net pages should be able to get and send the data from SQL SERVER or any other database on the Website.

Can anybody help me how to use it?
What things should i need?
Which Web hosting should i use?

Please help me and give me a step by step description.

[Raziiq]

Can anybody help?

[Raziiq]

This is really Amazing , nobody wants to help me. I think my question is not that difficult.

[mendhak]

You need a web host with asp.net and sql server. Create it as you would in a normal development environment, with the exception of your connection string being customizable (in a web.config file)

You'd only need to upload the files after you're done.

[Raziiq]

At last a reply. Thanks for the reply. Can you please suggest any web hosting service.

[mendhak]

I use www.jodohost.com

But it depends, what are you looking for?

[Raziiq]

Thanks for that web hosting suggestion. I have registered for a trail on this website and will get a reponse from them in a couple of days. Thanks again for the Suggestion.
You have told in your post that i have to change the Connection String in Web config File. Can you please tell me what i have to change and where is that Web Config File.
Also can you please tell me about some ASP.net Tutorials on web because it had been a long time since i had worked in ASP.net so i think i need a bit revision before proceeding Further.
Thanks in Advance.
Waiting for your reply Anxiously.

[mendhak]

This is what I meant by the config file:

http://aspnet.4guysfromrolla.com/articles/053102-1.aspx

[dogboydelta]

Here's a snippet of code for making a SQL connection, you will use this (or some form of it) many times.

Dim SQLConn as New SQLConnection("server=X;database=xdb;user=xu;password=pw)
Dim SQLCom as New SQLCommand("SELECT name FROM table WHERE id=1", SQLConn)
Dim user as String

cn.Open()
user = SQLCom.ExecuteScalar()
cn.Close()


There are many different ways to do this, plus you will have to use the SQLDataReader if you want to get more than one value, and the SQLDataAdapter if you want to do something like fill a DataGrid. This is just a (very basic) start on using the SQL APIs in Visual Basic.

[Raziiq]

THanks Dogboydelta for this Snippet Code.
Thanks Mendhak for that link. I will have a go to it soon.
Well i am wondering why i am not getting the response from the JODOHOST.COM. I have recieved one of their mail saying to wait for our Confirmation, but after that no mail.What do you people say.

[mendhak]

Ask here, the techies frequent the forums too...

http://support.jodohost.com/