All About ASP.NET and ASP.NET Core 2 Hosting BLOG

Tutorial and Articles about ASP.NET and the latest ASP.NET Core

ASP.NET 4.5.1 Hosting - with ASPHostPortal.com :: How to Load GMap Direction from Database in ASP.NET

clock March 11, 2014 06:45 by author Kenny

Well i am going to explain how to load GMap direction from database in ASP.NET.
Google maps is a web mapping service application and technology provided by Google, powering many map-based services, including the Google maps website, Google ride finder, Google transit, and maps embedded on third-party websites via the Google maps API. ASP.NET is a server-side web application framework designed for web development to produce dynamic web pages.
Let’s check the steps for run this program.

For the first: Go to file > new > project > select asp.net web forms application > entry application name > click ok.

And then add a database: Go to solution explorer > right click on app_data folder > add > new item > select sql server database under data > enter database name > add.


After that create table: Open database > right click on table > add new table > add columns > save > enter table name > ok.

This is the table sample:

Next, create a stored procedure in sql server: Open database > right click on stored procedure > add new stored procedure > write below sql code > save.

Next step, add a webpage: Go to solution explorer > right click on project name form solution explorer > add > new item > select web form/ web form using master page under web > enter page name > add.
Html code



Js code

Write this below js code for load gmap direction from database.

<script src="//maps.google.com/maps?file=api&amp;v=2&amp;sensor=false&amp;key=abqiaaaaupsjpk3mbtdpj4g8cqbnjrragtyh6uml8madna0ykuwnna8vnxqczvbxtx2dyyxgstoxpwhvig7djw" type="text/javascript"></script><script language="javascript">
        var gmap;

        var directionpanel;
        var direction;
        function initialize() {
            gmap = new gmap2(document.getelementbyid("map"));
            gmap.setcenter(new glatlng(22.573438, 88.36293), 15);
// here i have set kolkata as center and 15 zoom level

            directionpanel = document.getelementbyid("route");
            direction = new gdirections(gmap, directionpanel);
        }
        $(document).ready(function ()
{
            initialize();

            $('#btngetdirection').click(function () {
                //here populate data from database and get to gmap direction
                populatedirection();
            });
        });
        function populatedirection() {
            var from = $('#<%=ddfrom.clientid%>').val();
            var to = $('#<%=ddto.clientid%>').val();

            $.ajax({
                url: "default.aspx/getdirectioin",
// here url for code behind function
                type: "post",
                data: "{from: '"+from+"', to: '"+to+"'}",
                datatype: "json",
                contenttype: "application/json; charset=utf-8",
                success: function (data) {
                    direction.load(data.d.tostring());

                },
                error: function () {
                    alert("error!");
                }
            });
        }
    </script>

And then: write following code in page_load event:
Protected void page_load(object sender, eventargs e)
{
    if (!ispostback)
    {
        populatelocation();
    }}


Here is the function...

Private void populatelocation(){

// populate location here
    datatable dt = new datatable();
    using (sqlconnection con = new sqlconnection(configurationmanager.connectionstrings["con"].connectionstring))
    {
        string query = "select * from locations";
        sqlcommand cmd = new sqlcommand(query, con);
        if (con.state != connectionstate.open)
        {
            con.open(); }
        dt.load(cmd.executereader());}
    ddfrom.datasource = dt;
    ddfrom.datatextfield = "locname";
    ddfrom.datavaluefield = "locid";
    ddfrom.databind();
    ddto.datasource = dt;
    ddto.datatextfield = "locname";
    ddto.datavaluefield = "locid";
    ddto.databind();}


Don’t forget write this function into your page code behind for called from jquery code:

// this is the function is for called from jquery
[webmethod]
Public static string getdirectioin(string from, string to){
    string returnval = "";
    datatable dt = new datatable();
using (sqlconnection con = new sqlconnection(configurationmanager.connectionstrings["con"].connectionstring))
    {
        sqlcommand cmd = new sqlcommand("getdirection", con);
        cmd.commandtype = commandtype.storedprocedure;
        cmd.parameters.addwithvalue("@locfrom", from);
        cmd.parameters.addwithvalue("@locto", to);
        if (con.state != connectionstate.open)
        {
            con.open();}
        dt.load(cmd.executereader());}
    returnval = "from: " + dt.rows[0]["fromloc"].tostring() + " to: " + dt.rows[0]["toloc"].tostring();
    return returnval;}


And the last, Just run your application



ASP.NET 4.5.1 - with ASPHostPortal.com :: How to Convert PDF to Excel in ASP.NET

clock March 6, 2014 11:45 by author Kenny

Well, i will explain the best way to convert PDF to Excel in .NET Framework.
When dealing with digital documents, you may notice that PDF data and Excel spreadsheets often go hand in hand. Although not as easily as we’d like. The PDF format is perfect format for preservation of your content layout - whether it be an invoice, a statement or a database. Thus, even though the format can display data perfectly, it can also make it difficult to reuse, edit or analyze in Microsoft Excel. Users have no choice but to turn to PDF converter solutions.

For developers, this presents a perfect opportunity: you can provide a solution within your own applications. In fact, one developer tool, PDF2Excel SDK, will allow you to integrate PDF to Excel conversion technology into your existing software applications and projects.

Developed by Investintech.com, PDF2Excel SDK contains everything a developer needs to leverage the same conversion algorithm behind their desktop PDF converter via DLL or COM API. This introduction guide to PDF2Excel SDK will give you a closer look at their PDF to Excel 2007 conversion technology.


Implementation Methods

For those who are programming with C#, use the following methods to convert PDF to Excel.

1. Using the Function Library

Prior to using the PDF-To-Excel function library, you must declare the functions in a class:

Note: if the full path is not specified, the location of the DLL file has to be defined within the system variable named PATH. Alternatively the file should be placed in the same location as the .exe file which is using it.

2. Using the COM Server

Prior to using the PDF-To-Excel COM Server, you must define a project reference to the PDF2ExcelCom 1.0 COM Component.
The .NET COM Interop layer generates a wrapper class you may call in your code.



ASP.NET MVC 5.1.1 Hosting with ASPHostPortal.com :: Difference between ASP.NET Web Forms and ASP.NET MVC

clock March 5, 2014 09:53 by author Kenny

Now I wiil expose the main difference between ASP.NET Web Form and ASP.NET MVC.
ASP.NET Web Forms is a part of the ASP.NET web application framework. Web Forms are pages that your users request through their browser and that form the user interface (UI) that give your web applications their look and feel. These pages are written using a combination of HTML, server controls, and server code. When users request a page, it is compiled and executed on the server, and then it generates the HTML markup that the browser can render. Using Visual Studio, you can create ASP.NET Web Forms using a powerful IDE. For example, this lets you drag and drop server controls to lay out your Web Forms page. You can then easily set properties, methods, and events for controls or for the page in order to define the page's behavior, look and feel, and so on. To write server code to handle the logic for the page, you can use a .NET language like Visual Basic or C#.

Based on ASP.NET, ASP.NET MVC allows software developers to build a web application as a composition of three roles: Model, View and Controller. A model represents the state of a particular aspect of the application. A controller handles interactions and updates the model to reflect a change in state of the application, and then passes information to the view. A view accepts necessary information from the controller and renders a user interface to display that information.
ASP.NET developers have two options when building new Web projects: ASP.NET Web Forms or ASP.NET MVC framework.
There are the different
between ASP.NET Web Form and ASP.NET MVC:



ASP.NET 4.5.1 with ASPHostPortal.com :: Application Development A Perfect Web App Master

clock March 3, 2014 07:48 by author Kenny

ASP.NET is a development framework for building web pages and web sites with HTML, CSS, JavaScript and server scripting. ASP.NET helps bring out dynamism with web pages, all in a very short turn around time. This is why it is known to be a unique as well as a very popular framework, especially when web apps or websites are built. The reason why this framework was developed by Microsoft is because the market admires its innovative features. So, it has gained importance and is special as well. Consider it as a tool which can work wonders for developers as well as programmers, since it allows beautiful along with very dynamic websites to be born, using C# or VB as languages.

.net development services In the days gone by, web page contents weren’t spared of being static. With time it was understood that changes were important and have to be made for the websites to survive. New content had to be brought in. Moreover, there were manual modifications to be made to keep the site on the run as well as updated. This then brought about the awareness of having sites that would be auto updated as well as dynamic. Therefore, ASP by Microsoft was brought in, and hence the name ACTIVE SERVER PAGES came about. It thus helped in more ways than one, especially in meeting such needs.

