Windows 2012 Hosting - MVC 6 and SQL 2014 BLOG

Tutorial and Articles about Windows Hosting, SQL Hosting, MVC Hosting, and Silverlight Hosting

Press Release - ASPHostPortal.com Proudly Launches osCommerce 3.0.2 Hosting

clock January 30, 2014 10:10 by author Mike

ASPHostPortal.com is a premiere web hosting company that specializes in Windows and ASP.NET-based hosting with innovative technology  solutions, proudly announced the best osCommerce 3.0.2 hosting service with a combination of affordable price, high customer  satisfaction rate and commendable quality in all ASP.NET and Windows web hosting plans.

osCommerce 3.0.2 are made to showcase the new features being worked on and to generalize a version specific for testing to help fix  and improve subsequent alpha releases for a final, stable, secure, and production ready 3.0.2 releases. The osCommerce solution offers  great flexibility and empowers even amateur webmasters to develop highly competitive ecommerce websites.

Until recently, the cost involved in hiring a web development company to develop a similar ecommerce web site was prohibiting several  small businesses from selling on-line. The osCommerce solution is one of the best fruits of the open source community and which poses  a serious challenge to other similar commercial software products.


Installation for this software can be performed easily from within the web hosting control panel, even by customers with poor  programming experience. The installation process takes up to a minute to perform, thus enabling customers to deploy an entire  ecommerce storefront for their business within a few clicks of the mouse.

ASPHostPortal.com
is the among the few top web hosting company that tested and offer ASP.NET hosting plan that compliance with  osCommerce 3.0.2 hosting. There are several companies out there that offer e-Commerce hosting plan but at ASPHostPortal.com, we provide quality e-Commerce  hosting plan at affordable prices that will not only keep your operating costs low but also help you to maximize your profits.

ASPHostPortal.com
development teams have fully tested and deployed the latest osCommerce 3.0.2 in hosting control panel systems.  Clients can install and use osCommerce 3.0.2 hosting with few clicks of installation steps. For more information about this topics or  have any enquiries related to osCommerce hosting, please visit http://www.asphostportal.com/osCommerce-Hosting.

About the Company
ASPHostPortal.com is a hosting company that best support in Windows and ASP.NET-based hosting. Services include shared hosting,  reseller hosting, and sharepoint hosting, with specialty in ASP.NET, SQL Server, and architecting highly scalable solutions. As a  leading small to mid-sized business web hosting provider, ASPHostPortal.com strive to offer the most technologically advanced hosting  solutions available to all customers across the world. Security, reliability, and performance are at the core of hosting operations to  ensure each site and/or application hosted is highly secured and performs at optimum level.

 



ASP.NET MVC 5.1 Hosting :: ASPHostPortal.com Proudly Launches ASP.NET MVC 5.1 Hosting

clock January 28, 2014 07:57 by author Ben

ASPHostPortal.com officially launches ASP.NET MVC 5.1  hosting at affordable prices. Instant Setup, Fast and Friendly Support!

ASPHostPortal.com, a leading innovator in Windows Hosting, announces the launch of ASP.NET MVC 5.1 Hosting. The ASP.NET MVC 5.1 Framework is the latest evolution of Microsoft’s ASP.NET web platform. It provides a high-productivity programming model that promotes cleaner code architecture, test-driven development, and powerful extensibility, combined with all the benefits of ASP.NET.

ASP.NET MVC 5.1 contains a number of advances over previous versions, including the ability to define routes using C# attributes and the ability to override filters,Enum support in Views, Support for current Context in Unobtrusive Ajax, Filter Overrides and etc. The user experience of building MVC applications has also been substantially improved.

“Our customers have been asking us about MVC 5.1 and we are happy to deliver a hosting platform that supports all the latest in the Microsoft Web Stack.” said said Dean Thomas, Manager at ASPHostPortal.com.  "And it proves that we remain at the forefront in Microsoft technology".

Where to look for the best ASP.NET MVC 5.1 hosting service? How to know more about the different types of hosting services? Read more about it on http://www.asphostportal.com.


About ASPHostPortal.com:

ASPHostPortal.com is a hosting company that best support in Windows and ASP.NET-based hosting. Services include shared hosting, reseller hosting, and sharepoint hosting, with specialty in ASP.NET, SQL Server, and architecting highly scalable solutions. As a leading small to mid-sized business web hosting provider, ASPHostPortal.com strive to offer the most technologically advanced hosting solutions available to all customers across the world. Security, reliability, and performance are at the core of hosting operations to ensure each site and/or application hosted is highly secured and performs at optimum level.



ASPHostPortal.com Proudly Launches nopCommerce 3.2 Hosting

clock January 23, 2014 10:37 by author Mike

ASPHostPortal.com is a premiere web hosting company that specializes in Windows and ASP.NET-based hosting with innovative technology  solutions, proudly announced the best nopCommerce 3.2 hosting service with a combination of affordable price, high customer  satisfaction rate and commendable quality.

nopCommerce is an open source e-commerce solution that contains both a catalog frontend and an administration tool backend.  nopCommerce is a fully customizable shopping cart. It's stable and highly usable. From downloads to documentation, nopCommerce.com  offers a comprehensive base of information, resources, and support to the nopCommerce community. The latest version of nopCommerce is  3.2 with lots of awesome features.

The first feature that will grab the attention of every nopCommerce store owner is the new Facebook Shop. The next major functionality  that comes with nopCommerce 3.20 is its support for warehouses. What this means is that you can configure individual products to be  shipped from a specific location (warehouse). You can also configure the system to use the warehouse location when calculating the  shipping cost for the product. While we are on the nopCommerce 3.20 shipping functionality, there is another new feature worth  mentioning. Now the store owner can specify when a product will be shipped. In nopCommerce this information is referred to as delivery  date. This is useful for example when you are selling products, which are manufactured on demand.

Nopcommerce 3.2 is simply the best and most powerful open source shopping cart on the planet. It is the only open source shopping  cart application that supports both multi-sites and multi-vendors. NopCommerce is fast, easy, and fun. I definitely recommend  NopCommerce to anyone who wants to start an online business.


ASPHostPortal.com
is a popular online nopCommerce 3.2 hosting service provider with all of its hosting plans to help users to automate  and simplify website and server administration tasks such as installation and migration. There are several companies out there that offer e-Commerce hosting plan but at ASPHostPortal.com provide quality e-Commerce  hosting plan at affordable prices that will not only keep your operating costs low but also help you to maximize your profits.

nopCommerce is ASP.NET 4.0 based supporting MS SQL databases. It features an embedded graphic installer, so nopCommerce can be setup  in few minutes and run immediately. For more information about this topics or have any enquiries related to nopCommerce hosting,  please visit http://www.asphostportal.com/nopCommerce-Hosting.

About the Company
ASPHostPortal.com is a hosting company that best support in Windows and ASP.NET-based hosting. Services include shared hosting,  reseller hosting, and sharepoint hosting, with specialty in ASP.NET, SQL Server, and architecting highly scalable solutions. As a  leading small to mid-sized business web hosting provider, ASPHostPortal.com strive to offer the most technologically advanced hosting  solutions available to all customers across the world. Security, reliability, and performance are at the core of hosting operations to  ensure each site and/or application hosted is highly secured and performs at optimum level.



Free SQL Server Hosting :: How to Handle Error : 1326 Cannot connect to Database Server Error: 40 – Could not open a connection to SQL Server

clock January 21, 2014 05:19 by author Ben

If you are receiving following error:

TITLE: Connect to Server
Cannot connect to Database Server.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2008, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1326)


Now if
SQL Server can be connected perfectly from local system but can not be connected from remote system, in that case firewall of the server where SQL Server is installed can be issue.

Follow instructions of this article to fix the issue.

Go to control panel >> Firewall Settings >> Add SQL Server’s Port to Exception List.



Click Add Port and fill this :


Now try to connect to SQL Server again. It will allow you to connect to server successfully.

