February 23, 2010 at 4:07 pm
Ok this is what I need. I am an out of work IS professional. Experience in SQL server, exchange,windows 2003, and linux. I used to make forms based apps before the war(2002) in vb6.
Although my skills are in sql server and its back end programming t-sql,udf's,sp's and SSIS
I keep getting recruiters asking my about my c# and asp.net skills. Well there is enough demand out there I need to get some.
So my question is: how to get from A to C. Where 'A' would be writing it in c# 2008 asp.net 3.5 .
'B' would be finding how to and populating an sql server table on a hosted web server (so I can practice
inserts updates deletes to my sql table) . 'C' would be Deployment. How do you deploy a websites, its just there right? Just buy the domain name,point it to the ip, and let people know what it is. Not like forms based where you put into an msi or other and use group policy or other mechanisms to deploy it. But what if you write it at home on xp using its IIS. How do you transfer the files and folders to the web hoster you are are using?
See once I conceptually get the picture than I can really go to work.
What I want to do is a complete cycle. Build a simple site linking to an sql server table that reads and modifies data and then deploy it.
So my questions are.
1. can I write a couple round trip events in c# asp.net, update a table in sql server, read from it,
move the files to a web hoster .
2. Anyone know an inexpensive web server hoster that use ms sql server? T
3. I noticed there are several approaches to binding to ms sql server data in my research.Can someone tell me which is considered more commonly used in the real world, ado.net, DAL, I read something about LINQ.
Once I understand the back bone and I can work on making it more robust.
February 23, 2010 at 5:11 pm
I found one that looks good. win host.com is what I am going with. 4.95 per month $10 per year for domain name
Common ASP.NET Hosting Features - Included in Both Windows Hosting Plans
• Windows 2008 Hosting • ASP.NET 3.5 Hosting (SP1)
• IIS7 Hosting (Internet Information Services 7.0) • ASP.NET 2.0 Hosting
• IIS Manager Access • ASP.NET MVC Hosting
• Feature Delegation • Silverlight 3.0 Hosting
• URL Rewrite Module • ASP.NET AJAX Hosting
• SmarterStats / Raw Logs • LINQ Hosting
• SmarterMail / Webmail • Classic ASP Hosting
• Isolated Application Pool • PHP5 Hosting
• Full Trust Allowed • Microsoft Access Database Hosting
• Web-Based ASP.NET Control Panel (CP Demo) • Visual Studio Compatible
• MS SQL 2008 Hosting Included • Visual Web Developer Express Compatible
• SQL Management Studio Access • Microsoft Expression Web Compatible
• /bin folder, CodeBehind • 24/7 Technical Support
• DELL Servers with 32 GB RAM & RAID 10 Disk Array • Extensive Knowledge Base
• Free Components • No Long Term Contracts
February 23, 2010 at 5:16 pm
Can someone still please help me with these 3 questions?
1. can I write a couple round trip events in c# asp.net, update a table in sql server, read from it,move the files to a web hoster .2. Anyone know an inexpensive web server hoster that use ms sql server? T3. I noticed there are several approaches to binding to ms sql server data in my research.Can someone tell me which is considered more commonly used in the real world, ado.net, DAL, I read something about LINQ.
February 23, 2010 at 10:07 pm
As far as writing code against SQL, get yourself the developer version ($50ish, same as Enterprise edition without the license for production use) or Express if you don't want to pay that; it's certainly going to be easier for you to develop on your own machine than to push pages to a web site with every change. I would think that ideally you would want to be at least familiar with several data access technologies, any decent c# book should cover ado.net and linq. You might be able to access Books 24x7 for free online via your local library, if so then you have access to a good number of recent releases on both c# and SQL Server.
I don't know of any cheap hosting services that offer what you are looking for, I've never looked, but deployment can be as easy or complicated as you want - a file copy at it's simplest. You can test this on your local machine, albeit the IIS version may not be quite the same as on a server OS.
Matt.
February 24, 2010 at 6:57 am
I would certainly agree with matt - I think you'll be much better off buying the developer license and installing directly on your own pc - you can create apps just the same, but you have the added bonus that you have complete control of the environment, you don't have to worry about some random tech fixing issues as they happen, unexpected downtime etc. Plus you get some experience installing and configuring sql server - I'm sure you'd find no end of help on these forums if you had questions
--------------------------
I long for a job where my databases dont have any pesky users accessing them 🙂
February 24, 2010 at 7:54 am
I would start by downloading, for free, the Express versions of SQL Server and Visual Web Developer from
Then I would look at
where there is information to get you started.
You could then look at getting hold of a few books, paying for better versions of the products etc.
February 24, 2010 at 10:01 am
Thank u all for the help! winhost.com supports asp.net 3.5 and has sql server 2008 4.95 per month plus 10 for a 1 uear domain name.
I ordered from amozon a book with a 4.5 rating on c# 2008 and asp.net 2008.
I have the trial version of sql 2008 and have years of experience with 200 and 2005.
thanks to you all, I feel like I am moving in the right direction.
I should be knowledgeable on multiple data access technolgies, I have decided to start with LINQ.
Is it normal to fear that if it runs good locally, when I copy the files to winhost It wil not work the same. ?
thank you all very much
February 24, 2010 at 10:03 am
permissions can certainly cause you some problems early on when developing locally -
local machine
dev server
prod server
is my normal approach, so if i have problems, i can fix em in dev
--------------------------
I long for a job where my databases dont have any pesky users accessing them 🙂
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply