C# Corner

Resources  
  • Lightweight Raspberry Pi 3 Web Server Using PHP And HTMLFeb 13, 2018. This article demonstrates how to make a lightweight Web Server for the home using Raspberry Pi 3 and Python 3 IDE. The Pi can even handle Web Server so if you want to launch your own website with a proper back-end you can easily do it. This web server is a small amount of traffic and development purposes.
  • ASP.NET MVC - Export PDF Document From View PageFeb 13, 2018. In this article, we will learn how we can export view page to PDF using Rotativa framework. Rotativa is an open source framework created by Giorgio Bazio in order to export view page to PDF. This framework is based on wkhtmltoPDF tool which is used to generate PDF from HTML view page.
  • Dynamic Web View Of A SharePoint List Item Using Excel Web Access Web PartFeb 03, 2018. Sometimes, the customer would like to see the SharePoint list item with a specific design instead of default view for which the developer develops an app or web part to achieve it.
  • CRUD In Excel File In C#Feb 02, 2018. In this article, I am going to explain how we can CREATE, UPDATE, DELETE and READ the records in Excel files.
  • Google Chrome Extension Project With Microsoft Visual StudioFeb 01, 2018. Extensions are small software programs that customize the browsing experience. Where use can customize and manipulate the chrome browser functionality and open web resources. Extension is built on web technologies such as HTML, JavaScript and CSS.
  • Linq To Excel In ActionJan 29, 2018. In this post, we will demonstrate how we use LinqToExcel library to query data from Excel.
  • How To Add Excel Add-In For GeoCoding (Batch GeoCoding)Jan 27, 2018. This simple tutorial is about adding MS Excel Add-in and getting the geocodes, i.e., Location Points (Latitude, Longitude) or to verify the accuracy of address, using three Service Providers
  • Converting SQLite Database To Excel And Excel To SQLite Data In AndroidJan 23, 2018. In this article, we will learn how to export Android SQLite Database to Excel or Import Excel into SQLite Database. We can use SQLiteToExcel library to perform these functionalities.
  • HTML Parser In Xamarin.Android Using jsoupJan 20, 2018. In this article, we will learn how to parse an HTML page using jsoup in Xamarin.Android.
  • Model Driven Forms In AngularJan 15, 2018. I have opened the same solution I have explained in my previous article, and i have app.component.ts with onsubmit function and I have html elements in app.component.html.
  • Microsoft Office 2013 UI Design In C# - Visual StudioJan 07, 2018. In this article we will design the UI of Microsoft Office 2013 applications like Word, PowerPoint, Excel etc.
  • How To Bind Data To A Drop-Down List And An HTML Table With *ngfor In AngularJan 07, 2018. In this article, you will learn how to bind a data to a drop-down list and to an HTML table on selected item from a drop-down list with *ngFor in Angular4.
  • Office 365 Modern App DevelopmentJan 06, 2018. Web standard Apps are built using industry proven web Standards such as HTML, JavaScript and REST. Apps are independently scalable which reduces the total cost of ownership. Apps are secured and isolated from SharePoint. These apps can be accessed from any device with a browser.
  • A Potentially Dangerous Request.form Value Was Detected From The ClientDec 26, 2017. This error can occur in any page, but mostly a client receives this error while entering a new or modified item / product in admin panel of any portal because in admin panel we mostly write html code to fill in blanks, and also to display the product feature in ordered or unordered list.
  • Validation Of Excel Data In C#Dec 24, 2017. This article demonstrates how to validate an Excel sheet before uploading or storing its data into a database.
  • ASP.NET Core 2.0 Tag Helper ComponentDec 18, 2017. In case you’re wondering if the solution above is missing a Tag Helper for head HTML element, it’s not. ASP.NET Core team has provided us with two built-in Tag Helpers, one targets head and the other targets the body element: HeadTagHelper and BodyTagHelper.
  • Directives In Angular 5 - Part Two (Structural Directives)Dec 15, 2017. These are responsible for the HTML layout they shape or reshape the html element by simply adding or removing the elements in the DOM. These directives are the ways to handle how the component or the element renders in the template .
  • Using jqGrid With ASP.NET MVCDec 12, 2017. If you belong from a background of asp.net web forms then there is grid view which we used most but in some scenario if data was large then it would use to break, but in MVC we do not have that kind of grid which has all readymade event, but there is html helper which help you to generate html is Web grid in that we need to use different package for handling paging of grid, and also we need to pass a strongly typed model to view for rendering the grid.
  • How To Optimize SharePoint Custom Pages Using HTML 5 IndexedDB APIDec 07, 2017. In this article we will discuss another obvious performance issue with SharePoint Solutions involving large volumes of data transactions surfacing in SharePoint Custom Pages.
  • Creating Server And Host HTML Page Using Node.jsDec 07, 2017. Today my mission is to explain about creating server in Node JS and hosting html pages on this server and accessing it from web browser.
  • Show SharePoint List Item Level Attachments Using REST API And jQueryDec 05, 2017. In this article, we explore in Sharepoint 2013, how to show the Sharepoint list item level attachments using REST API and jQuery. In previous articles, I explained about adding multiple attachments to list item using html and JQuery. Now let’s use some REST API to pull these attachments and display them in list.
  • Building SPA With Angular And ReduxDec 01, 2017. In the current application development era, Single Page Application (SPA) is a great feature to develop modern web based applications. In these SPA applications we tend to move the data level dependency from the server side to browser level as much as possible to improve the application performance. So as much as application level functionality moves to the browser level the amount of the data and way to manage these data is also increased. Modern SPA application frameworks like Angular and React use component based architecture that divides our application into small-small sections. Each component contains its own HTML page, stylesheet and its own state(data). This approach is very efficient because it divides our application into small sections that we can manage very easily and also we can reuse these components in our application.
  • Creating Custom Tag Helpers With ASP.NET Core MVCNov 29, 2017. The tag helper enables us to run server-side code to generate HTML, CSS, Javascript code in Razor view.
  • Convert XML File To Excel FileNov 27, 2017. Here, we are going to learn to read XML files in C# WindowsForm applications. We are going to make a small single-form application which takes an XML file from the user and convert XML Data to Excel Data and Returns an Excel File.
  • Pug Vs HTMLNov 26, 2017. In the holy wars of "Pug vs HTML", it is really confusing sometimes to realize which one of these to use. The same is true for SQL vs NoSQL, and the similar is true for Java vs Python. Then people think why not talk about Pug vs HTML as well. HTML is always the perfect language to consider, however for the case of Pug there might be a bit of confusion. Some developers don't know Pug, and some who know it, know it as a Jade framework.
  • Anchor Tag Helper In ASP.NET MVCNov 23, 2017. The Anchor Tag Helper generates HTML anchor (<a> </a>) element by adding a new attribute. The "href" attribute of the anchor tag is created by using new attributes.
  • How To Track Facebook Wall Messages In An Excel Table Using Microsoft FlowNov 22, 2017. Microsoft Flow is a cloud-based service. It allows us to react to an event in one and do something with the data from that event into another service. It makes it practical and simple for line-of-business. The users can build workflows that automatically do some business tasks and processes across applications and services.
  • How to Return Files From Web APINov 18, 2017. This article explains how to transfer/ return files(PDF/Doc/Excel/zip) files from Web API service
  • Building A Questionnaire Site With Node.jsNov 14, 2017. This was our first project with Node.js, and by God, it was a pain. Node.js is an excellent framework, with blazing fast speed, and an intuitive development framework. For those who are familiar with HTML, CSS and JavaScript, Node.js is one of the best alternatives to PHP, ASP.NET or other server-side scripting languages that require a language to be learnt. Node.js is light-weight, resilient and community-led and in-development framework. This article is primarily focused on teaching the beginners in Node.js development. You can expect to learn a few basics of Node.js setup, how to manage the databases in Node.js environment and a bit more (less too, maybe).
  • Custom Search Using Client Side CodeNov 11, 2017. The Custom Search functionality is achieved through JS. The Search produces live results for each key press. This search can be used to filter the data table or html table data dynamically based on the key words entered. The below code explains the search for html table.
  • Upload/ Download Files In ASP.NET Core 2.0Nov 10, 2017. ASP.NET Core MVC model binding provides IFormFile interface to upload one or more files. The HTML form must have encoding type set to multipart/form-data and an input element with type attribute set to file.
  • ASP.NET Core 2.0 MVC Custom Tag HelpersNov 08, 2017. As discussed in the previous post, Tag Helpers help generate HTML by attaching attributes to existing HTML elements or by creating new elements. In this post we’ve created a new tag to display employee information.
  • Learn Angular 4.0 In 10 Days - Day OneNov 07, 2017. HyperText Markup Language (HTML) was invented in the year of 1990 by Tim Berners-Lee—a famous physics and computer scientist—while he was working at CERN, the European Organization for Nuclear Research. He was motivated to discover a better solution to share information among the researchers of the institution in a very quick and easy way. To support that, he also created the HyperText Transfer Protocol (HTTP) and its first server, giving rise to the World Wide Web (WWW). At that time, HTML was used just to create static documents with hyperlinks, allowing the navigation between them.
  • ASP.NET Core 2.0 MVC Tag HelpersNov 07, 2017. Tag Helpers help generate HTML by attaching attributes to existing HTML elements or by creating new elements. Although they look like HTML elements and attributes, Tag Helpers are processed by Razor (server-side).
  • Power BI And Excel File As Data SourceNov 06, 2017. Though we have several options for data sources to connect with Power BI in this blog, I am going to write about how we can use Excel data with Power BI and how to refresh the report when Excel data is changed.
  • Hosting Website Using FileZilla To AzureNov 05, 2017. In this article, we will see how to publish your normal HTML website without using Visual Studio or any other tool by using FileZilla in Microsoft Azure.
  • How To Connect The Outlook Mail To Excel With Microsoft FlowOct 31, 2017. This article helps you to learn how to create a Flow between the Outlook Mail and Excel Spreadsheet.
  • ASP.NET Core 2.0 MVC RazorOct 31, 2017. ASP.NET Core MVC middleware will find and execute the Razor template (.cshtml file) when the Controller returns ViewResult. Razor templates use syntax that combine C# and HTML to produce the final HTML page.
  • How To Read CSV File In ASP.NET With Example C# and VB.NETOct 26, 2017. In this articleI'll explain a way to upload, read/browse and show CSV file (Text File) information in ASP.Net GridView using C# and VB.Net.
  • How To Use jQuery Datatable In AngularOct 24, 2017. In this article I am going to explain how to use and integrate the jQuery datatable with AngularJS. DataTables is a prebuild functionality and a plug-in for the jQuery JavaScript library. It is a highly flexible tool, based upon the foundations of progressive enhancement, and will add advanced interaction controls to any HTML table.
  • Generate PDF From An HTML Page Using AngularOct 24, 2017. In this article, I am going to explain how to generate PDF file from an HTML page using AngularJS in SharePoint. This is the effortless way to port the SharePoint list data or any other list data to carry, print, and make a hard copy.
  • Angular Directives With ExamplesOct 24, 2017. Directives play an important role in Angular 2 project, when we display the templates or html pages in our project. By using this we can easily manipulate our Dom layout.
  • Creating A Dynamic YearPicker Plugin Using JQuery And HTMLOct 14, 2017. We have seen many year pickers that allow you to select years from the dropdown. I have seen a requirement of selecting years from the year picker as we select date from the datepickers. Now I am going to create a dynamic Year picker plugin to select the year using jquery and html
  • Read Excel File In C# WinFormOct 13, 2017. Here we are going to learn to read Excel files in C# windows form applications.
  • Create Angular Project By Using ASP.NETOct 13, 2017. Angular 2 is an open source JavaScript framework to build web applications in HTML and JavaScript. This tutorial looks at the various aspects of Angular 2 framework which includes the basics of the framework, the setup of Angular and how to work with the various aspects of the framework. Other topics discussed in the tutorial are advanced chapters such as interfaces, nested components and services within Angular. Topics such as routing, modules, and arrays are also dealt with in this tutorial.
  • Angular Components (With Examples)Oct 12, 2017. A Component is nothing but a simple typescript class, where you can create your own methods and properties as per your requirement which is used to bind with an UI (html or cshtml page) of our application.
  • Excel To XML Using LINQOct 11, 2017. In this article we will show you the easiest way to convert Excel data into Xml files. There is a certain way to convert Excel file to Xml, for example using Excel Library (Com Component)
  • How To Use DataList Control In ASP.NET With Example in C#Oct 08, 2017. In this article I’ll present a tutorial with an example, a way to use the DataList control in Asp.Net for the displaying of information/ records from the database with using SqlDataSource.
  • Sending Bot Reply Message With Attachment Using Bot FrameworkOct 07, 2017. The Bot Framework enables you to build bots that support different types of interactions with users. You can design conversations in your bot to be freeform. Your bot can also have more guided interactions where it provides the user choices or actions. The conversation can use simple text strings, the message with an attachment like the image, File (pdf, word, excel, ppt), mp3, Video or more complex rich cards.
  • Read Data From Excel With Preview In ASP.NET MVC Using AngularOct 03, 2017. In this article we will see how to Read data from excel and show preview and after we can update to database with Asp.net Mvc using Angular.
  • Execution Of Selenium Web Driver Using C# And JavaScriptOct 01, 2017. In my previous articles / blogs on selenium webdriver , we have seen the execution of various HTML controls using selenium C#. As we know using selenium we can automate anything which we see on the webpage or web application like Alert message , prompt message ,messagebox , textbox , dropdown buttons like (single click ,double click) , hyperlink , checkbox ,radiobutton etc , and even we can automate applications which is developed using Ext.js(Sencha Applications) or KendoUI applications etc.
  • HTML 5 Web Workers In ActionOct 01, 2017. In a nutshell, web worker is a JavaScript code that runs in the background (without refreshing the page) and without adding any performance overhead on the page. So that means, you can continue using your site by clicking here and there while web worker is doing its assigned functionality in the background.
  • Convert HTML Files To DOCX Files With MariGold.OpenXHTMLSep 30, 2017. This tutorial explains how to create an HTML to DOCX converter with a C# windows application.
  • Introduction To Tag Helpers In ASP.NET CoreSep 18, 2017. Tag helper is a new feature in ASP.net MVC. It enables server-side code to create and render HTML elements in Razor View. It is feature of Razor View engine. They are the C# classes which participate in view generation by creating the HTML elements. Using the tag helper, we can change the content of HTML element and add additional attributes to the HTML element. It is very similar to HTML helper in ASP.net MVC.
  • Get Office 365 Data In Excel Using MS Graph APISep 08, 2017. In this article, I will show how you can quickly fetch Office 365 data of your organization in MS Excel using Microsoft Graph API.
  • How To Perform Web Scraping Using Python ProgramSep 04, 2017. Web Scraping (also known as Screen Scraping, Web Data Extraction, Web Harvesting etc.) is a process to scrap (extract) data from web pages, web document, HTML document or XML document in a structured manner and then store in database, text file as a spreadsheet , as a XML , or in whatever file format we want to save in.
  • Extend Built In Label Tag Helper In ASP.NET Core ApplicationAug 31, 2017. Tag helpers is one of the new feature introduced in ASP.NET Core which allows us to add server side code while creating and rendering HTML elements. They are similar to HTML helpers in ASP.NET MVC. ASP.NET Core comes with various built in tag helpers for rendering HTML elements like label, input, img, select etc.
  • JasperReports - Basic IntroductionAug 26, 2017. JasperReports is an open source software which is widely used for creating PDFs. It is not limited to creating PDFs but one can also export any desirable formats such PNG, CSV, Excel, Word doc, and HTML etc.
  • Page Linking Tags And URL Parameters In Ruby On RailsAug 22, 2017. In this article will learn about creating HTML and ERB page linking tags and how to create URL parameters in Ruby on Rails templates.
  • IoT With HTML5 Game Engine And Node.JSAug 21, 2017. In this article, I will tell you how to use node.js as a bridge between an HTML 5 game and IoT by using Johnnyfive.io and Phaser.io.
  • Transform XML Output Of SQL Query To HTML Using "For XML" AUTO Statement With XSLT In C#Aug 21, 2017. Normally, we execute the query using ExecuteNonQuery statement and fill the output into data table. This article describes how to transform the XML output of SQL query statements using FOR XML AUTO to HTML using XSLT.
  • Responsive Tables Using FootableAug 20, 2017. This article explains how to make an html table responsive using footable plugin.
  • Using ERB Tags In Ruby On Rails Default HTML TemplatesAug 18, 2017. In this article, you will learn about the view templates, template file naming, ERB tags, and how to use ERB tags in HTML templates.
  • Reading An Excel File Using HTML 5 And jQueryAug 18, 2017. This article explains how to export data from an Excel file to an HTML table using jQuery & HTML5.
  • Export To Excel And PDF In Kendo Grid For AngularAug 06, 2017. From this article you will learn how to perform export to excel and PDF in kendo grid for Angular 2
  • Creating Bullet-Shooting Game Using Constructor 2Aug 02, 2017. Constructor is used for 2D game creation without writing a lot of code. Now in this article, I will explain how to design the game start page using Constructor. Constructor 2 is a powerful HTML 5 game creator designed especially for 2D Game Developer.
  • Creating Web API With ASP.NET Core Using Visual Studio CodeJul 28, 2017. Web API is is framework that allows us to build web or http based endpoints. If you are building services today for mobile, HTML 5, and even client-server desktop applications, all these different types of applications need services in the backend.
  • Angular, Bootstrap And ASP.NET MVC - Part Four (Angular Routing)Jul 27, 2017. In this tutorial, we are going to learn how we can navigate from one HTML page to another using angular routing. AngularJS provides a nice feature that we can navigate to another page but without reloading the whole page. We can use “ngRoute” module to achieve this.
  • Extracting Data From Large Spreadsheets Using Python And OpenpyxlJul 26, 2017. At least once in life, every computer user has to handle some spreadsheets or, excel files. Sometimes it's to put formulas in for accounting, sometimes it's to store data from Google forms or other surveys. So what do you actually do when the spreadsheet contains just survey data or no numbers to apply formulas at all? I know you'll get your hands dirty and do it manually.
  • How To Upload Records From Excel File to Database Using Stored Procedure In MVCJul 10, 2017. In this article, I will explain how to upload records from Excel files in the database using store procedure and also how to check all types of validation.
  • Drawing Playground Using HTML 5 Canvas And JavaScriptJul 04, 2017. In this article we will learn about how to draw object on canvas using HTML5 canvas and JavaScript.
  • Creating TreeView For MVC 5Jul 03, 2017. We're going to extend JsTree from JS to MVC and we'll render HTML tags from the database using custom development in the model.
  • ASP.NET MVC Tooltip Using Web API, Bootstrap Popover And jQuery UI DialogJul 03, 2017. I am sharing an article on how to create a help tooltip for a HTML element using Web API, Bootstrap Popover and jQuery UI dialog.
  • How To Download SQL Records In Excel Format Using MVCJul 02, 2017. I will explain how to download records in Excel format from database.
  • Export GridView In Excel And PDF Using Stored Procedure In ASP.NET In Real-TimeJun 28, 2017. This article will show you how to export GridView records using Excel and PDF.
  • Different Formats In Report Generation Using JSReport ServerJun 23, 2017. The JSReport Server supports different types of formats in report generation like pdf, xlsx, html, text, html to xlsx etc. In previous article the report was generated in PDF format.
  • Send Email Using Templates In ASP.NET Core ApplicationsMay 30, 2017. In this article, you will learn how to send email using Email Template in ASP.NET Core Web Application. Also we will discuss how to design a custom HTML Email Template using Images, CSS and Personalized Message, and send that to multiple users in ASP.NET Core Application.
  • Add Excel Web Access Webpart In SharePoint SiteMay 19, 2017. Add Excel Web Access Webpart In SharePoint Site.
  • Write HTML Code In Xamarin Cross Platform With Table ExampleMay 17, 2017. You build your mobile app entirely in HTML, however those apps can suffer from performance problems when trying to accomplish complex processing or UI effects and are also limited in the platform features which they can access.
  • Building .NET Core Basic Application With Static Files - Day ThreeMay 09, 2017. In this article, we will discuss how to access static files like html files in asp.net core applications.
  • Class And Style Bindings In Angular 2 - Part EightMay 04, 2017. In this article, we are going to learn how to bind classes and styles to HTML elements.
  • Export Data to Excel from Web API in ASP.NET Core using Kendo GridApr 03, 2017. In this article, you will learn how to export data received from Web API in ASP.NET Core using Kendo Ui Grid.
  • Introduction To Tag HelpersApr 01, 2017. ASP.Net Core : Introduction to Tag Helpers.
  • Import Data From Excel To DB Using AngularJS And Web API 2Mar 26, 2017. In this article, you will get to know about how to import data from Excel to DB, using AngularJS and Web API 2.
  • Call Web API Using JQuery AJAX In ASP.NET Core Web ApplicationsMar 25, 2017. In this article, you will learn how to create a simple Web API and pass the data, and call the Web API using jQuery AJAX and parse into HTML in ASP.NET Web Application (.NET Core),
  • Creating An Image Slider Using JavaScript, HTML, And CSS OnlyMar 22, 2017. Creating an Image Slider using JavaScript, HTML, and CSS only.
  • Read Posted Excel File Using NPOI Library In ASP MVC With AJAXMar 17, 2017. In this article, we will learn how to read posted Excel file from AJAX, using NPOI DLL in our ASP MVC Application.
  • Create Business Intelligence Excel Charts Using VBA And Upload To SharePointMar 16, 2017. Create Business Intelligence Excel Charts using VBA and upload to SharePoint.
  • How to import Excel data in SQL Server 2014Mar 07, 2017. In this article, you will learn how to import data from Excel file into SQL Server database.
  • An Easy Way To Transfer Data Between WPF Applications And ExcelFeb 23, 2017. In this article, you will learn about an easy way to transfer the data between WPF Applications and Excel.
  • Import Excel Data Into SQL Table Using SQLBulkCopy In C#Feb 22, 2017. In this article, you will learn how to import Excel data into SQL table, using SQLBulkCopy in C#.
  • Implement Excel Validations Using VBA Macro Before Uploading To SharePointFeb 21, 2017. In this article, you will learn how to implement Excel validations, using VBA Macro before uploading to SharePoint.
  • Dynamic HTML Using Handlebars JavaScriptFeb 14, 2017. This article is about handlebars template engine and basic dynamic HTML.
  • How To Create SharePoint List In Office 365 By Uploading Excel SheetJan 31, 2017. In this article, let’s see how to create SharePoint list in Office365 by uploading an Excel Sheet into the system.
  • Introduction To Apache Cordova In Universal Windows Platform Using Visual StudioJan 30, 2017. In this article, you will get an introduction to Apache Cordova in Universal Windows Platform, using Visual Studio.
  • SharePoint 2013 Online - Implement Client Caching For SharePoint ObjectsJan 29, 2017. In this demo, we will discuss the caching mechanism for SharePoint Objects which are more complex in nature than the primitive data types.
  • Implement Client Caching For SharePoint PropertiesJan 27, 2017. In this article, we will explore HTML5 Local Storage API, using which, the Web Applications can store data locally in the user’s browser.
  • How To Use Images In BootstrapJan 23, 2017. In this article, we will learn how to style images, and create thumbnails and responsive images by using Bootstrap.
  • Introduction To Bootstrap TablesJan 17, 2017. In this article, we will learn how to use tables in bootstrap.
  • Export Data To Excel File In ASP.NET Using EPPlusJan 14, 2017. In this article, we are going to learn how to create and download Excel files in C#, using EPPlus DLL.

About Excel-to-HTML

NA
Web Development Outsourcing
Looking to add more bandwidth to your software team? Web Developers, designers, testers are now available on demand. Flexible hours, very competitive rates, expert team and High Quality work.