Use An Area In ASP.NET Core

CheapASPNETHostingReview.com | Best and cheap ASP.NET Core hosting. In order to include an Area in an ASP.NET Core app, first we need to include a conventional route in the Startup.cs file (It’s best to place it before any non-area route).

In Startup.cs, configure the method.

app.UseMvc(routes =&gt;  
{  
    routes.MapRoute("areaRoute", "{area:exists}/{controller=Admin}/{action=Index}/{id?}");  
    routes.MapRoute(name: "default", template: "{controller=Home}/{action=Index}/{id?}");  
});

app.UseMvc(routes =>

{

routes.MapRoute("areaRoute", "{area:exists}/{controller=Admin}/{action=Index}/{id?}");

routes.MapRoute(name: "default", template: "{controller=Home}/{action=Index}/{id?}");

});

Then, make a folder named Areas in the app root and make another directory named Admin inside the former. Inside the admin folder, create the following folders (ViewComponent is optional).

Now, we will create a Controller inside the Controllers folder named AdminController.

Now, in order for that to work, you’ll need to create Views for all actions that return one. The hierarchy for Views is just like what you have in a non-area Views folder.

Question – What if I want to have another Controller inside my Area?

Answer

Just add another Controller beside AdminController and make sure the routes are like the following,

[Area("Admin")]  
[Route("admin/[controller]")]  
public class ProductsController: Controller {  
    publicProductsController() {  
            //  
        }  
        [Route("{page:int?}")]  
    publicIActionResult Index() {  
        returnView();  
    }  
}

[Area("Admin")]

[Route("admin/[controller]")]