Benefits

  1. You could own a small medium enterprise online or managing a huge business across many networks. There are many beneficial features which can help you to reach your goals.
  2. Irrespective of the size or volume, the language would work on every performance problem. It is developed in such a way that apps now can be worked on from any corner of the globe with utmost efficiency.
  3. Using this language, one doesn’t have to engage in long coding to make large apps. Most popular sites including ecommerce sites use it without any difficulty. This is because there is more power along with greater flexibility. In fact, the web pages can use the html code as well as source code for enhanced dynamism.
  4. In this day and age, using Asp.net for web apps is the sure shot way of making it big, say experts. The language is independent, with more than a quarter .net languages for users as well as developers to thrive on and to work with for their web apps.
  5. Infinite loops, memory leads or any activity deemed illegal would be instantly checked on. restarts happen on the spot, wherein all illegal activity along with its source would be tarnished.
  6. Before anything is sent to the main browser, the code would run on the esteemed server. This then ensures that there is constant monitoring of the pages, its main components as well as all the important applications in it.
  7. Cheap framework, and those looking for cost effective solutions would gain widely from it.


If you take a look online, you would find a large number of offshore companies across the world, willing and waiting to help your venture with all Asp.net needs. Most companies prefer their services outsourced, because of reliability as well as efficiency. Outsourced teams are available with plenty of expertise and experience to help with Asp.net application development and maintenance too.


The face of Asp.net app development is known to be an area which is fast emerging across the IT industry, say experts. Even the non IT companies look at it for safety and security in business across the online world. Verticals therefore are changing, and it is very rapid. Right from education to retail, manufacturing to finance, banking or investment, even online ecommerce sites too, everyone is using Asp.net.

Asp.net helps with continuity, smooth functioning and also gels well with a wide range of systems to meet every edge and demands of the business world these days. With super high web apps on the go, clients as well as customers alike are deriving immense satisfaction. Companies can now showcase their products and services like never before, there by bringing in more money.

 



ASP.NET 4.5.1 - with ASPHostPortal.com :: SEO friendly URLs with ASP.NET

clock February 26, 2014 06:51 by author Kenny

Search engines like human-readable URLs with keywords in it, and hesitate to respect messy URLs with a lot of query-string parameters. So, to make our ASP.NET database-driven website SEO-friendly we have to get rid of our complex URLs.

SEO or Search Engine Optimization is the process of affecting the visibility of a website or a web page in a search engine's "natural" or un-paid ("organic") search results. In general, the earlier (or higher ranked on the search results page), and more frequently a site appears in the search results list, the more visitors it will receive from the search engine's users. SEO may target different kinds of search, including image search, local search, video search, academic search, news search and industry-specific vertical search engines.

Solution 1: Fake pages and "Server.Transfer".
As you can see the two URLs above point to the same page. Basically it is the same page and it works like this: the page mailjet-newsletter-software.aspx contains no code at all and performs a Server.Transfer (aka server-side redirect) to product.aspx like this:
Server.Transfer("product.aspx?ProductID=18");
That's it. We have one "product.aspx" page which expects a "ProductID" parameter and a lot of "fake pages" with SEO-friendly names like firstproduct.aspx, secondproduct.aspx etc., which simply perform a Server.Transfer to the "product.aspx" with the right ProductID.

Simple, isn't it?

But this solution requires a lot of hard-coding - we will have to create all these fake pages and add a Server.Transfer command. So let's go a little further: we will create one base class for all our "fake pages" and add a record to the "tblProducts" table in the database:

Now we have to create our fake pages, inherit them all from the ProductPage class and voi la - that's it! We can also optionally remove all the HTML-code from the aspx-files, leaving the "Page" directive only.

Solution 2: Virtual Pages.

This method is pretty similar, except that we don't need to create any pages at all. Instead, we will add an HttpModule, which intercepts HTTP requests, and the user requests a non-existent page, performs a Rewrite operation. First we will create our HttpModule:

Now we have to register our HttpModule in the web.config:

<httpModules>
<add type="URLRewrite.ProductPageModule, URLRewrite" name="ProductPageModule" />
<httpModules>



ASP.NET 4.5.1 - with ASPHostPortal.com :: How to Create Dynamic DropDownLists in ASP.NET 4.5.1

clock February 26, 2014 06:23 by author Kenny

Now i will tell you how to create Dynamic DropDownLists in ASP.NET 4.5.1

Object:

1. Create dropdownlist dynamically with autopostback property true
2. Keep dropdownlist during postback
3. Maintain selected value during postback.
Here is the sample for this.

In aspx page:
<form
id="form1" runat="server">

    <div>

        <asp:Table ID="tbl" runat="server">

        </asp:Table>

        <asp:Button ID="btnSet" runat="server" Text="Button" onclick="btnSet_Click" /> </div>

    </form>

