Web hosting forums || get your web hosting related questions answered https://www.hostasp.net/forums/com_easydiscuss_sh404_view_featured.html 2024-04-28T18:04:58+00:00 Joomla! - Open Source Content Management How to: One-Click Web publishing or Deploying your Website using Visual Studio 2011-11-22T02:58:13+00:00 2011-11-22T02:58:13+00:00 https://www.hostasp.net/forums/question/how-to-one-click-web-publishing-or-deploying-your-website-using-visual-studio.html Jacob jacob@hostasp.net [b]In this Topic we will see how to deploy a Sample MVC Web Application using Visual Studio 2010 One-click publish feature:[/b] After you have created an ASP.NET Web application project or an ASP.NET Web site project in Visual Studio 2010, you typically deploy the project to a Web server for others to access your application. Deployment typically involves more than just copying the application's files from one server to another. You might also have to perform additional tasks, such as the following: [list] Changing Web.config file settings that must be different in the destination environment, such as settings for debugging, or database connection strings. You could use File Manager to modify your web.config. Propagating data or data structures in databases that are used by the Web application. You would use SQL Management studio from your machine to connect to remote SQL DB server. Configuring Website IIS settings on the HostASP server, such as the application pool, the authentication method, whether directory browsing is allowed, and error handling. You will be using WebsitePanel control panel to perform this IIS settings. Installing security certificates. If you would need SSL you must take support from HostASP Setting values in the registry of the destination computer. - Is not allowed with HostASP Shared hosting Installing application assemblies in the global assembly cache (GAC) on the destination computer. - Is not allowed with HostASP Shared hosting [/list] An extension to Microsoft Internet Information Services (IIS) that is named Web Deploy can automate most deployment tasks. Visual Studio provides tools that work with Web Deploy to make it easier for you to deploy a Web application project. [quote]One-click publish - Web Application Project[/quote] [b]Following steps will show you how to deploy a Web Application Project using One-click publish feature[/b] [list=1] Creating MS SQL databases. Setting up Web publishing environment. Configuring your IIS Website application pool. Creating new Publish profile in Visual Studio. Setting up Publish Web in Visual Studio Setting up Publish SQL in Visual Studio Publishing your Website. [/list] [b]Step 1. Creating MS SQL databases. (WebsitePanel) [/b] If your web application project uses MS SQL database then you would need to create a new database on your hosting account. To create new database follow the steps here. < [url=http://www.hostasp.net/forum/managing-databases/57-creating-ms-sql-server-databases-and-database-users.html]Creating New databases[/url] > . You will use this information to rebuild publishing XML in the following step. [img]http://www.hostasp.net/articles/images/visual-studio-remote-deployment/vs-2010-ms-sql-server-db.PNG[/img] [b]Step 2. Setting up Web publishing environment. (WebsitePanel)[/b] Login to your Web hosting panel and select your Website, you would see Web Publish properties Tab, now enabling this will create a new web publishing account. After your account is created you will see a link to rebuild publishing XML- click on the link and configure your database for use. Now after reconfigure is done, you will be able to download the updated [b]Publishing XML for your Reference[/b]. This XML contains your Service URL, SQL server name, and other related information for you Visual studio publishing. (If you're using WebMatrix you could use this XML to directly import to WebMatrix IDE). ([b]Download your publishing XML to your client machine[/b]) [img]http://www.hostasp.net/articles/images/visual-studio-remote-deployment/dotnet-webpublishing-settings.PNG[/img] [b]Step 3. Configuring your IIS Website application pool. (WebsitePanel)[/b] This is a vital part you would need to really look into it and set it up correctly. You would choose appropriate Application pool depending upon your web application targeted framework, if you have app built on framework .NET 4.0 then your choice here would be 4.0. [i][b]Please note that for MVC application you would need to select Integrated Pipeline.[/b] for rest of app you would select Classic pool which are just displayed as 2.0 / 4.0.[/i] Still the version depends on your targeted framework. [img]http://www.hostasp.net/articles/images/visual-studio-remote-deployment/dotnet-application-pool-settings.PNG[/img] [b]Step 4. Creating new Publish profile in Visual Studio. (Visual Studio 2010)[/b] Now that we have configured our Web publishing setup on our hosting space. Let see how to setup Visual studio for Web deploy. [img]http://www.hostasp.net/articles/images/visual-studio-remote-deployment/vs-2010-create-web-publish-profile-menu.PNG[/img] Open your Web project using Visual studio 2010, on menu bar you would see [b]Publish:[/b] menu item. You could create as many profiles you want using this, let us see how to create a new profile now. Click on new profile option. This will launch profile screen as shown below. [i]Open your Publishing XML and have it ready reference. [/i] [img]http://www.hostasp.net/articles/images/visual-studio-remote-deployment/vs-2010-publishing-profilesetup.PNG[/img] a) Name your profile b) Select publishing method as "Web Deploy" [b]c) Find publishUrl attribute in downloaded XML file and copy its value to Service URL field. (suffix with msdeploy.axd - refer figure above)[/b] d) On Site/application field type your domain name (or) copy msdeploySite attribute value from XML file. e) Leave untrusted certificate field checked. f) Configure user name and password that your created in Web publishing tab on your hosting space ( you could refer userName and userPWD attribute from your downloaded publishing XML). Click on Save button to save your profile. (See top right corner of the profile window) Ok, we just saw how we will have to setup the publish profile. The next 2 steps 5 & 6 will be about how you want to make this publish process work for your website contents and MS SQL db. [img]http://www.hostasp.net/articles/images/visual-studio-remote-deployment/vs-2010-publishing-menu.PNG[/img] [b]Step 5. Setting up Publish Web in Visual Studio[/b] Here in this screen you would determine what contents are to be deployed on your remote website. [b]We will NOT concentrate on Packing-part instead we’re going to deploy directly to your hosting space. [/b]As you see on the image, you can determine whether only runtime components is required ( advisable for release version / production environment) (or) all files of your project and then you can also choose whether to exclude app_data folder and so on. [i]Do not forget to “check” Include all databases configured in Package / Publish SQL tab if you’re using SQL server database for your web application project.[/i] [img]http://www.hostasp.net/articles/images/visual-studio-remote-deployment/vs-2010-publish-web.PNG[/img] [b]Step 6. Setting up Publish SQL in Visual Studio[/b] You will be using this Publish SQL screen for setting up DB configuration. As you see in this screen, you will select the databases entries you want publish, you could also import directly from your web.config. Then you will need to configure your remote database connectivity for publishing your SQL and data. [i]Refer to your downloaded Publish XML content for destination SQL server name, your database and its credentials.[/i] The connection string as you see on the image will be generated, after successful configuration of destination database setup. (You could copy this connection string and update your Web.config HostASP on hosting space.) Further down in this screen you could see scripting options that determine what to publish to remote DB (Schema / Data / both). [img]http://www.hostasp.net/articles/images/visual-studio-remote-deployment/vs-2010-publish-SQL.PNG[/img] To setup HostASP remote database connection string, click on "..." button on Destination Database Information. This will launch configuration setup for remote database as shown below. You would refer to downloaded Publish XML to configure this part. [img]http://www.hostasp.net/articles/images/visual-studio-remote-deployment/vs-2010-database-connectionstring.PNG[/img] [b]Step 7. Publishing your Website.[/b] Hurray, you're done with required setup for publishing your Web project. Now it is time to publish your website. On your Visual Studio menu bar select your publishing profile and click on “Publish web” (or) alternatively you could right click on your project name and select “Publish” action. This will copy all your web project contents, SQL database information as per configured setup in Visual studio. [img]http://www.hostasp.net/articles/images/visual-studio-remote-deployment/vs-2010-publishing.PNG[/img] After you get your web project successfully published, you would need to update your connection string in web.config on your hosting space. You could see the connection string that you need in Step 6. above. This will make your Website point to your HostASP database. You can now launch your sample MVC website that you just published. [img]http://www.hostasp.net/articles/images/visual-studio-remote-deployment/vs-2010-mvc-application.PNG[/img] Good luck, if you have any queries contact HostASP support. [b]In this Topic we will see how to deploy a Sample MVC Web Application using Visual Studio 2010 One-click publish feature:[/b] After you have created an ASP.NET Web application project or an ASP.NET Web site project in Visual Studio 2010, you typically deploy the project to a Web server for others to access your application. Deployment typically involves more than just copying the application's files from one server to another. You might also have to perform additional tasks, such as the following: [list] Changing Web.config file settings that must be different in the destination environment, such as settings for debugging, or database connection strings. You could use File Manager to modify your web.config. Propagating data or data structures in databases that are used by the Web application. You would use SQL Management studio from your machine to connect to remote SQL DB server. Configuring Website IIS settings on the HostASP server, such as the application pool, the authentication method, whether directory browsing is allowed, and error handling. You will be using WebsitePanel control panel to perform this IIS settings. Installing security certificates. If you would need SSL you must take support from HostASP Setting values in the registry of the destination computer. - Is not allowed with HostASP Shared hosting Installing application assemblies in the global assembly cache (GAC) on the destination computer. - Is not allowed with HostASP Shared hosting [/list] An extension to Microsoft Internet Information Services (IIS) that is named Web Deploy can automate most deployment tasks. Visual Studio provides tools that work with Web Deploy to make it easier for you to deploy a Web application project. [quote]One-click publish - Web Application Project[/quote] [b]Following steps will show you how to deploy a Web Application Project using One-click publish feature[/b] [list=1] Creating MS SQL databases. Setting up Web publishing environment. Configuring your IIS Website application pool. Creating new Publish profile in Visual Studio. Setting up Publish Web in Visual Studio Setting up Publish SQL in Visual Studio Publishing your Website. [/list] [b]Step 1. Creating MS SQL databases. (WebsitePanel) [/b] If your web application project uses MS SQL database then you would need to create a new database on your hosting account. To create new database follow the steps here. < [url=http://www.hostasp.net/forum/managing-databases/57-creating-ms-sql-server-databases-and-database-users.html]Creating New databases[/url] > . You will use this information to rebuild publishing XML in the following step. [img]http://www.hostasp.net/articles/images/visual-studio-remote-deployment/vs-2010-ms-sql-server-db.PNG[/img] [b]Step 2. Setting up Web publishing environment. (WebsitePanel)[/b] Login to your Web hosting panel and select your Website, you would see Web Publish properties Tab, now enabling this will create a new web publishing account. After your account is created you will see a link to rebuild publishing XML- click on the link and configure your database for use. Now after reconfigure is done, you will be able to download the updated [b]Publishing XML for your Reference[/b]. This XML contains your Service URL, SQL server name, and other related information for you Visual studio publishing. (If you're using WebMatrix you could use this XML to directly import to WebMatrix IDE). ([b]Download your publishing XML to your client machine[/b]) [img]http://www.hostasp.net/articles/images/visual-studio-remote-deployment/dotnet-webpublishing-settings.PNG[/img] [b]Step 3. Configuring your IIS Website application pool. (WebsitePanel)[/b] This is a vital part you would need to really look into it and set it up correctly. You would choose appropriate Application pool depending upon your web application targeted framework, if you have app built on framework .NET 4.0 then your choice here would be 4.0. [i][b]Please note that for MVC application you would need to select Integrated Pipeline.[/b] for rest of app you would select Classic pool which are just displayed as 2.0 / 4.0.[/i] Still the version depends on your targeted framework. [img]http://www.hostasp.net/articles/images/visual-studio-remote-deployment/dotnet-application-pool-settings.PNG[/img] [b]Step 4. Creating new Publish profile in Visual Studio. (Visual Studio 2010)[/b] Now that we have configured our Web publishing setup on our hosting space. Let see how to setup Visual studio for Web deploy. [img]http://www.hostasp.net/articles/images/visual-studio-remote-deployment/vs-2010-create-web-publish-profile-menu.PNG[/img] Open your Web project using Visual studio 2010, on menu bar you would see [b]Publish:[/b] menu item. You could create as many profiles you want using this, let us see how to create a new profile now. Click on new profile option. This will launch profile screen as shown below. [i]Open your Publishing XML and have it ready reference. [/i] [img]http://www.hostasp.net/articles/images/visual-studio-remote-deployment/vs-2010-publishing-profilesetup.PNG[/img] a) Name your profile b) Select publishing method as "Web Deploy" [b]c) Find publishUrl attribute in downloaded XML file and copy its value to Service URL field. (suffix with msdeploy.axd - refer figure above)[/b] d) On Site/application field type your domain name (or) copy msdeploySite attribute value from XML file. e) Leave untrusted certificate field checked. f) Configure user name and password that your created in Web publishing tab on your hosting space ( you could refer userName and userPWD attribute from your downloaded publishing XML). Click on Save button to save your profile. (See top right corner of the profile window) Ok, we just saw how we will have to setup the publish profile. The next 2 steps 5 & 6 will be about how you want to make this publish process work for your website contents and MS SQL db. [img]http://www.hostasp.net/articles/images/visual-studio-remote-deployment/vs-2010-publishing-menu.PNG[/img] [b]Step 5. Setting up Publish Web in Visual Studio[/b] Here in this screen you would determine what contents are to be deployed on your remote website. [b]We will NOT concentrate on Packing-part instead we’re going to deploy directly to your hosting space. [/b]As you see on the image, you can determine whether only runtime components is required ( advisable for release version / production environment) (or) all files of your project and then you can also choose whether to exclude app_data folder and so on. [i]Do not forget to “check” Include all databases configured in Package / Publish SQL tab if you’re using SQL server database for your web application project.[/i] [img]http://www.hostasp.net/articles/images/visual-studio-remote-deployment/vs-2010-publish-web.PNG[/img] [b]Step 6. Setting up Publish SQL in Visual Studio[/b] You will be using this Publish SQL screen for setting up DB configuration. As you see in this screen, you will select the databases entries you want publish, you could also import directly from your web.config. Then you will need to configure your remote database connectivity for publishing your SQL and data. [i]Refer to your downloaded Publish XML content for destination SQL server name, your database and its credentials.[/i] The connection string as you see on the image will be generated, after successful configuration of destination database setup. (You could copy this connection string and update your Web.config HostASP on hosting space.) Further down in this screen you could see scripting options that determine what to publish to remote DB (Schema / Data / both). [img]http://www.hostasp.net/articles/images/visual-studio-remote-deployment/vs-2010-publish-SQL.PNG[/img] To setup HostASP remote database connection string, click on "..." button on Destination Database Information. This will launch configuration setup for remote database as shown below. You would refer to downloaded Publish XML to configure this part. [img]http://www.hostasp.net/articles/images/visual-studio-remote-deployment/vs-2010-database-connectionstring.PNG[/img] [b]Step 7. Publishing your Website.[/b] Hurray, you're done with required setup for publishing your Web project. Now it is time to publish your website. On your Visual Studio menu bar select your publishing profile and click on “Publish web” (or) alternatively you could right click on your project name and select “Publish” action. This will copy all your web project contents, SQL database information as per configured setup in Visual studio. [img]http://www.hostasp.net/articles/images/visual-studio-remote-deployment/vs-2010-publishing.PNG[/img] After you get your web project successfully published, you would need to update your connection string in web.config on your hosting space. You could see the connection string that you need in Step 6. above. This will make your Website point to your HostASP database. You can now launch your sample MVC website that you just published. [img]http://www.hostasp.net/articles/images/visual-studio-remote-deployment/vs-2010-mvc-application.PNG[/img] Good luck, if you have any queries contact HostASP support. How much memory is allocated on ASP.NET application pool? 2012-07-29T18:07:28+00:00 2012-07-29T18:07:28+00:00 https://www.hostasp.net/forums/question/how-much-memory-is-allocated-on-asp-net-application-pool.html SPB support@hostasp.net It 256 MB Private memory for one website in Deluxe / Premium package. Starter hosting will get 80 MB per website and all rest of the websites by default will receive 120 MB http://www.hostasp.net/blog/announcements/application-pool-private-memory-and-cpu-allocation.html It 256 MB Private memory for one website in Deluxe / Premium package. Starter hosting will get 80 MB per website and all rest of the websites by default will receive 120 MB http://www.hostasp.net/blog/announcements/application-pool-private-memory-and-cpu-allocation.html Presales questions on ASP.NET web hosting plan and features 2012-03-05T11:40:32+00:00 2012-03-05T11:40:32+00:00 https://www.hostasp.net/forums/question/presales-questions-on-asp-net-web-hosting-plan-and-features.html Jacob jacob@hostasp.net [b]1. How many SQL databases are allowed under the plan?[/b] It depends on hosting plan you choose. If you choose Premium / Deluxe plan you will be able to use up to 25 SQL databases. a. What is the amount of disk space allowed? It is default max 400 MB can be used per DB. Size of SQL DB is consider to be part of your hosting space size which means you cannot exceed the hosting space allocated. b. Will I be able to logon remotely using SQL server 2008 studio management studio? Yes, you will be able to remote login to access SQL databases for deployment. c. Do I need to create databases only through hosting control panel with user names/passwords? Yes, you need to create databases only from hosting control panel, associated SQL user names and passwords with DB. [b]2. Do you allow scripts (scheduled tasks) to be run with the hosting plan? If so, how many allowed?[/b] Maximum 5 tasks are allowed on Premium / Deluxe hosting plan. They are predefined tasks that can be scheduled to be run as per configuration. Those are like bandwidth utilization, email notifications, hosting space backups and so. Get it in touch with tech support for more details. a. I run a few scripts every day to update the database or send emails/text messages. [b]3. How easy is it to transfer a domain already on another hosting account?[/b] Easier way is to update the A record with current domain registrar if you want to point to our hosting space immediately, then update the name servers information of your domain with our name servers that we share with you. To transfer a domain to us initiate a domain transfer along with order. Alternatively you will also be able to use Instant Alias for you to setup your website and test before it moves to production. [b]4. Do you allow Access DB 2007?[/b] Yes, we allow Access Databases. [b]5. Is there a way I can log into an account and use a File Manager so I do not have to FTP into the web server?[/b] Yes, you will have File manager in your hosting control panel using which you could upload or edit / update files directly. [b]6. Is there a 30-day money back guarantee?[/b] We offer web hosting packages with any-time money back guarantee, which means that at the time of cancellation, remaining period is calculated (pro-rata) considering all utilization of services and refund amount is worked out. [b]7. Is there any discount for buying 3 years compared to 1?[/b] You will find all our hosting subscriptions when paid for long duration are actually a discounted amount. [b]8. Where in US your data center is located (time zone)?[/b] We have ASP.NET hosting USA servers in US Dallas. [b]9. How many subdomains are allowed?[/b] It depends on your web hosting plan of choice. Premium / Deluxe hosting allow max 250 sub-domains / websites. [b]10. How many FTP accounts are allowed?[/b] It depends on your web hosting plan of choice. Premium / Deluxe hosting allow max 5 FTP accounts. [b]1. How many SQL databases are allowed under the plan?[/b] It depends on hosting plan you choose. If you choose Premium / Deluxe plan you will be able to use up to 25 SQL databases. a. What is the amount of disk space allowed? It is default max 400 MB can be used per DB. Size of SQL DB is consider to be part of your hosting space size which means you cannot exceed the hosting space allocated. b. Will I be able to logon remotely using SQL server 2008 studio management studio? Yes, you will be able to remote login to access SQL databases for deployment. c. Do I need to create databases only through hosting control panel with user names/passwords? Yes, you need to create databases only from hosting control panel, associated SQL user names and passwords with DB. [b]2. Do you allow scripts (scheduled tasks) to be run with the hosting plan? If so, how many allowed?[/b] Maximum 5 tasks are allowed on Premium / Deluxe hosting plan. They are predefined tasks that can be scheduled to be run as per configuration. Those are like bandwidth utilization, email notifications, hosting space backups and so. Get it in touch with tech support for more details. a. I run a few scripts every day to update the database or send emails/text messages. [b]3. How easy is it to transfer a domain already on another hosting account?[/b] Easier way is to update the A record with current domain registrar if you want to point to our hosting space immediately, then update the name servers information of your domain with our name servers that we share with you. To transfer a domain to us initiate a domain transfer along with order. Alternatively you will also be able to use Instant Alias for you to setup your website and test before it moves to production. [b]4. Do you allow Access DB 2007?[/b] Yes, we allow Access Databases. [b]5. Is there a way I can log into an account and use a File Manager so I do not have to FTP into the web server?[/b] Yes, you will have File manager in your hosting control panel using which you could upload or edit / update files directly. [b]6. Is there a 30-day money back guarantee?[/b] We offer web hosting packages with any-time money back guarantee, which means that at the time of cancellation, remaining period is calculated (pro-rata) considering all utilization of services and refund amount is worked out. [b]7. Is there any discount for buying 3 years compared to 1?[/b] You will find all our hosting subscriptions when paid for long duration are actually a discounted amount. [b]8. Where in US your data center is located (time zone)?[/b] We have ASP.NET hosting USA servers in US Dallas. [b]9. How many subdomains are allowed?[/b] It depends on your web hosting plan of choice. Premium / Deluxe hosting allow max 250 sub-domains / websites. [b]10. How many FTP accounts are allowed?[/b] It depends on your web hosting plan of choice. Premium / Deluxe hosting allow max 5 FTP accounts. Getting Started with WebMatrix - Part-2 WebMatrix Create Website from Template 2011-09-22T11:34:46+00:00 2011-09-22T11:34:46+00:00 https://www.hostasp.net/forums/question/getting-started-with-webmatrix-part-2-webmatrix-create-website-from-template.html Jacob jacob@hostasp.net [b]This article will take a first look at using WebMatrix Application - Microsoft's WebMatrix IDE for developing Web Pages applications. I will walk you through number of the core features that will make WebMatrix an ideal starter's web development framework. [/b] [b]Creating your Website using WebMatrix[/b] [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-creating-site-from-template_03.png[/img] Choose the Site From Template option, and you’ll see the the dialog below. Note that you may see a number of different templates, as WebMatrix is growing all the time. The one we are interested in is the Empty Site template, we will start building website from here. Select this template and give it the name MoviesDB. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-site-from-template-is-created_02.png[/img] [b]Understanding WebMatrix IDE[/b] At the top, you see a Quick Access Toolbar and a Context menu / ribbon, as in Microsoft Office 2010. At the bottom left, you see the workspace selector, which contains buttons that determine what appears above them in the left pane. On the right is the content pane, which is where you view reports, edit files, and so on. Finally, across the bottom is the notification bar, which displays messages as needed. Coming back to our session, Website MoviesDB is now been created and is started by WebMatrix. From this screen above, you can manage files within the application, databases and perform site analysis on Reports Workspace. It is a database driven website that we are going to build now, so let us create a Database by clicking on Manage databases option. This will lead to screen below for database creation, [img]http://www.hostasp.net/articles/images/webmatrix/websitepanel-add-databases_03.png[/img] Click on 'Add a database to your site' will create a database and place DB file under APP_DATA folder. This folder is created by default at the time of Website creation. Name of database is your website name by default, this can be changed right clicking DB listed on left panel. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-add-table-definition_02.png[/img] Workspace above is for managing Database schemas. You can create Tables, and then define schemas – create columns, delete columns, create relationship between tables, add constraints, perform data operations, create indexes and more. - all these are just simply from your WebMatrix IDE working on SQL Server Compact. DDL or DML operations managed through selecting appropriate Table view - Definition / Data view. Now let us create all required columns for Table 'Movies'. To create new columns click on 'New column' link that is enabled on context menu. Create columns such as Title, Release date, Director and so on. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-tableschema-definition_02.png[/img] We just created a table called 'Movies' with all required columns for displaying data on our website. We will now proceed with data entry on this table, followed by retrieving this data and displaying the same on Web pages. If you would need to further normalize data then create few more tables split the data by normalizing them and then establish relationship between tables. You could see the context menu "Relationships" enabled on Workspace menu which will be used for relationship management. To enter data to the table click on 'Data' of Table views on context menu. This will open table that you had selected in data entry mode. Find list of movies information that i had entered on Movies table. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-table-dataentry_03.png[/img] We assume that you have created the default page if you have not then follow here [url=http://www.hostasp.net/forum/webmatrix-visual-studio-remote-deployment/123-creating-a-new-web-page-using-webmatrix-ide.html]Create a Web Page[/url] Let us now see how to use Razor Syntax to query the database and show the data on Web page. This is the new Razor syntax. The @ sign followed by a pair of braces denotes a multi-line code block, and could be thought of as equivalent to a non-code behind script runat="server" block. We are now going to test reading from the database, so let us add some code to do that: [code type="xml"] var db = Database.Open("MoviesDB"); var sql = "Select Title from Movies";[/code] WebMatrix.Data.Database is Database class libary which provides an easy set of methods for working with databases. One of the methods - "Open" sets up a connection and opens connection to the database name passed as parameter input to the method. Next line of code you will see simple SQL query. We will add some more code to the body of the page for simple display from Database MoviesDB: Movies Databases [code type="xml"] Movies Databases @foreach( var row in db.Query(sql)) { @row.Title } [/code] Database.Query() is a method that returns an IEnumerable. The SQL is executed against the database, and the rows of data returned are converted into a collection of objects, with the database field names exposed as properties of those objects. foreach is preceded with an @ sign, but no braces. This is because there is only a single line of code. The literal text and html markup in the second line is not considered part of the code block, but it is recognised by the Razor parser as belonging to the each iteration of the loop, and the closing brace confirms that. Inline expressions or variables are also preceded by the @ sign, as in @row.Title. The Razor parser will recognise these and replace them appropriately. We can see the result of this operation by clicking Launch in the menu, or simply hitting F12: Please find below the dynamic output of data from Database and how WebMatrix had made it so simple for Web application programming. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-moviesapp-browserexecution_03.png[/img] We will then discuss in detail about Web programming using Razor Syntax and about publishing websites to remote server - we will see how to use web deploy method to publish websites to HostASP Web hosting accounts from your development environment. Read more about - check related reference below [b]This article will take a first look at using WebMatrix Application - Microsoft's WebMatrix IDE for developing Web Pages applications. I will walk you through number of the core features that will make WebMatrix an ideal starter's web development framework. [/b] [b]Creating your Website using WebMatrix[/b] [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-creating-site-from-template_03.png[/img] Choose the Site From Template option, and you’ll see the the dialog below. Note that you may see a number of different templates, as WebMatrix is growing all the time. The one we are interested in is the Empty Site template, we will start building website from here. Select this template and give it the name MoviesDB. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-site-from-template-is-created_02.png[/img] [b]Understanding WebMatrix IDE[/b] At the top, you see a Quick Access Toolbar and a Context menu / ribbon, as in Microsoft Office 2010. At the bottom left, you see the workspace selector, which contains buttons that determine what appears above them in the left pane. On the right is the content pane, which is where you view reports, edit files, and so on. Finally, across the bottom is the notification bar, which displays messages as needed. Coming back to our session, Website MoviesDB is now been created and is started by WebMatrix. From this screen above, you can manage files within the application, databases and perform site analysis on Reports Workspace. It is a database driven website that we are going to build now, so let us create a Database by clicking on Manage databases option. This will lead to screen below for database creation, [img]http://www.hostasp.net/articles/images/webmatrix/websitepanel-add-databases_03.png[/img] Click on 'Add a database to your site' will create a database and place DB file under APP_DATA folder. This folder is created by default at the time of Website creation. Name of database is your website name by default, this can be changed right clicking DB listed on left panel. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-add-table-definition_02.png[/img] Workspace above is for managing Database schemas. You can create Tables, and then define schemas – create columns, delete columns, create relationship between tables, add constraints, perform data operations, create indexes and more. - all these are just simply from your WebMatrix IDE working on SQL Server Compact. DDL or DML operations managed through selecting appropriate Table view - Definition / Data view. Now let us create all required columns for Table 'Movies'. To create new columns click on 'New column' link that is enabled on context menu. Create columns such as Title, Release date, Director and so on. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-tableschema-definition_02.png[/img] We just created a table called 'Movies' with all required columns for displaying data on our website. We will now proceed with data entry on this table, followed by retrieving this data and displaying the same on Web pages. If you would need to further normalize data then create few more tables split the data by normalizing them and then establish relationship between tables. You could see the context menu "Relationships" enabled on Workspace menu which will be used for relationship management. To enter data to the table click on 'Data' of Table views on context menu. This will open table that you had selected in data entry mode. Find list of movies information that i had entered on Movies table. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-table-dataentry_03.png[/img] We assume that you have created the default page if you have not then follow here [url=http://www.hostasp.net/forum/webmatrix-visual-studio-remote-deployment/123-creating-a-new-web-page-using-webmatrix-ide.html]Create a Web Page[/url] Let us now see how to use Razor Syntax to query the database and show the data on Web page. This is the new Razor syntax. The @ sign followed by a pair of braces denotes a multi-line code block, and could be thought of as equivalent to a non-code behind script runat="server" block. We are now going to test reading from the database, so let us add some code to do that: [code type="xml"] var db = Database.Open("MoviesDB"); var sql = "Select Title from Movies";[/code] WebMatrix.Data.Database is Database class libary which provides an easy set of methods for working with databases. One of the methods - "Open" sets up a connection and opens connection to the database name passed as parameter input to the method. Next line of code you will see simple SQL query. We will add some more code to the body of the page for simple display from Database MoviesDB: Movies Databases [code type="xml"] Movies Databases @foreach( var row in db.Query(sql)) { @row.Title } [/code] Database.Query() is a method that returns an IEnumerable. The SQL is executed against the database, and the rows of data returned are converted into a collection of objects, with the database field names exposed as properties of those objects. foreach is preceded with an @ sign, but no braces. This is because there is only a single line of code. The literal text and html markup in the second line is not considered part of the code block, but it is recognised by the Razor parser as belonging to the each iteration of the loop, and the closing brace confirms that. Inline expressions or variables are also preceded by the @ sign, as in @row.Title. The Razor parser will recognise these and replace them appropriately. We can see the result of this operation by clicking Launch in the menu, or simply hitting F12: Please find below the dynamic output of data from Database and how WebMatrix had made it so simple for Web application programming. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-moviesapp-browserexecution_03.png[/img] We will then discuss in detail about Web programming using Razor Syntax and about publishing websites to remote server - we will see how to use web deploy method to publish websites to HostASP Web hosting accounts from your development environment. Read more about - check related reference below How to publish a web application using WebMatrix Web Deploy 2011-09-25T19:57:32+00:00 2011-09-25T19:57:32+00:00 https://www.hostasp.net/forums/question/how-to-publish-a-web-application-using-webmatrix-web-deploy.html Jacob jacob@hostasp.net [b]To run the steps in this procedure you must be running Windows XP SP3 or a later version of Windows. You'll also need to have WebMatrix installed. Please see here for installation WebMatrix [url=http://www.hostasp.net/forums/question/getting-started-with-webmatrix-part-1-webmatrix-installation.html]Installing WebMatrix[/url][/b] [b]Just follow the simple steps below for setting up your website and WebMatrix IDE[/b] [b]How it works: [/b] After you create a website locally, you would typically publish the website to your [b]Web hosting Space[/b]. Publishing your website involves following steps: Step 1: Preparing your Web Hosting Space Step 2: Configuring WebMatrix for Publishing Step 3: Publishing Step 4: Review Site [b]Web hosting Space[/b] When you publish your website, you copy files from your computer to a web server that's maintained by HostASP. That can be done by two ways Web Deploy method and FTP method. We support both Web Deploy and FTP method to automate the publishing process. FTP method lets you publish Microsoft SQL Server Compact 4.0 databases, but not databases that use SQL Server or SQL Server Express. Among the publishing options is SSL, which stands for secure sockets layer. (SSL is what you're using if you access a Web site using https:// instead of http://.) SSL encrypts the information going between the browser and server, and is a good idea for pages that involve private information like passwords and credit-card numbers. Setting up SSL requires extra steps like purchasing and configuring a certificate that's used for encryption. At HostASP, we offer Free SSL publishing URL when you do Web Deploy all your files are encrypted, safely and securely transferred to your HostASP Web hosting account. [b]Databases[/b] If you're using SQL Server Compact as your database, the data is stored in an .sdf file. When you publish the database, WebMatrix copies not only the .sdf file but also the database program itself to the web server. This ensures that the published site will work even if SQL Server Compact isn't already installed on the web server. If you're using a SQL Server or MySQL database, WebMatrix publishes the database by creating scripts that run in a database that has been created for you by your hosting provider. These scripts create database tables and insert data into them in order to replicate the structure and data that you have in the database on your computer. If you're using a SQL Server Compact database and want to publish to a SQL Server database, you must migrate the data to SQL Server before publishing. For instructions, see Migrate a database to SQL Server. You might want to do this to take advantage of SQL Server features such as stored procedures and its additional capabilities, such as handling more than 256 concurrent connections or creating databases larger than 4 gigabytes In this session we will see how to deploy our movies website, we earlier saw in other topic how to develop a simple movies website using MS SQL Compact DB. We will now deploy this website to our web hosting account on domain name http://www.yourwebhosting.in/ [b]Step 1: Preparing your Web Hosting Space[/b] Very first step that you would need to do is prepare your website for web publishing on our web hosting space. Login to your web hosting control panel, open website properties and setup a web deploy account ( this will create a windows NT account ). Use this account to configure the Publishing XML. This will enable your website for remote Website publishing. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-enabling-web-deployment_03.png[/img] To setup an web deploy account - Provide user name and password for your Web publishing and click on enable button. This will enable your web deployment account for web publishing. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-webdeploy-account_03.png[/img] You could see Web publishing is now enabled on your account. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-webpublishing-enabled_03.png[/img] You do have option to configure Web publishing XML - If you have multiple databases on your web hosting account and based on your application database type, you could choose a MS SQL database or My SQL database, The database user whom permission is granted and then the FTP account. Select your choice and rebuild the publishing XML. After rebuild is complete your publishing XML is saved and can be downloaded onto your local machine for import to WebMatrix. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-publishingsettings_03.png[/img] [b]Step 2: Configuring WebMatrix for Publishing[/b] Now that we configured our web hosting account for Web publishing, let us download the publishing XML file. The file that you download will have .publishsettings as extension , here in our case we will have yourwebhosting.in.publishsettings. Find below the structure of publishing XML file. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-publishingxml_02.png[/img] Now go to WebMatrix IDE on Top Menu -> Publish -> Settings and Import the file by clicking on "Import Publish Settings" this would default all the required fields with server information that you have on Publishing XML. Publishing XML supports both FTP method and Web deploy method. Let us see deployment using Web Deploy method. You would also notice that server name with https prefix, we have setup this URL with SSL certificate so that you can safely deploy your website over internet. One more thing you would notice is "Remote connection string not required" against this Movies DB it is because this MoviesDB application uses integrated SQL Compact Databases .SDF and so you would not require an explict or external MS SQL Server access on your hosting account, if your web application uses MSSQL or MySQL server then it would be filled in with information by default from Publishing XML. Ok, now that you have imported the settings lets Click on validate settings to connect to the server. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-import-publishingxml_03.png[/img] You have done your validation part and is successful, the information you have got on Publish setting is fine and able to connect to server. Click on save button to save this setting on your project. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-publishing-validatesettings_03.png[/img] [b]Step 3: Publishing[/b] You are done with the server validation part, let us now start publishing website. Click on Publish. This will perform compatibility check with the server to see you web application is compatible with the server / web hosting account. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-publish-compatibilitysettings_03.png[/img] Accept and proceed with compatibility check with the server. WebMatrix will upload few sample / test files to the server to check the server requirement for your website. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-compatibilitychecking-uploadingfiles_03.png[/img] You would then see WebMatrix validating the server requirement, for this MoviesDB website you would need ASP.NET setup and support for simple HTML on server. It is validated and WebMatrix found them available on our Web hosting account. Click on Continue to proceed with deployment. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-publish-compatibility-results_03.png[/img] The Publish Preview dialog box appears. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-publish-preview_03.png[/img] Review the list of files and databases and make changes if necessary. For example, you might want to clear check boxes under Changed Files to exclude some files. [quote]Important: If you're publishing a database and the database already exists in the hosting provider's site, whatever is in that database will be overwritten. [/quote] Click Continue. WebMatrix publishes the website, showing status messages in the navigation bar at the bottom of the screen. The publishing process is done in the background, which means you can continue to work in WebMatrix while it is publishing. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-publishing-yourwebhosting_02.png[/img] In the notification bar at the bottom of the screen, you can click Log to see a detailed log of the publishing activity. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-deployment-log_03.png[/img] If you see something in the log that catches your attention during the publishing process, you can click Pause Scroll to go back and examine what you saw more carefully. When the publishing process is complete, the notification bar lets you know: [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-publishing-complete_02.png[/img] [b]Step 4: Review Site[/b] To verify that publishing was successful, browse to the site. If you published a database, make sure you try any pages that display data from the database. [quote]Note: If your site has a Web.config file, the copy on your web hosting account on web server might look slightly different. For example, if you published a SQL Server database, it will have the our web hosting SQL connection string value so that the published site will use the database at the hosting provider.[/quote] [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-review-websites_03.png[/img] In the next Topic we will show how to download [b]DotNetNuke[/b] using WebMatrix Gallery, and set them up locally, test and then deploy remotely on a server. [b]To run the steps in this procedure you must be running Windows XP SP3 or a later version of Windows. You'll also need to have WebMatrix installed. Please see here for installation WebMatrix [url=http://www.hostasp.net/forums/question/getting-started-with-webmatrix-part-1-webmatrix-installation.html]Installing WebMatrix[/url][/b] [b]Just follow the simple steps below for setting up your website and WebMatrix IDE[/b] [b]How it works: [/b] After you create a website locally, you would typically publish the website to your [b]Web hosting Space[/b]. Publishing your website involves following steps: Step 1: Preparing your Web Hosting Space Step 2: Configuring WebMatrix for Publishing Step 3: Publishing Step 4: Review Site [b]Web hosting Space[/b] When you publish your website, you copy files from your computer to a web server that's maintained by HostASP. That can be done by two ways Web Deploy method and FTP method. We support both Web Deploy and FTP method to automate the publishing process. FTP method lets you publish Microsoft SQL Server Compact 4.0 databases, but not databases that use SQL Server or SQL Server Express. Among the publishing options is SSL, which stands for secure sockets layer. (SSL is what you're using if you access a Web site using https:// instead of http://.) SSL encrypts the information going between the browser and server, and is a good idea for pages that involve private information like passwords and credit-card numbers. Setting up SSL requires extra steps like purchasing and configuring a certificate that's used for encryption. At HostASP, we offer Free SSL publishing URL when you do Web Deploy all your files are encrypted, safely and securely transferred to your HostASP Web hosting account. [b]Databases[/b] If you're using SQL Server Compact as your database, the data is stored in an .sdf file. When you publish the database, WebMatrix copies not only the .sdf file but also the database program itself to the web server. This ensures that the published site will work even if SQL Server Compact isn't already installed on the web server. If you're using a SQL Server or MySQL database, WebMatrix publishes the database by creating scripts that run in a database that has been created for you by your hosting provider. These scripts create database tables and insert data into them in order to replicate the structure and data that you have in the database on your computer. If you're using a SQL Server Compact database and want to publish to a SQL Server database, you must migrate the data to SQL Server before publishing. For instructions, see Migrate a database to SQL Server. You might want to do this to take advantage of SQL Server features such as stored procedures and its additional capabilities, such as handling more than 256 concurrent connections or creating databases larger than 4 gigabytes In this session we will see how to deploy our movies website, we earlier saw in other topic how to develop a simple movies website using MS SQL Compact DB. We will now deploy this website to our web hosting account on domain name http://www.yourwebhosting.in/ [b]Step 1: Preparing your Web Hosting Space[/b] Very first step that you would need to do is prepare your website for web publishing on our web hosting space. Login to your web hosting control panel, open website properties and setup a web deploy account ( this will create a windows NT account ). Use this account to configure the Publishing XML. This will enable your website for remote Website publishing. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-enabling-web-deployment_03.png[/img] To setup an web deploy account - Provide user name and password for your Web publishing and click on enable button. This will enable your web deployment account for web publishing. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-webdeploy-account_03.png[/img] You could see Web publishing is now enabled on your account. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-webpublishing-enabled_03.png[/img] You do have option to configure Web publishing XML - If you have multiple databases on your web hosting account and based on your application database type, you could choose a MS SQL database or My SQL database, The database user whom permission is granted and then the FTP account. Select your choice and rebuild the publishing XML. After rebuild is complete your publishing XML is saved and can be downloaded onto your local machine for import to WebMatrix. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-publishingsettings_03.png[/img] [b]Step 2: Configuring WebMatrix for Publishing[/b] Now that we configured our web hosting account for Web publishing, let us download the publishing XML file. The file that you download will have .publishsettings as extension , here in our case we will have yourwebhosting.in.publishsettings. Find below the structure of publishing XML file. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-publishingxml_02.png[/img] Now go to WebMatrix IDE on Top Menu -> Publish -> Settings and Import the file by clicking on "Import Publish Settings" this would default all the required fields with server information that you have on Publishing XML. Publishing XML supports both FTP method and Web deploy method. Let us see deployment using Web Deploy method. You would also notice that server name with https prefix, we have setup this URL with SSL certificate so that you can safely deploy your website over internet. One more thing you would notice is "Remote connection string not required" against this Movies DB it is because this MoviesDB application uses integrated SQL Compact Databases .SDF and so you would not require an explict or external MS SQL Server access on your hosting account, if your web application uses MSSQL or MySQL server then it would be filled in with information by default from Publishing XML. Ok, now that you have imported the settings lets Click on validate settings to connect to the server. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-import-publishingxml_03.png[/img] You have done your validation part and is successful, the information you have got on Publish setting is fine and able to connect to server. Click on save button to save this setting on your project. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-publishing-validatesettings_03.png[/img] [b]Step 3: Publishing[/b] You are done with the server validation part, let us now start publishing website. Click on Publish. This will perform compatibility check with the server to see you web application is compatible with the server / web hosting account. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-publish-compatibilitysettings_03.png[/img] Accept and proceed with compatibility check with the server. WebMatrix will upload few sample / test files to the server to check the server requirement for your website. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-compatibilitychecking-uploadingfiles_03.png[/img] You would then see WebMatrix validating the server requirement, for this MoviesDB website you would need ASP.NET setup and support for simple HTML on server. It is validated and WebMatrix found them available on our Web hosting account. Click on Continue to proceed with deployment. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-publish-compatibility-results_03.png[/img] The Publish Preview dialog box appears. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-publish-preview_03.png[/img] Review the list of files and databases and make changes if necessary. For example, you might want to clear check boxes under Changed Files to exclude some files. [quote]Important: If you're publishing a database and the database already exists in the hosting provider's site, whatever is in that database will be overwritten. [/quote] Click Continue. WebMatrix publishes the website, showing status messages in the navigation bar at the bottom of the screen. The publishing process is done in the background, which means you can continue to work in WebMatrix while it is publishing. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-publishing-yourwebhosting_02.png[/img] In the notification bar at the bottom of the screen, you can click Log to see a detailed log of the publishing activity. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-deployment-log_03.png[/img] If you see something in the log that catches your attention during the publishing process, you can click Pause Scroll to go back and examine what you saw more carefully. When the publishing process is complete, the notification bar lets you know: [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-publishing-complete_02.png[/img] [b]Step 4: Review Site[/b] To verify that publishing was successful, browse to the site. If you published a database, make sure you try any pages that display data from the database. [quote]Note: If your site has a Web.config file, the copy on your web hosting account on web server might look slightly different. For example, if you published a SQL Server database, it will have the our web hosting SQL connection string value so that the published site will use the database at the hosting provider.[/quote] [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-review-websites_03.png[/img] In the next Topic we will show how to download [b]DotNetNuke[/b] using WebMatrix Gallery, and set them up locally, test and then deploy remotely on a server. Getting Started with WebMatrix - Part-1 WebMatrix Installation 2011-09-22T03:23:35+00:00 2011-09-22T03:23:35+00:00 https://www.hostasp.net/forums/question/getting-started-with-webmatrix-part-1-webmatrix-installation.html Administrator sandilyan@hotmail.com [b]WebMatrix is a free, lightweight set of web development tools that provides the easiest way to build websites. It includes IIS Express (a development web server), ASP.NET (a web framework), and SQL Server Compact (an embedded database). It also includes a simple tool that streamlines website development and makes it easy to start websites from popular open source apps. The skills and code you develop with WebMatrix transition seamlessly to Visual Studio and SQL Server.[/b] The web pages that you create using WebMatrix can be dynamic—that is, they can alter their content or style based on user input or on other information, such as database information. To program dynamic Web pages, you use ASP.NET with the Razor syntax and with the C# or Visual Basic programming languages. If you already have programming tools that you like, you can try the WebMatrix tools or you can use your own tools to create websites that use ASP.NET. This topic shows you how WebMatrix makes it easy to get started creating websites and dynamic web pages. [b]Installing WebMatrix[/b] To install WebMatrix, you can use Microsoft’s Web Platform Installer (WPI), which is a free application that makes it easy to install and configure web-related technologies. If you don't already have the Web Platform Installer, download it from the following URL: http://go.microsoft.com/fwlink/?LinkID=205867 [img]http://www.hostasp.net/articles/images/webmatrix/installing-webmatrix_03.png[/img] Run the Web Platform Installer WPI, and then click install button to install WebMatrix. This would install WebMatrix and all its dependency components such as .NET Framework, IIS Express, SQL server Compact and Tools, ASP Web pages and language packs, and other required for setting up of WebMatrix development environment on Client machine. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-installation-complete_03.png[/img] After the installation is complete you would see the list of components that are installed on your machine along with WebMatrix for setting up development environment. [b]Running WebMatrix[/b] Direct access to WebMatrix is available as shortcut from Microsoft WebMatrix folder in your Start menu. Select the Microsoft WebMatrix icon and you'll launch WebMatrix. You'll see this Welcome screen: [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix_02.png[/img] The options on the Welcome screen support these ways of building a web site: [b]- Site From Web Gallery:[/b] The Web Application Gallery (WAG) is a collection of open source web applications written using a variety of technologies, including PHP and ASP.NET. Applications in the Web Application Gallery give you a great head start – where someone else has written a lot of the code for you and is allowing you to freely use it on your site. WebMatrix makes the process of downloading, installing and configuring this code easy. [b]- Site From Template:[/b] If you prefer to write your own code, instead of using the open source applications from the WAG, then this option gives you a great way to start with either an empty web site, or a number of simple template sites that you can customize and change. [b]- Site From Folder:[/b] If you have a collection of web files already and you want to edit and run them on a web server quickly, WebMatrix will allow you to do so, simply by pointing it at that folder. [b]Creating web sites with WebMatrix[/b] There are two main ways that developers would like to create web sites. The first is to use an Open Source web application (using the Site From Web Gallery option) where folks in the community have done a lot of the hard work for you. Perhaps you've heard of WordPress, Drupal, Joomla, Umbraco, DotNetNuke or Orchard? WebMatrix makes the process of downloading their code and configuring your server to run it on a simple and seamless process, regardless of the technology they're written in. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-quickstart-webgallery_03.png[/img] The other, is of course, to write everything yourself (using the Site from Template option). WebMatrix ships with the ASP.NET Web Pages framework which provides a very simple, yet very powerful way of creating dynamic web sites that use databases, and can integrate social frameworks, media and more. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-sitetemplates_03.png[/img] In next part you'll see how to use the ASP.NET Web Pages and integrated 'Razor' framework to see how easy it is to create a simple web site that provides a database of your favorite movies. You'll see how to get the site to work on all browsers, how to create web pages, how to make those pages dynamic by rendering data from a database, and lots more. [b]WebMatrix is a free, lightweight set of web development tools that provides the easiest way to build websites. It includes IIS Express (a development web server), ASP.NET (a web framework), and SQL Server Compact (an embedded database). It also includes a simple tool that streamlines website development and makes it easy to start websites from popular open source apps. The skills and code you develop with WebMatrix transition seamlessly to Visual Studio and SQL Server.[/b] The web pages that you create using WebMatrix can be dynamic—that is, they can alter their content or style based on user input or on other information, such as database information. To program dynamic Web pages, you use ASP.NET with the Razor syntax and with the C# or Visual Basic programming languages. If you already have programming tools that you like, you can try the WebMatrix tools or you can use your own tools to create websites that use ASP.NET. This topic shows you how WebMatrix makes it easy to get started creating websites and dynamic web pages. [b]Installing WebMatrix[/b] To install WebMatrix, you can use Microsoft’s Web Platform Installer (WPI), which is a free application that makes it easy to install and configure web-related technologies. If you don't already have the Web Platform Installer, download it from the following URL: http://go.microsoft.com/fwlink/?LinkID=205867 [img]http://www.hostasp.net/articles/images/webmatrix/installing-webmatrix_03.png[/img] Run the Web Platform Installer WPI, and then click install button to install WebMatrix. This would install WebMatrix and all its dependency components such as .NET Framework, IIS Express, SQL server Compact and Tools, ASP Web pages and language packs, and other required for setting up of WebMatrix development environment on Client machine. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-installation-complete_03.png[/img] After the installation is complete you would see the list of components that are installed on your machine along with WebMatrix for setting up development environment. [b]Running WebMatrix[/b] Direct access to WebMatrix is available as shortcut from Microsoft WebMatrix folder in your Start menu. Select the Microsoft WebMatrix icon and you'll launch WebMatrix. You'll see this Welcome screen: [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix_02.png[/img] The options on the Welcome screen support these ways of building a web site: [b]- Site From Web Gallery:[/b] The Web Application Gallery (WAG) is a collection of open source web applications written using a variety of technologies, including PHP and ASP.NET. Applications in the Web Application Gallery give you a great head start – where someone else has written a lot of the code for you and is allowing you to freely use it on your site. WebMatrix makes the process of downloading, installing and configuring this code easy. [b]- Site From Template:[/b] If you prefer to write your own code, instead of using the open source applications from the WAG, then this option gives you a great way to start with either an empty web site, or a number of simple template sites that you can customize and change. [b]- Site From Folder:[/b] If you have a collection of web files already and you want to edit and run them on a web server quickly, WebMatrix will allow you to do so, simply by pointing it at that folder. [b]Creating web sites with WebMatrix[/b] There are two main ways that developers would like to create web sites. The first is to use an Open Source web application (using the Site From Web Gallery option) where folks in the community have done a lot of the hard work for you. Perhaps you've heard of WordPress, Drupal, Joomla, Umbraco, DotNetNuke or Orchard? WebMatrix makes the process of downloading their code and configuring your server to run it on a simple and seamless process, regardless of the technology they're written in. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-quickstart-webgallery_03.png[/img] The other, is of course, to write everything yourself (using the Site from Template option). WebMatrix ships with the ASP.NET Web Pages framework which provides a very simple, yet very powerful way of creating dynamic web sites that use databases, and can integrate social frameworks, media and more. [img]http://www.hostasp.net/articles/images/webmatrix/webmatrix-sitetemplates_03.png[/img] In next part you'll see how to use the ASP.NET Web Pages and integrated 'Razor' framework to see how easy it is to create a simple web site that provides a database of your favorite movies. You'll see how to get the site to work on all browsers, how to create web pages, how to make those pages dynamic by rendering data from a database, and lots more.