About the Company
ASPHostPortal.com is a hosting company that best support in Windows and ASP.NET-based hosting. Services  include shared hosting, reseller hosting, and sharepoint hosting, with specialty in ASP.NET, SQL Server,  and architecting highly scalable solutions. As a leading small to mid-sized business web hosting  provider, ASPHostPortal.com strive to offer the most technologically advanced hosting solutions available to  all customers across the world.
Come to the website to know more details.

 



Nopcommerce Hosting :: Enable SSL protection on Nopcommerce site when SSL certificate is installed.

clock January 20, 2014 16:27 by author Mike

NopCommerce is an open source e-commerce solution that is available for FREE. It is an ecommerce solution with comprehensive features that is easy to use for new online businesses, yet powerful enough for the most demanding e-commerce expert. It is secure, scalable and extendable. It has pluggable architecture that allows additional functionality and presentation elements to be dynamically added to the application at run-time.

Once you have SSL certificate installed on your Nopcommerce site, please enable it on your site with the following instructions

1.Login to your nopcommerce site admin panel, click the configuration >> Stores




2. Click "Edit" beside your nopCommerce site url




3. Check "SSL Enable", and fill your Secure URL




Press Release - ASPHostPortal.com Proudly Launches DotNetNuke (DNN) 7.2 Hosting

clock January 16, 2014 06:08 by author Mike

ASPHostPortal.com is a premiere web hosting company that specializes in Windows and ASP.NET-based  hosting with innovative technology solutions, proudly announced the best DotNetNuke (DNN) 7.2 hosting  service with a combination of affordable price, high customer satisfaction rate and commendable quality.


DotNetNuke is an open source web content management system that is built on ASP.net infrastructure and  solely has its life wire running smoothly on Microsoft platform. Furthermore, it is an open source web  content management system that started in the year 2002 by a team of developers which was headed by the  original creator Shaun Walker who happens to have bagged his certification as a certified Microsoft Most  Valuable Professional in the year 2004 and the latest version is 7.2 with lots of awesome features.

DotNetNuke (DNN) 7.2 includes a number of new features and enhancements that will benefit users and  developers alike along with a large number of bug fixes. DNN 7.2 version incorporates some of the  interesting features to elevate the existing functionality and make your site administration process a  lot easier. DNN 7.2 also allows you to install JavaScript libraries as first party extensions. Once  installed your module or skin can request that JavaScript library and the platform will automatically  add the library into the page. The API mirrors the one used for jQuery and JQuery UI making it very easy  to use.

Some benefits that the DotNetNuke content management system includes are greater site consistency,  improved site navigation, streamlined authoring process, faster turnaround time for new pages and  changes, increased site flexibility, support for decentralised authoring, increased security, reduced  duplication of information, greater capacity for growth, and reduced site maintenance costs. DotNetNuke is the best CMS (content management system) for businesses and  is easier to create and manage with ASPHostPortal.com.

ASPHostPortal.com is a popular online DotNetNuke (DNN) 7.2 hosting service provider with all of its  hosting plans to help users to automate and simplify website and server administration tasks such as  installation and migration. For more information about this topics or have any enquiries related to DotNetNuke (DNN) 7.2 hosting,  please visit http://www.asphostportal.com/DotNetNuke-Hosting

About the Company
ASPHostPortal.com is a hosting company that best support in Windows and ASP.NET-based hosting. Services  include shared hosting, reseller hosting, and sharepoint hosting, with specialty in ASP.NET, SQL Server,  and architecting highly scalable solutions. As a leading small to mid-sized business web hosting  provider, ASPHostPortal.com strive to offer the most technologically advanced hosting solutions available to  all customers across the world. Security, reliability, and performance are at the core of hosting  operations to ensure each site and/or application hosted is highly secured and performs at optimum  level.



.NET 4.5.1 Hosting - ASPHostPortal.com :: Confirmation Before Deleting Data in ASP.NET Application

clock January 13, 2014 05:31 by author Ben

It is always great idea to ask before delete e.g. sometimes by mistake you can press the delete button that can delete important records from your website so its always suggested that there should be confirmation to delete before deletion of any record.