To Create Dynamic Dropdownlist:

protected
void Page_Load(object sender, EventArgs e)

{

    if (!Page.IsPostBack)

    {

    CreateDynamicTable();

    }

}

    private void CreateDynamicTable()

    {  

        // Fetch the number of Rows and Columns for the table

        // using the properties

        int tblRows = 3;

        int tblCols = 3;

        // Now iterate through the table and add your controls

        for (int i = 0; i < tblRows; i++)

        {

            TableRow tr = new TableRow();

            for (int j = 0; j < tblCols; j++)

            {

                TableCell tc = new TableCell();

                DropDownList ddl = new DropDownList();

                ddl.ID = "ddl-" + i.ToString() + "-" + j.ToString();

                for (int k = 0; k < 5; k++)

                {

                    ddl.Items.Add(new ListItem("item-"+k.ToString(),k.ToString())); 

                }

                ddl.AutoPostBack = true;

                ddl.SelectedIndexChanged += new EventHandler(ddl_SelectedIndexChanged);

                // Add the control to the TableCell

                tc.Controls.Add(ddl);

                // Add the TableCell to the TableRow

                tr.Cells.Add(tc);

            }

            // Add the TableRow to the Table

            tbl.Rows.Add(tr);

            tbl.EnableViewState = true;

            ViewState["tbl"] = true;

        }

    }

protected void ddl_SelectedIndexChanged(object sender, EventArgs e)

    {

    // what you want to perform    

    }

To retrieve value on button click:

protected
void btnSet_Click(object sender, EventArgs e)

    {

        foreach (TableRow tr in tbl.Controls )

        {

            foreach (TableCell tc in tr.Controls)

            {

                if (tc.Controls[0] is DropDownList)

                {

                    Response.Write(((DropDownList)tc.Controls[0]).SelectedItem.Text+" ");        

                }

            }

            Response.Write("<br/>"); 

        }

    }
Right Now, No output because dynamic controls are lost in postback then what to do.

So we need to save dynamic controls value and generate dynamic controls again.we need to maintain viewstate.

protected
override object SaveViewState()

{

    object[] newViewState = new object[2];

    List<string> txtValues = new List<string>();

    foreach (TableRow row in tbl.Controls)

    {

        foreach (TableCell cell in row.Controls)

        {

            if (cell.Controls[0] is DropDownList)

            {

                txtValues.Add(((DropDownList)cell.Controls[0]).SelectedIndex.ToString());

            }

        }

    }

    newViewState[0] = txtValues.ToArray();

    newViewState[1] = base.SaveViewState();

    return newViewState;

}

protected override void LoadViewState(object savedState)

{

    //if we can identify the custom view state as defined in the override for SaveViewState

    if (savedState is object[] && ((object[])savedState).Length == 2 && ((object[])savedState)[0] is string[])

    {

        object[] newViewState = (object[])savedState;

        string[] txtValues = (string[])(newViewState[0]);

        if (txtValues.Length > 0)

        {

            //re-load tables

            CreateDynamicTable();

            int i = 0;

            foreach (TableRow row in tbl.Controls)

            {

                foreach (TableCell cell in row.Controls)

                {

                    if (cell.Controls[0] is DropDownList && i < txtValues.Length)

                    {

                        ((DropDownList)cell.Controls[0]).SelectedIndex = Convert.ToInt32(txtValues[i++]);

                    }

                }

            }

        }

        //load the ViewState normally

        base.LoadViewState(newViewState[1]);

    }

    else

    {

        base.LoadViewState(savedState);

    }

}



ASP.NET 4.5.1- with ASPHostPortal.com :: How to Create Barcodes using ASP.NET App

clock February 26, 2014 05:09 by author Kenny

To create barcodes we will use ASP.NET web services. Not only that, we will also create Windows Forms and Console application to request barcode image.

What is The Benefits?

Well, web services provide a major benefit in integrating the software with external applications. With standardized request/response model, any client application that can utilize XML web service can benefit from it.Below is the brief visual representation of the barcode service. The clients do not need to refer to Aspose.BarCode for .NET. They will just send 2 string values (codetext and symbology) and will get the barcode image (byte array) from service.

Barcode Web Service
Now, open Microsoft Visual Studio. Create a new project of type “ASP.NET Web Service Application”. Name the project as “BarCodeService”. Add reference to the following .NET assemblies.

  1. System.Drawing from .NET tab of “Add Reference” dialog box
  2. Aspose.BarCode.

