Jeffery J. Jensen, PE
Adjunct Professor

University of Nevada Las Vegas
Department of Civil and Environmental Engineering
4505 S Maryland Pkwy
Box 454015
Las Vegas NV 89154-4015

Email: jefferyjjensen@gmail.com
Mobile: 702-327-9294
Jeff Jensen Notes the Land Management System

Landscape Management System by GIS Engineering

7 habits of effectiveness

  1. Be Proactive - take responsibility, I'm in charge, be accountable
  2. Begin with the end in mind. Where will this ladder of success take me, is it on the right building.
  3. First Things First - integrity to walk our walk, talk our talk. Keep the main thing the main thing.
  4. Think Win Win
  5. Synergy
  6. Sharpen the Saw

Timeline

Begin with the End in Mind

To Do Items


Table of Contents

  1. Setup - getting Visual Studio and Web Hosting
  2. Creating a Basic Web Page in Visual Studio
  3. Visual Studio IDE
  4. Database
  5. ASP.NET Configuration
  6. ASP.NET and SQL Server
  7. ASP.NET Web Server Controls
  8. ASP.NET Master Pages
  9. ASP.NET Themes, Skins and CSS
  10. Help and References

Download Microsoft Visual Studio

Web Hosting with Godaddy

Godaddy Account

Godaddy - how to setup folder browsing

.NET Web Hosting

Assign a Domain to GoDaddy Hosting Account


Creating a Basic Web Page in Visual Web Developer


Creating a Basic Web Page in Visual Studio on Godaddy Server

  1. Open Visual Studio 2010
  2. File → New Website
  3. Installed Templates click Visual Basic and select ASP.NET Empty Web Site
    Note, I'm unable to get the ASP.NET Web Site to work on Godaddy
  4. Web location select ftp and give it a name BasicWebSite
  5. After clicking the Browse... button, uncheck the Anonymous log on checkbox and then enter your godaddy ftp server user name journeyeducati and password Normalschool1
  6. Add a page to the Web Site
  7. Add HTML to the Page
  8. View in Browser by right clicking anywhere on the page and selecting View in Browser. Then a web browser like Internet Explorer will open and display the web page.
  9. Adding and Programming Controls

Visual Studio Templates

Visual Studio Copy Web Site

Visual Studio and ASP.NET


Visual Studio IDE

Formatting in Visual Studio

How to Open a Web Site in Visual Studio

Visual Studio - Publish Website

Server Explorer on Godaddy

Quick Tag Selector Bar

How to delete or remove a web project in visual studio

How to include HTML files in a web site


Databases

Microsoft SQL Server 2008 R2

Create SQL Server Database in Go Daddy Web Hosting Account

ASP.NET Web Site Configuration


Database - Microsoft SQL Server

Simple SQL Query using Management Studio

Connection String

Install - SQL Server 2008 R2 Express

Microsoft SQL Server Management Studio and Godaddy

  1. Background: how do you use Microsoft SQL Server Management Studio to connect to a SQL Server database stored on the Godaddy servers?
    Godaddy, contact Mandy in the President's Office (email: president@godaddy.com) about proposal to develop training materials for Godaddy in exchange for web hosting services.
  2. Install Microsoft SQL Server Management Studio
  3. Create a SQL Server database on Godaddy
  4. SQL Server 2008 R2 Tutorial → Starting SQL Server Management Studio
  5. Start → All Programs → Microsoft SQL Server 2008 → SQL Server Management Studio
  6. File → Connect Object Explorer...
  7. Should see a list of godaddy databases in the View → Object Explorer panel
  8. Editing Window: SQL Server Management Studio → New Query
  9. Reference

How to create/open a database in Visual Studio 2010

How do you view a table in Visual Studio

SQL Server Stored Procedures

How to create a stored procedure using SQL Server Management Studio

How do you view the results of a stored procedure?

How do you assign an alias or variable for a database name in an SQL statement?

How do you return only the unique values from a select query?