public class ProductsController: Controller {

publicProductsController() {

}

[Route("{page:int?}")]

publicIActionResult Index() {

returnView();

}

The important part is [Route(“admin/[controller]”)]. With that, you can keep the style of routing to admin /controller/ action/.

How Using Microsoft Enterprise Library in ASP.NET

CheapASPNETHostingReview.com | Best and cheap ASP.NET hosting. In this tutorial we will show you how to using Microsoft Enterprise Library is a collection of reusable software components used for logging, validation, data access, exception handling etc.

Here I am describing how to use Microsoft Enterprise Library for data access.

Step 1: First download the project from http://entlib.codeplex.com/ URL.
Step 2: Now extract the project to get

Microsoft.Practices.EnterpriseLibrary.Common.dll
Microsoft.Practices.EnterpriseLibrary.Configuration.Design.dll
Microsoft.Practices.EnterpriseLibrary.Data.dll
Microsoft.Practices.ObjectBuilder.dll

Microsoft.Practices.EnterpriseLibrary.Common.dll

Microsoft.Practices.EnterpriseLibrary.Configuration.Design.dll

Microsoft.Practices.EnterpriseLibrary.Data.dll

Microsoft.Practices.ObjectBuilder.dll

And give reference in the Bin directory by Right click on Bin -> Add Reference -> then give the path of these 4 dlls. Then

Step 3: Modification in the web.config for Connection String.

&lt;add name="ASPHostPortalConnection" providerName="System.Data.SqlClient" connectionString="DataSource=ASPHostPortalSQLEXPRESS;Initial Catalog=ASPHostPortal;User ID=sa;Password=admintest;Min Pool Size=10;Max Pool Size=100;Connect Timeout=100"/&gt;

1	<add name="ASPHostPortalConnection" providerName="System.Data.SqlClient" connectionString="DataSource=ASPHostPortalSQLEXPRESS;Initial Catalog=ASPHostPortal;User ID=sa;Password=admintest;Min Pool Size=10;Max Pool Size=100;Connect Timeout=100"/>

Give the connection string as above where Datasource is your data source name, Initial Catalog is your database name and User ID and Password as in your sql server.

Step 4:

Now it is time to write the code.
Write the below 2 lines in the using block.

using System.Data.Common;
using Microsoft.Practices.EnterpriseLibrary.Data;

1 2	using System.Data.Common; using Microsoft.Practices.EnterpriseLibrary.Data;

Here I am writting some examples how to work on:

public DataTable Read()
    {
        try
        {
            Database db = DatabaseFactory.CreateDatabase("ASPHostPortalConnection");
            DbCommand dbCommand = db.GetStoredProcCommand("[Topics_Return]");
            DataSet dataSet = db.ExecuteDataSet(dbCommand);
            return dataSet.Tables[0];
        }
        catch
        {
            return null;
        }
    }

public DataTable Read()

{

try

{

Database db = DatabaseFactory.CreateDatabase("ASPHostPortalConnection");

DbCommand dbCommand = db.GetStoredProcCommand("[Topics_Return]");

DataSet dataSet = db.ExecuteDataSet(dbCommand);

return dataSet.Tables[0];

}

catch

{

return null;

}

The above code is a sample that will return a dataset. Here Fewlines4bijuConnection is the connection name and Topics_Return is the stored procedure name that is nothing but a Select statement.
But if the stored procedure is taking parameter then the code will be like:

public int Save()
    {
        Database db = DatabaseFactory.CreateDatabase("ASPHostPortalConnection");
        DbCommand dbCommand = db.GetStoredProcCommand("Topics_Save");

        db.AddInParameter(dbCommand, "@Subject", DbType.AnsiString, "Here is the subject");
        db.AddInParameter(dbCommand, "@Description", DbType.AnsiString, "Here is the Descriptiont");      
        db.AddInParameter(dbCommand, "@PostedBy", DbType.Int32, 4);       
        db.AddOutParameter(dbCommand, "@Status", DbType.AnsiString, 255);
        try
        {
            db.ExecuteNonQuery(dbCommand);
            return Convert.ToInt32(db.GetParameterValue(dbCommand, "Status"));
        }
        catch
        {
            return 0;
        }
    }

public int Save()

{

Database db = DatabaseFactory.CreateDatabase("ASPHostPortalConnection");

DbCommand dbCommand = db.GetStoredProcCommand("Topics_Save");

db.AddInParameter(dbCommand, "@Subject", DbType.AnsiString, "Here is the subject");

db.AddInParameter(dbCommand, "@Description", DbType.AnsiString, "Here is the Descriptiont");

db.AddInParameter(dbCommand, "@PostedBy", DbType.Int32, 4);

db.AddOutParameter(dbCommand, "@Status", DbType.AnsiString, 255);

try

{

db.ExecuteNonQuery(dbCommand);

return Convert.ToInt32(db.GetParameterValue(dbCommand, "Status"));

}

catch

{

return 0;

}

As the code explained above ASPHostPortal Connection is the connection name and Topics_Save is the stored procedure name that is taking 3 (Subject,Description,PostedBy) input parameters and 1(Status) output parameter.

You may give values from textbox, I am here provideing sample values like “Here is the subject”, “Here is the Descriptiont” or you may give the UserID from session, I am here giving 4. The output parameter will give you a string as defined and the code to get the value is

int returnValue=Convert.ToInt32(db.GetParameterValue(dbCommand, "Status"));

1	int returnValue=Convert.ToInt32(db.GetParameterValue(dbCommand, "Status"));

you can pass input parameter as below

db.AddInParameter(dbCommand, "@Subject", DbType.AnsiString, "Here is the subject");

1	db.AddInParameter(dbCommand, "@Subject", DbType.AnsiString, "Here is the subject");

DbType.AnsiString since Subject is of string time, you can select different values like AnsiString, DateTime from the Enum as be the parameter type.

The above code describes if you are using any stored procedure.
Below is an example that shows how to use inline SQL statements.

public DataSet GetID(string title)
    {
       DataSet ds=new DataSet();
        try
        {
            Database db = DatabaseFactory.CreateDatabase("ASPHostPortalConnection");
            DbCommand dbCommand = db.GetSqlStringCommand("Select * FROM Topics where UserID=1 and
IsDeleted=0");          
            ds= db.ExecuteDataSet(dbCommand);
           return ds;         
        }
        catch
        {
            return ds;
        }
         return ds;
    }

public DataSet GetID(string title)

{

DataSet ds=new DataSet();

try

{

Database db = DatabaseFactory.CreateDatabase("ASPHostPortalConnection");

DbCommand dbCommand = db.GetSqlStringCommand("Select * FROM Topics where UserID=1 and

IsDeleted=0");

ds= db.ExecuteDataSet(dbCommand);

return ds;

}

catch

{

return ds;

}

return ds;

}

Happy coding!

ASP.NET Tutorial – How to Export Data from SQL Server to Excel in ASP.NET using c#

CheapASPNETHostingReview.com | Best and cheap ASP.NET Hosting. Here I will explain how to export data from sql server to excel in asp.net using c# or export data from sql server database to excel in asp.net using c#.

Description:

Now I will explain to you, how to export data from sql server to excel in asp.net using c#.
Before implement this example first design one table UserInformation in your database as shown below
Once table created in database enter some dummy data to test application after that write the following code in your aspx page

Column Name	Data Type	Allow Nulls
UserId	int	Yes
UserName	varchar(50)	Yes
Location	varchar(50)	Yes

<html xmlns="http://www.w3.org/1999/xhtml">
  <head runat="server">
    <title>Export data from sql server database to excel in asp.net using c#</title>
  </head>
      <body>
      <form id="form1" runat="server">
         <div>
            <asp:Button ID="btnExport" Text="Export Data" runat="server" onclick="btnExport_Click" />
         </div>
       </form>

      </body>
</html>

<title>Export data from sql server database to excel in asp.net using c#</title>

</head>

<body>

<div>

<asp:Button ID="btnExport" Text="Export Data" runat="server" onclick="btnExport_Click" />

</div>

</form>

</body>

</html>

Now open code behind file and write the following code :

using System;
using System.Data;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }
    protected void btnExport_Click(object sender, EventArgs e)
    {
        Response.ClearContent();
        Response.Buffer = true;
        Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Customers.xls"));
        Response.ContentType = "application/ms-excel";
        DataTable dt = GetDatafromDatabase();
        string str = string.Empty;
        foreach (DataColumn dtcol in dt.Columns)
        {
            Response.Write(str + dtcol.ColumnName);
            str = "\t";
        }
        Response.Write("\n");
        foreach (DataRow dr in dt.Rows)
        {
            str = "";
            for (int j = 0; j < dt.Columns.Count; j++)
            {
                Response.Write(str + Convert.ToString(dr[j]));
                str = "\t";
            }
            Response.Write("\n");
        }
        Response.End();
    }
    protected DataTable GetDatafromDatabase()
    {
        DataTable dt = new DataTable();
        using (SqlConnection con = new SqlConnection("Data Source=SureshDasari;Integrated Security=true;Initial Catalog=MySampleDB"))
        {
            con.Open();
            SqlCommand cmd = new SqlCommand("Select TOP 10 UserName,LastName,Location FROM UserInformation", con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.Fill(dt);
            con.Close();
        }
        return dt;
    }
}

using System;

using System.Data;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btnExport_Click(object sender, EventArgs e)

{

Response.ClearContent();

Response.Buffer = true;

Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Customers.xls"));

Response.ContentType = "application/ms-excel";

DataTable dt = GetDatafromDatabase();

string str = string.Empty;

foreach (DataColumn dtcol in dt.Columns)

{

Response.Write(str + dtcol.ColumnName);

str = "\t";

}

Response.Write("\n");

foreach (DataRow dr in dt.Rows)

{

str = "";

for (int j = 0; j < dt.Columns.Count; j++)

{

Response.Write(str + Convert.ToString(dr[j]));

str = "\t";

}

Response.Write("\n");

}

Response.End();

}

protected DataTable GetDatafromDatabase()

{

DataTable dt = new DataTable();

using (SqlConnection con = new SqlConnection("Data Source=SureshDasari;Integrated Security=true;Initial Catalog=MySampleDB"))

{

con.Open();

SqlCommand cmd = new SqlCommand("Select TOP 10 UserName,LastName,Location FROM UserInformation", con);

SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(dt);

con.Close();

}

return dt;

}

VB.NET

Imports System.Data
Imports System.Data.SqlClient
Partial Class VBCode
    Inherits System.Web.UI.Page
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
    End Sub
    Protected Sub btnExport_Click(ByVal sender As Object, ByVal e As EventArgs)
        Response.ClearContent()
        Response.Buffer = True
        Response.AddHeader("content-disposition", String.Format("attachment; filename={0}", "Customers.xls"))
        Response.ContentType = "application/ms-excel"
        Dim dt As DataTable = GetDatafromDatabase()
        Dim str As String = String.Empty
        For Each dtcol As DataColumn In dt.Columns
            Response.Write(str + dtcol.ColumnName)
            str = vbTab
        Next
        Response.Write(vbLf)
        For Each dr As DataRow In dt.Rows
            str = ""
            For j As Integer = 0 To dt.Columns.Count - 1
                Response.Write(str & Convert.ToString(dr(j)))
                str = vbTab
            Next
            Response.Write(vbLf)
        Next
        Response.[End]()
    End Sub
    Protected Function GetDatafromDatabase() As DataTable
        Dim dt As New DataTable()
        Using con As New SqlConnection("Data Source=SureshDasari;Integrated Security=true;Initial Catalog=MySampleDB")
            con.Open()
            Dim cmd As New SqlCommand("Select TOP 10 UserName,LastName,Location FROM UserInformation", con)
            Dim da As New SqlDataAdapter(cmd)
            da.Fill(dt)
            con.Close()
        End Using
        Return dt
    End Function
End Class

Imports System.Data

Imports System.Data.SqlClient

Partial Class VBCode

Inherits System.Web.UI.Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)

End Sub

Protected Sub btnExport_Click(ByVal sender As Object, ByVal e As EventArgs)

Response.ClearContent()

Response.Buffer = True

Response.AddHeader("content-disposition", String.Format("attachment; filename={0}", "Customers.xls"))

Response.ContentType = "application/ms-excel"

Dim dt As DataTable = GetDatafromDatabase()

Dim str As String = String.Empty

For Each dtcol As DataColumn In dt.Columns

Response.Write(str + dtcol.ColumnName)

str = vbTab

Response.Write(vbLf)

For Each dr As DataRow In dt.Rows

str = ""

For j As Integer = 0 To dt.Columns.Count - 1

Response.Write(str & Convert.ToString(dr(j)))

str = vbTab

Response.Write(vbLf)

Response.[End]()

End Sub

Protected Function GetDatafromDatabase() As DataTable

Dim dt As New DataTable()

Using con As New SqlConnection("Data Source=SureshDasari;Integrated Security=true;Initial Catalog=MySampleDB")

con.Open()

Dim cmd As New SqlCommand("Select TOP 10 UserName,LastName,Location FROM UserInformation", con)

Dim da As New SqlDataAdapter(cmd)

da.Fill(dt)

con.Close()

End Using

Return dt

End Function

End Class

Cheap IIS Hosting Tutorial – Host ASP.NET Application on the Web Server (IIS)

CheapASPNETHostingReview.com | Best and cheap IIS hosting. In this post I will show you how to host ASP.NET application on the web server (IIS). Using Internet Information Services (IIS) Manager, you can create a local Web site for hosting an ASP.NET Web application. In this topic explains how you can create a local Web site and configure it to run ASP.NET pages.

As an alternative to creating a local site, you can also create a virtual directory. This lets you host the Web site on one computer, although the Web site content is somewhere else, such as on a remote computer. It is also a convenient way to set up a site for local Web development work because it does not require a unique site identity. This means that it requires fewer steps than creating a unique site.

Creating a Local Web site

The following procedures explain how to create a site in IIS version 7.5. and I am going to show how to host an asp.net application on IIS 7.5 in Windows 7 Home Premium Operating System. In case you are looking for trusted hosting provider, I trust on ASPHostPortal.com for my ASP.NET hosting.

Step 1

On the Start menu, click Run.
In the Open box, type inetmgr and then click OK.

You can also achieve the same by going to Control Panel and clicking on Administrative Tools > Internet Information Services (IIS) Manager as displayed in the picture below.

If you are not able to see the Internet Information Service (IIS) Manager, your computer might not have IIS installed. To install the IIS, follow below steps.

Installing IIS on Windows 7

Go to Control Panel > Programs > Turn Windows Features on or off as displayed in the picture below.

Ensure that from the Tree View, the Checkboxes against the Internet Information Services (IIS) is checked, even explore the depth of this root folder and check almost all checkboxes as displayed in the picture below. Checking almost all checkboxes will install more than enough (extra components as well that is not required for web hosting) component to get started and you may not use all the components. However later on you can uncheck to un-install those.

Step 2

Once you have opened the Internet Information Service (IIS) Manager, your screen should look like below (displayed the left panel in the below picture).

Now, right click the Sites and select Add Web Site. Enter the Site Name (in my case its SampleWebSite), select the physical folder where you have kept your website files (this may be your Visual Studio solution folder if you are setting it up at your local machine or the unpackaged folder path or the root folder of the website or web application). Now you can click on the OK button.

Clicking OK button may give you above alert box, complaining about the port you are going to use as by default port 80 is used for the default website of your IIS so you might want to change it. Click on No button at above alert box and change the port. I have changed the port to 8123 as displayed below and clicked on OK button.

Clicking OK should give you a screen something similar to below picture where you will have a SampleWebSite created (notice at the left panel).

Step 3

Now, you may click on the Advance Settings from the right panel and modify some settings that you want to modify. In general it is not needed and you can keep it default.

Step 4

Now, your website is ready to be browsed, you can right click on the website name (SampleWebSite in my case) and go to Manage Web Site > Browse and you should have an Internet Explorer window open displaying the default page of your website or web application.

Below is the screenshot of the default page of my SampleWebSite.

Step 5 (Optional)

Notice: Your website may not work if you have developed your it Visual Studio 2010 as your web.config file may have some tags that is not identified by the IIS. This is becuase creating the website the way we created just now will host your website in its own application pool that will have .NET Framework version 2 as target version. So you will need to change to the .NET Framework 4.0 version.

Click on Application Pools from the left panel and double click the Application pool for your webiste (generally application pool for your website is your website name so in my case SampleWebSite) and you should see a dialogue box similar to above. Select .NET Framework v4.xxx from the .NET Framework version dropdown and click OK. Now follow the Step 4 above again and your should see the default page.

Cheap ASP.NET Core 1.0 Hosting Tutorial – 10 Tips You Should Know while Choosing ASP.NET Hosting

CheapASPNETHostingReview.com | Best and cheap ASP.NET hosting. In this post we would like to show you the top 10 tips on choosing ASP.NET hosting providers before starting with our topic.

Being devoted into ASP.NET development and ASP.NET website hosting for a couple of years, we know the secrets hidden in the ASP.NET hosting advertisement and how difficult to find a trusted and cost effective ASP.NET hosting provider.

MS SQL Server database edition and limitation. The latest version of MSSQL 2012 are preferred.
.NET Framework versions. Does it support the version used for your website?
ASP.NET MVC versions. Does it support the version used for your website if you’re using ASP.NET MVC technology?
Does it provide the dedicated application pool so that you won’t be affected by your neighbors?
How long the IIS is set to recycle your website – usually 30 minutes at least is required.
What’s the maximum dedicated memory allowed for the ASP.NET websites?
The hosting provider needs to have the rich experiences and knowledge of how to ensure the high-quality ASP.NET hosting. Besides, it is great that they have got plenty of positive feedbacks from real customers and have been trusted and recommended by a lot of authorities, communities and hosting review sites.
The ASP.NET hosting needs to ensure a high level of hosting reliability with at least 99.9% uptime. Note that this can be achieved with the utilization of cutting-edge data centers, solid server machines and no overselling practice. In addition, some confident web hosts even claim to give you some compensations if they fail to meet their promised uptime track record.
The hosting speed is also pretty essential. After all, your readers can be frustrating if they find it takes a long time for accessing your website. In this case, you need to figure out that whether your web host can ensure the peak performance with no more than 3 seconds for page loading and 400 ms for the server response.
The web host needs to ensure the all-time-rounded technical support to assist you 24 hours a day and 7 days a week. Also, their support staffs need to have the rich knowledge about ASP.NET hosting and related applications.

General Knowledge about ASP.NET

ASP.NET is the server-side online application framework coming with the open source nature. It is designed with the purpose of web development and dynamic webpages production mainly. In addition, developed by Microsoft, ASP.NET has been used by a lot of programmers for the creation of complicated websites, online applications and add-on services.
In fact, ASP.NET has been released since January 2002, which is the successor to the Active Server Pages technology of Microsoft. As it is built based on the Common Language Runtime, developers and programmers can write the ASP.NET code with the help of .NET language.

MOST HIGHLY RECOMMENDED ” We highly recommended ASPHostPortal to host your ASP.NET Core 1.0 hosting. ASPHostPortal.com is offer reliable and affordable windows ASP.NET hosting service, they have four plans, Host Intro, Host one , Host Two anda Host Three. The price starting from $1.00/mo – $14.00/mo. You can buying ASPHostPortal Windows ASP.NET Core 1.0 hosting plan for as low as $1.00/month also you can get FREE Cloud Hosting click here

Simpan