Allowing a user to delete a row from a database table using a Datagrid is handy, but dangerous if you just delete immediately upon pressing a button. A better way is to pop up a dialog asking the user to confirm his or her desire to delete the record. To do this requires a little javascript, as well as a change in the usual way of placing a delete button (linkbutton or pushbutton) in the datagrid. Following the Visual Studio .NET way, a ButtonColumn gets added to the datagrid. The ButtonColumn, however, has no ID property and we need one in order to associate the javascript function with the button. We can get around this by adding a template column with a button rather than adding a ButtonColumn.

We add the template column as shown below in the file, ConfirmDelDG.aspx. There are several things to take note of in the .aspx file. We'll take them in order of appearance. First, between the <head>...</head> tags is our javascript function named confirm_delete. This simply pops up a confirmation dialog asking the user if he is sure he wants to delete the record. If OK is clicked, the delete happens. If Cancel is clicked, nothing happens.

<%@ Page Language="vb" Src="ConfirmDelDG.aspx.vb" Inherits="ConfirmDelDG" AutoEventWireup="false" %>
 <html>
 <head>
 <title>ConfirmDelDG</title>
 <meta name="GENERATOR" content="Microsoft Visual Studio .NET 4.5.1">
 <meta name="CODE_LANGUAGE" content="Visual Basic .NET 4.5.1">
 <meta name=vs_defaultClientScript content="JavaScript">
 <meta name=vs_targetSchema content="">
 <script language="javascript">
 function confirm_delete()
 {
   if (confirm("Are you sure you want to delete this item?")==true)
     return true;
   else
     return false;
 }
 </script>
 </head>
 <body>
 <form method="post" runat="server" ID="Form1"><br><br>
 <asp:DataGrid id="dtgProducts" runat="server"
               CellPadding="6" AutoGenerateColumns="False"
               OnDeleteCommand="Delete_Row" BorderColor="#999999"
               BorderStyle="None" BorderWidth="1px"
               BackColor="White" GridLines="Vertical">
   <AlternatingItemStyle BackColor="#DCDCDC" />
   <ItemStyle ForeColor="Black" BackColor="#EEEEEE" />
   <HeaderStyle Font-Bold="True" ForeColor="White" BackColor="#000084" />
   <Columns>
     <asp:BoundColumn Visible="False" DataField="ProductID" ReadOnly="True" />
     <asp:BoundColumn DataField="ProductName" ReadOnly="True" HeaderText="Name" />
     <asp:BoundColumn DataField="UnitPrice" HeaderText="Price" DataFormatString="{0:c}"
                      ItemStyle-HorizontalAlign="Right" />
     <asp:TemplateColumn>
     <ItemTemplate>
     <asp:Button id="btnDelete" runat="server" Text="Delete" CommandName="Delete" />
     </ItemTemplate>
     </asp:TemplateColumn>
   </Columns>
 </asp:DataGrid>
 </form>
 </body>
 </html>


And now for the codebehind file ConfirmDelDG.aspx.vb. We will take a look at it in several sections for ease of discussion and hopefully easier reading. This first section just contains the usual declarations, the Page_Load subroutine and a BindTheGrid subroutine which creates a DataSet and binds the grid. Nothing out of the ordinary here.

 Imports System.Data
 Imports System.Data.SqlClient
 Imports System.Configuration
 Imports System.Web.UI.WebControls
 
 Public Class ConfirmDelDG
   Inherits System.Web.UI.Page
 
   Protected WithEvents dtgProducts As System.Web.UI.WebControls.DataGrid
   Private strConnection As String = ConfigurationSettings.AppSettings("NorthwindConnection")
   Private strSql As String = "SELECT ProductID, ProductName, UnitPrice " _
                            & "FROM Products WHERE CategoryID = 1"
   Private objConn As SqlConnection
 
   Private Sub Page_Load(ByVal Sender As System.Object, ByVal E As System.EventArgs) Handles MyBase.Load
     If Not IsPostBack Then
       BindTheGrid()
     End If
   End Sub
 
   Private Sub BindTheGrid()
     Connect()
     Dim adapter As New SqlDataAdapter(strSql, objConn)
     Dim ds As New DataSet()
     adapter.Fill(ds, "Products")
     Disconnect()
 
     dtgProducts.DataSource = ds.Tables("Products")
     dtgProducts.DataBind()
   End Sub