How do you query null in SQL Server

"When using IntelliSense, it's often helpful to enter the table name before you enter the columns. That way, IntelliSense can include the column names for the table in the completion lists." (Murach's SQL Server 2008 for Developers, p. 68)

How to view a table using ASP.NET


ASP.NET and SQL Server

How to view an SQL Server table in a web page using a DropDownList, GridView and SqlDataSource Controls

How to view an SQL Server table in a web page using C# code behind using asp:SqlDataSource

  1. Open a web page such as Default.aspx in visual studio
  2. ensure the web.config has a working connection string
  3. drag an asp:SqlDataSource control and an asp:GridView control onto the Default.aspx web page in between the <div> tags
  4. write the following C# code in the code-behind file
  5. http://www.itfunda.us/examples/SheoTest/Default.aspx
  6. Reference

How to view an SQL Server table in a web page using C# code behind using asp:SqlDataSource

How to view an SQL Server table in a web page using C# code behind using ADO.NET

  1. Use Server Explorer to test the connection to the SQL Server Database
  2. add blank aspx page
  3. add the GridView asp.net control
  4. edit the code behind file
  5. add the following namespaces to the C# code behind file
  6. assign the connection string from the web.config to a variable
  7. MSDN SqlCommand.Connection Property
  8. MSDN SqlConnection Class
  9. Solution: http://www.itfunda.us/examples/viewtable/Default.aspx
  10. Reference:

ASP.NET Web Forms Features - Control Categories

SQL Server Sample Databases

How to load Adventure Works Database on GoDaddy SQL Server Database

Go Daddy and SQL Server


ASP.NET Directives

@Page Directive


ASP.NET Web Server Controls

Response.Write in ASP.NET

ASP.NET Server Controls

Label Control

Label Control Questions and Answers

  1. How do you write Text for the asp:Label control?
  2. How do I modify/control/set the text attribute of the Label control from the code-behind C# file?
  3. How do I use CSS to format my text in an asp:Label?
  4. How do I add a CSS style in a Label control from the code-behind C# file?
  5. 6. How to associate an asp:Label with a TextBox?

Literal Control

File Upload Control

Site Navigation

Using CSS with a Navigation Control

SiteMapPath Control

Textbox Control

TextBox Control Questions and Answers

AdRotator Control

ListView control

SqlDataSource Control

ASP and HTML elements/tags


ASP.NET Master Pages

Master Page Directive Attributes

Steps to creating and using Master Pages

Questions and Answers on Master Pages

ASP.NET Themes, Skins and CSS

ASP.NET Folders


Help and References

MSDN Visual Studio 2010 Help

Visual Studio and .NET Training

ASP.NET Help

Visual Studio Limitations

  1. Visual Studio 2010 cannot connect to a secure ftp server
  2. Appears Go Daddy does NOT support Visual Studio Web Deployment using MS Web Deployment
  3. "The Publish Web Site tool can copy only to the local computer or to another computer on the local network." (MSDN ASP.NET Web Site Project Deployment Overview)

IIS

Create a User Login Page

Bing Maps and SQL Server

IIS 7, Godaddy and Google Maps

ASP.NET and Google Maps API

Visual Studio and Bing Maps

Internet Explorer WebControls


Hello World example using ftp Godaddy web hosting, Visual Studio 2008 and ASP.NET 3.5

  1. Open Visual Studio 2008 and Create a New Web Site using ASP.NET, location FTP, godaddy server (ftp://journey-education.org/wwwroot/vs2008), and language Visual C#
  2. Login to the Godaddy Web Hosting ftp server
  3. Add the "hello world" text to the Default.aspx file
  4. Test the webpage. Will get the following error
  5. Delete the <authentication mode="Windows" /> tag from web.config file
  6. Save the web.config and Default.aspx files (Visual Studio 2008 should automatically ftp these files up to the Godaddy server). Then open a browser and view the file:

New or Open existing website using ftp Godaddy web hosting, Visual Studio 2010 and ASP.NET 4.0

  1. Background
  2. Godaddy Setup
  3. Step 1a - Open Visual Studio 2010 and Create a New Web Site using ASP.NET, location FTP, godaddy server (ftp://journey-education.org/wwwroot/vs2010), and language Visual C#. Remember, as of August 2010, godaddy started supporting ASP.NET 4.0.
  4. Step 1b - New Web site
    • Visual Studio: File → New Web Site
    • In the New Web Site dialog box, in the left-most Location list, click FTP Site and then click Browse.
    • VS2010NewWebSite.png
    • After clicking the Browse... button, uncheck the Anonymous log on checkbox and then enter your godaddy ftp server user name journeyeducati and password Normalschool1
  5. Login to the Godaddy Web Hosting ftp server
  6. If opening an existing website, will get this dialog box, just check the Open the existing Web site radio button
  7. If the connection is successful Visual Studio displays the FTP web site name in the Solution Explorer and lists the files that are already in the FTP Web site.
  8. Enable .NET to show more detailed error messages
    • Open the Web.config file in Visual Studio
  9. MSDN ASP.NET Authentication
  10. The rest is the same as Visual Studio 2008 and duplicate for your convenience
  11. Test the webpage. Will get the following error
  12. Delete the <authentication mode="Windows" /> tag from web.config file. Visual Studio will default to Windows Authentication when creating an empty web site. If using ASP.NET web site template, then Forms Authentication is used.
  13. Save the web.config and Default.aspx files (Visual Studio 2010 should automatically ftp these files up to the Godaddy server). Then open a browser and view the file:

Hello World example using http Godaddy web hosting, Visual Studio 2008 and ASP.NET 3.5

How to edit the Base URL of a web site in Visual Studio

Visual Studio Line Numbers

Visual Studio and Web Page Debugging

ASP.NET Folders


Microsoft SQL Server 2005 and ASP.NET

Visual Studio, Silverlight and Bing Maps

Visual Studio and Google Data API

ASP.NET and Web.config

Visual Studio Training with Dallas

  1. Lesson 1 (Wed 30 June 2010 at 7pm)
    1. Download and Install Visual Studio 2010 Professional
    2. basics of Visual Studio
  2. Lesson 2 (Wed 7 July 2010 at 7pm)
    1. Setup godaddy account to use .NET
    2. Configure Visual Studio to connect to godaddy web server
    3. Editing Web Sites with FTP in Visual Web Developer
    4. Internet Explorer Web Controls vs. Silverlight
    5. Create a simple web page on godaddy using Visual Studio
  3. Future Lessons
    1. Visual Studio and Silverlight
    2. Visual Studio and Bing Maps
    3. Visual Studio and Google Maps
    4. Visual Studio and ESRI ArcGIS
    5. Visual Studio and Moodle
    6. Visual Studio and Expression Blend - 3D graphics of projections
    7. Visual Studio and Google Apps
    8. Visual Studio and Google Maps Data API

Commenting Code

Microsoft Certified Technology Specialist (MCTS)

ASP.NET Courses

C#

Visual Studio and Cascading Style Sheets (CSS)

Visual Studio and XHTML Validation

Visual Studio and HTML5

odesk

Free Website/Layout Templates

Training on ASP.NET

UNLV Continuing Education Course - Introduction to Visual Studio 2010 and ASP.NET 4

  1. Internet Design and Technology Certificate Program
    • recommend 6 sessions at $289
    • prerequist - HTML/XHTML Level 2 or
  2. Introduction
  3. Chapter 1: Getting Started with ASP.NET 4
  4. Chapter 2: Building an ASP.NET Web Site
  5. Appendix B: Configuring SQL Server 2008

ASP.NET Online Training by Sheo Narayan with www.itfunda.com

Example Training Videos

Textbook Cover Requirements

  1. Generic background
  2. Company Name is ITFunda.com (Information Technology Fundamentals)
Engineering College of UNLV