Browse to the location where Aspose.BarCode for .NET is installed and select. Visual Studio adds a default class “Service1” to the Web Service project in Service1.asmx file.
Open it and add the following method to this class.

The web method needs the following two parameters from client:

  1. Codetext
  2. Symbology

These parameters are of String type. The parameters are passed to the BarCodeBuilder class, which then creates the barcode and sends the barcode image in the form of byte array to the client.
This web method can be called by any kind of application that can consume a web service.


Consume Web Service from Windows Forms Application

Open Visual Studio and create a new project of type “Windows Application”. Name the project as “ GetBarCodeWinForms ”. Add reference to the web service by right clicking on “References” and then choosing “Add Service Reference” from the context menu. Type the address of web service or discover it. After getting the correct service, give “BarCodeService” in the Namespace and click on “Ok” button to add the reference.

Design the forms as follows.

It contains the following controls:

  1. Textbox: Input codetext from user
  2. Combobox: Input symbology type from user
  3. Button: Call web service
  4. Picturebox: Display the barcode image

Write the following code on click event of the button.

Run the application, specify some values and click on the “Get Barcode” button. The application will consume the barcode web service and get the barcode image from it. The image will then be displayed on the form as below.

Consume Web Service from a Console Application

Create a new project in Visual Studio and choose “Console Application” in project type. Name the project as “ GetBarCodeConsole ”. Add the reference to the barcode service, just as we gave above in the winforms application.Write the below code in the main() method.

Run the application, it will consume the barcode web service, get barcode image and save the image locally to disk.

Summary

Aspose.BarCode for .NET can easily be used in ASP.NET web services to generate the barcodes and serve the barcode image to various clients.



ASP.NET 4.5.1 with ASPHostPortal.com :: An Overview on the Advance ASP.NET 4.5.1 Technology

clock February 24, 2014 10:34 by author Kenny

What's the new from ASP.NET?  Noting that the 32-bit edit & continue was released in 2005,  that the 64-bit equivalent is part of ASP.NET 4.5.1.  The functionality is exactly the same as in the 32-bit version.Next, but it has the new ability to inspect method return values.  This can be done in the Visual Studio’s “Autos” window or in the immediate window.

 

The return value can be expanded in the debugger so that the current value can be viewed.  The debugging of asynchronous code is made easier with improvements to the usability of the Call Stack and Tasks Window for apps targeting the Windows Store, Web Apps, and Windows 8.1 Desktop Apps.That isn’t the only improvement for Windows Store apps, as now developers can convert Convert System.IO.Stream to IRandomAccessStream.  Enhancements have also been made to WinRT’s type system (through introduction of nullable value types)  and better exception support (example: System.Exception.Message, System.Exception.StackTrace).  

These new System.Exception properties improve over the Windows 8 experience since previously an attached debugger was necessary to avoid losing information. Whereas previously a broken network connection would lead to exceptions, the new 4.5.1 experience will handle the failure gracefully.  Should the network connection become repaired, the application will identify this and continue working.ASP.NET applications can now be suspended transparently.  The actual ASP.NET worker process is suspended in a ready to go state, with a 90% reduction in startup time.  Once the application has been idle for awhile, it is paged to disk, and then retrieved when a request for the app comes in and/or is made. This functionality can be enabled via IIS Settings by changing Idle Time-out Action to “Suspend”.Under the hood, in .NET 4.5.1, you can now compact the Large Object Heap (LOH) to address heap fragmentation.  

The LOH mode is part of GCSettings, but Heydarian cautions that “with great power comes great responsibility” and that this should never have be used in ordinary development.Improvements have been made to multicore Just-In-Time (JIT) performance, Heydarian stating a 15% performance improvement for cold startups.Another area improved in .NET 4.5.1 is around the behavior of the system after the framework has been updated.  Today servicing the .NET Framework can lead to degradation in app performance directly afterwards.  This is due to core .NET assemblies being JIT-compiled for a period of time after being updated/patched.  In Windows 8.1 app performance remains consistent even after servicing the .NET Framework.  This results in a much better user experience and supports Microsoft’s efforts to provide better battery life on tablets wherever possible.One of the goals Heydarian stated his team has is to do all of the heavy lifting so that the .NET developers all benefit.  Second, he whenever possible he wants the platform’s improvements to benefit developers with minimal (if any) recoding—just better performance.



Cheap ASP.NET 4.5 Hosting

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

 photo ahp banner aspnet-01_zps87l92lcl.png

 

Corporate Address (Location)

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

Tag cloud

Sign in