The next subroutine, dtgProducts_ItemDataBound, is the secret to making our confirmation dialog work. We must add an OnClick event handler to each delete button on the datagrid. We can make use of ItemDataBound to do this. We dimension a variable ("btn") as type Button. We then check that ItemType is type Item or type AlternatingItem. We then use the FindControl method to find a control of type Button with an ID of "btnDelete" (the ID we gave the delete button on the aspx page). Having an ID such as "btnDelete" is why we had to use a TemplateColumn rather than a ButtonColumn which has no ID property. Once we find the button, we use Attributes.Add to call our javascript routine confirm_delete().

Private Sub dtgProducts_ItemDataBound (ByVal sender As System.Object, _
     ByVal e As DataGridItemEventArgs) Handles dtgProducts.ItemDataBound
     Dim btn As Button
     If e.Item.ItemType = ListItemType.Item or e.Item.ItemType = ListItemType.AlternatingItem Then
       btn = CType(e.Item.Cells(0).FindControl("btnDelete"), Button)
       btn.Attributes.Add("onclick", "return confirm_delete();")
     End If
   End Sub


This last section, Delete_Row(), is where the row is actually deleted. The method presented here is out of the ordinary for me in that I usually use SQL to delete the record. The technique presented here, however, first marks the row as deleted in the Dataset, and then, in a commented out section, uses the update method to actually delete the row from the database table. Because this is being run from my hosting provider's Northwind database I cannot actually delete rows from the Products table. If you run the example program you may notice seemingly odd behaviour. If you delete a row, it will seem to be deleted (it will disappear from the grid). But if you then delete another row, it will disappear, but the first row you deleted will reappear. This is normal behavior since I am not really deleting the rows from the database, only from the dataset. If you uncomment out the lines where noted, the deletes will actually occur in the database also.

Public Sub Delete_Row(ByVal Sender As Object, ByVal E As DataGridCommandEventArgs)
     ' Retrieve the ID of the product to be deleted
     Dim ProductID As system.Int32 = System.Convert.ToInt32(E.Item.Cells(0).Text)
     dtgProducts.EditItemIndex = -1
     ' Create and load a DataSet
     Connect()
     Dim adapter As New SqlDataAdapter(strSql, objConn)
     Dim ds As New DataSet()
     adapter.Fill(ds, "Products")
     Disconnect()
     ' Mark the product as Deleted in the DataSet
     Dim tbl As DataTable = ds.Tables("Products")
     tbl.PrimaryKey = New DataColumn() _
                     { _
                       tbl.Columns("ProductID") _
                     }
     Dim row As DataRow = tbl.Rows.Find(ProductID)
     row.Delete()
     ' Reconnect the DataSet and delete the row from the database
     '-----------------------------------------------------------
     ' Following section commented out for demonstration purposes
     'Dim cb As New SqlCommandBuilder(adapter)
     'Connect()
     'adapter.Update(ds, "Products")
     'Disconnect()
     '-----------------------------------------------------------
     ' Display remaining rows in the DataGrid
     dtgProducts.DataSource = ds.Tables("Products")
     dtgProducts.DataBind()
   End Sub
 End Class

That's about Confirmation Before Deleting Data in ASP.NET Application. For more information please visit ASPHostPortal.com.



 



Visual Studio 2013 Hosting - ASPHostPortal.com :: How Visual Studio 2013's Editor Eliminates Parentheses Pain

clock January 7, 2014 10:02 by author Mike

Visual Studio 2013 is New versions of Visual Studio usually coincide with updates to the .NET Framework and one of our biggest releases yet. It comes purpose-built to help you thrive in an environment in which ideas are at a premium and speed is of the essence.

With Visual Studio 2013, even the little improvements can make a big difference in your work. Keep up your rhythm going with automatic bracket completion and keyboard shortcuts for moving lines and blocks of code.

Visual Studio 2013 has been out in preview since Microsoft’s BUILD conference last month. One simple but useful feature that has been added? Whenever you type in an opening parentheses (whether it’s curly or a regular bracket), its matching counterpart is automatically added.

As the Visual Studio blog points out, this option already existed in the Visual Studio Productivity Power Tools add-on, but is now part of the core product. Called ‘Auto Brace Completion’, it is language sensitive, and covers more than parentheses; in C++, for instance, it adds semi-colons for class types.

Hit the blog post for details of some of the other auto-complete features built into Visual Studio 2013, including a handy 'Peek Definition' feature for viewing definitions without leaving your code. Right now that’s a view-only feature, but Microsoft says it is working on adding edit options for the final release.



Visual Studio LightSwitch 2013 :: ASPHostPortal.com-Tips LightSwitch Performance Win in Visual Studio 2013 : Bandwidth Savings

clock January 5, 2014 15:17 by author Robert

The easiest way to demonstrate this is to create a simple LightSwitch application, attach to a database with data, create a simple screen, and then “launch” our app. We can then use Internet Explorer’s F12 Debugging Tools to look at the size of the HTTP requests and response.I’m going to walk through making a simple LightSwitch project. If you aren’t familiar with making a LightSwitch project, please check out the very short tutorial on our Developer Center

Launch Visual Studio and navigate to File –> Create New Project and select a LightSwitch HTML Application (theLightSwitch Desktop Application uses a Silverlight Client, which has actually already been using the JSON Light format since Visual Studio 2012 Update 2).
After you’ve done this, go ahead and click “Attach to External Database”. Lets attach to some database that already has data in it (I’m attaching to a Northwind SQL Database, but if you don’t have that available, you can attach to the Northwind ODATA Service). Select which tables you want to import and click “Finish”.

We need some way to display the data, so let’s make a very simple screen around one of our database tables.
Right click on the LightSwith HTML Project, and select “Add Screen…”
Select the “Browse Data Screen” template, and for the Screen Data just select some table that you know has data (I’m using a Customers table).
Now we can launch our app and use Internet Explorer’s F12 Developer Tools to look at a particular HTTP request.

Press F5 to launch the LightSwitch HTML app
When IE launches, press F12 to open the Developer Tools
Select the “Network” tab and then click the “Start Capturing” button. This will start “recording” all HTTP traffic.

Now “refresh” your browser. You should see a bunch of HTTP requests appearing.  After the browser finishes refreshing, select the last HTTP request in the list (it should be last or close to last). It will look something like this:

/DBData.svc/MyCustomers?$top=45    GET    200    application/json    12.60 KB    0.56

I chose this request because it is the actual request to retrieve data from the Server and pull it back to the Client. So this request, and any HTTP GET/READ request like this, are the ones where we will see the HTML Client using the new JSON Light format
In English, what this request shows, is that I requested the first 45 records from my entity, and that the response came back in a JSON format.  But most important, the response size was 12.60KB and it took 0.56 seconds.
To be sure that we are using the JSON Light format, we can drill down into this a little more.  Just double click on the request, select the Response Headers tab, and look at the Content-Type header.

What this shows is that our HTTP response was returned in a JSON format called “minimalmetadata” (another name for JSON Light).
(The F12 Developer Tools are pretty powerful, definitely encourage you to read up more on it if you like - IE F12 Developer Tools).

 

 



About ASPHostPortal.com

We’re a company that works differently to most. Value is what we output and help our customers achieve, not how much money we put in the bank. It’s not because we are altruistic. It’s based on an even simpler principle. "Do good things, and good things will come to you".

Success for us is something that is continually experienced, not something that is reached. For us it is all about the experience – more than the journey. Life is a continual experience. We see the Internet as being an incredible amplifier to the experience of life for all of us. It can help humanity come together to explode in knowledge exploration and discussion. It is continual enlightenment of new ideas, experiences, and passions


Author Link


Corporate Address (Location)

ASPHostPortal
170 W 56th Street, Suite 121
New York, NY 10019
United States

Sign in