C# Corner

Resources  
  • Deep Walk On Azure Machine Learning - Why On Cloud And That Too On AzureDec 12, 2017. This article goes up with a deep walk on Azure Machine Learning covering the topics with lot many modules which heads up with loading data in azure machine learning, data preparation, azure machine learning modelling, deploying the models and about r scripts in Azure.
  • 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.
  • Learn Angular 4.0 In 10 Days - Data Binding - Day ThreeDec 11, 2017. In this article, we will discuss data binding in Angular JS 4.0
  • Knowing When To Reflect With Caller Info AttributesDec 10, 2017. If you've been around C# long enough, you've probably had a need at one time or another to figure out some information about code that's being executed. It might be a method name, the file being executed, or even more specific details like the line number.
  • Implement Symmetric And Asymmetric Cryptography Algorithms With C#Dec 09, 2017. How to encrypt and decrypt data using Symmetric and Asymmetric algorithms using C# Programming language
  • How To Find Duplicate Records In SharePoint ListDec 07, 2017. In this article, we will see how to detect duplicate records in SharePoint Lists. This automation approach will be helpful in scenarios where we need to fix data duplication issues across multiple SharePoint Lists.
  • Understanding Classes In KotlinDec 07, 2017. In the above example, I have created a nested class ‘Nestedclass’ which has a data member ‘b’ and a member method show(),now the object of nested class can access member of nested class only.
  • 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.
  • DropDownList In ASP.NET MVCDec 06, 2017. In this article you will come know how to bind data and get dropdownlist selected value in Asp.Net MVC in Client Side and Server Side.
  • Display Sub Directories And Files In TreeViewDec 05, 2017. Display Sub Directories and Files in Treeview, Tooltip in Treeview Nodes, Loading Files in Treeview, Display image icon in TreeNode.
  • Accessing Azure Key Vaults Using Certification Dec 05, 2017. In the old days, we used to access the Azure Key Vaults using Vault URL and its Secret Key, we were placing this in config file and going from there.
  • How To Use Indexed DB To Improve Page Load PerformanceDec 05, 2017. Indexed DB is a local storage system, which will store data in client-side on browser. This is useful for applications that require us to store large amounts of data. These applications can run more efficiency and load faster.
  • How To Create Three-Layer Architecture Of ASP.NET ApplicationDec 03, 2017. Three-layer architecture is made of Presentation, Business, and Data access layer. In this article, I will create three layered architecture with the help of a simple asp.net application.
  • Angular 5 Property - Event BindingsDec 02, 2017. Binding is the process which forms the connection between the application UI and the data which comes from the business logic. In Angular it can be called the automatic synchronization of the data and the view.
  • Work With External AppSetting Of Web.ConfigDec 01, 2017. In this article, you will learn about .NET Configuration Files
  • 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.
  • Mounting Azure File Share With WindowsNov 30, 2017. This article shows how to create an Azure Storage account
  • Dynamic Search In DataGridViewNov 30, 2017. This article will help you to understand the Dynamic Search method in DataGridView in C#.
  • Routing In Suave.io - Web Development With F#Nov 29, 2017. A web application is generally composed of multiple “routes”. A route means a URL that does not necessarily map a physical file, you can use routes to define some URLs that are semantically meaningful to the user.
  • Difference Between MySQL DATETIME And TIMESTAMP DataTypesNov 29, 2017. A simple question that may come to one's mind while working with MySQL is "Whether to assign DATETIME or TIMESTAMP datatype for a column as both seem to store the same data?”. Even though they store the same data, they differ in some ways and let's check those things out with the help of a small example.
  • Passing Data Between Components - Day TwoNov 29, 2017. We have seen that we can pass the data between the components using the @Input and @Output directives and using event emitters. Let’s see the other two methods - @View child and the services which can be used to pass the data between components.
  • Building Entity Framework Disconnected Generic RepositoryNov 29, 2017. The repository pattern separates and retrieves data model mapping logic from the business logic. We will create a repository class for each entity class in our application. All these classes usually have a main group of equals methods.
  • How To Add Test Data For SharePoint Online Using Test Data AppNov 29, 2017. In this article, we will learn how we can add Test dummy data with SharePoint Online List , Document Library , Calendar List , Tasks and Events. We will use one third party utility which is totally free to use.
  • Adding A DataDisk To Our Virtual MachineNov 28, 2017. This article shows how to add a disk to our Virtual Machine for additional data storage.
  • Progress Bar Android App Using Android StudioNov 28, 2017. In this article, I will show you how to create a Progress bar android App using Android studio. We can display the Android progress bar dialog box to display the status of work being done e.g. downloading file, analyzing status of work etc.
  • Saving Your Ruby On Rails Application Code To Github.comNov 28, 2017. In this article you will learn git configuration in git bash and git hub repository creation, add new ssh key in git hub and finally add all application files into git hub repository via remotely using with git bash for Ruby on Rails application version controlling.
  • Virtual Entity - New Way Of Integration - Part TwoNov 28, 2017. This is our second article regarding virtual entity, if you have not checked our earlier article, we suggest you check that first here. In this article we are going to demonstrate about create OData Web API without Entity Framework and hosting it in Azure to consume into Dynamics 365. Let say we have employees data that we want to show into virtual entity, so let’s get started!!
  • Passing Data Between ComponentsNov 28, 2017. Article explains 2 Methods of communication between the components .
  • Filtering jQuery Data Table Server Side Using MVC And Entity FrameworkNov 27, 2017. This article explains how to work with jquery Datatable on the server side and how to use Search Textbox to do serverside filtering using MVC and Entity Framework
  • 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.
  • Configuring Log4Net With Database - A Tutorial For BeginnersNov 26, 2017. Log4Net is a framework for logging .NET applications. It is an open source library that can be used to log output for different targets like logging output in Text files, Database, Console, Mail (SMTP), Remote and others. In this article, I will explain how to log output in a database.
  • Classify Data Based On K-Nearest Neighbor Algorithm Machine LearningNov 25, 2017. This article will explain the concept of data classification based on K-Nearest Neighbor Algorithm of Machine Learning
  • Transform Web.Config File While Deploying The Web Application ProjectNov 25, 2017. One of the nice features that supports Visual Studio 2010 and above versions is Web.Config (XDT) transformations.
  • Connecting R Software With Oracle DBNov 24, 2017. This article is about how to connect the R software with Oracle database so that the data can be brought inside R environment for analysis
  • Introduction To SSISNov 24, 2017. SSIS stands for SQL Server Integration Services. It is one of the services of SQL Server and was introduced for the first time in SQL Server 2005. It’s a powerful replacement for the legacy DTS (Data Transformation Services) that exists in SQL Server 2000.
  • Creating An Event Hub On The Azure PortalNov 24, 2017. In this article, I am going to describe and demonstrate the creation of Event Hubs on the Azure Portal.These Event Hubs are used to act as a port to collect the streaming data and processing of that data per second.
  • 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.
  • ASP.NET Core 2.0 Secret ManagerNov 22, 2017. I discussed in the previous post how configuration settings can be stored in configuration files. However, these files are checked in the source control and not suitable to store confidential settings. In a production environment these settings can be stored in environment variables or Azure Key Vault however, for development ASP.NET Core provides an alternate solution: Secret Manager.
  • Copying A File In Node.js v8.5Nov 22, 2017. In this article, I will explain how to copy a file using the brand new Node.js version 8.5.
  • Creating A Data Science Virtual Machine(DSVM) For Linux In The Azure PortalNov 21, 2017. In this article, I am going to demonstrate how to create the Data Science Virtual Machine for Linux on the Azure Portal and connect the DSVM to visualize the VM using X2Go Client Software.
  • Migrate From TFS To VSTSNov 21, 2017. Migrate from TFS to Team Services with the TFS Database Import Service.
  • Creating An Azure Data Lake Store And Data Analytics Account In Azure PortalNov 20, 2017. This article shows how to create an account on Azure Data Lake and Data Analytics in the Azure portal.
  • Uploading, Validating, And Storing A File Into Database Using EF In ASP.NET MVC5Nov 20, 2017. Here, you will learn how to upload a file, validate a file and store a file into database using JQuery, Entity Framework in ASP.NET MVC5
  • Simplest WPF Dependency Property For Beginners On Background ColorNov 19, 2017. Dependency property is not wrapped over any private members unlike CLR properties, and it is also stored in Key-Value pairs inside the DependencyObject host instance. You must use Dependency properties if you need to create and apply properties on custom usercontrols, or change properties based on external inputs like Theme, Style, animation etc, or while applying data binding or set with a resource (static/dynamic) .
  • 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
  • Using Custom Document Template And Quick Parts To Get Column Values From SharePointNov 17, 2017. Quite often there is situation when user wants to save documents with metadata in SharePoint library and to accomplish this we can use document template, customize it and by using Quick parts in Microsoft office we can save Meta data in library and in Microsoft office documents.
  • Create App Using Xamarin.Android Using C# - Part FourNov 17, 2017. Xamarin.Android has native user interface controls. These controls can be easily added to Xamarin.Android apps using the Android Designer or programatically via XML layout files. Xamarin.Android exposes all of the user interface object properties and methods in C#.
  • Build Intelligent Apps with Microsoft Data PlatformNov 16, 2017. Learn how to build intelligent apps using Microsoft data platform and tools.
  • Creating A Data Science Virtual Machine(DSVM) On The Azure PortalNov 16, 2017. This article describes what a Data Science Virtual machine is and demonstrates how to create it in the azure portal.
  • How To Save Office 365 Email Attachment To OneDrive With Microsoft FlowNov 16, 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 one Service. It makes it practical and simple for line-of-business. The users build workflows that automatically do some business tasks and processes across applications and services.
  • Two Way Data Binding In Angular Without $scope Object Using MVCNov 16, 2017. Data binding is the most useful and powerful feature among any of the existing or upcoming software development technologies. It is actually a process that bridges a connection between the view and business logic of the application.Basically we will see one-way and two-way data binding with respect to AngularJS applications. But before we jump to that section we will try to learn something about the scopes in AngularJS.
  • Auto Complete with ngTagInput using Web API in AngularJSNov 16, 2017. AutoComplete,ngTagInput,Web API,AngularJS,AutoComplete in AngularJS using Web API
  • How To Use StringBuilder And File Class For .NET ApplicationNov 14, 2017. Here, I am going to share how and why should we create error log in our application.
  • Creating Azure WebJob To Access SharePoint Using Typescript And Node.jsNov 14, 2017. Create a new folder in the solution by the name 'src' and create index.ts file inside the folder. In this folder we will keep all the source files which will get executed when the Job runs. Remember to keep the index.ts at the root of the src and all other files (if any) keep them in the folder otherwise the job will fail.
  • 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.
  • Masking Sensitive Data With SQL Server 2016Nov 10, 2017. SQL Server 2016 has many features which you can use to make your data and application more secure, more maintained and easily retrieved as per your requirements. It has introduced both client side security such as Always Encrypted as well as server side security such as Data masking etc. In this post we’ll examine how Dynamic Data Masking can help secure our data.
  • How To Bind Data To Controls Inside Bootstrap Popup Using ASP.NET WebServicesNov 09, 2017. This article describes how to bind controls inside bootstrap popup using webservices in asp.net
  • How To Extract All Images From An Existing PowerPoint PresentationNov 09, 2017. This article will give you the steps to save all the images from a PowerPoint presentation file.
  • Azure Data Factory - ETL Solution To Azure DB And To Azure SQL Data WarehouseNov 09, 2017. In this article we will learn how to use Azure Data Factory to Extract, Transform, Load (ETL) data especially for the data warehousing purposes.
  • Angular Basics and Quickstart with CLINov 09, 2017. Imagine what it would be to manually add the configuration files required to bootstrap an Angular 4 application. It is painful, right? For beginners, it might become tedious to declare all these files and manually configure all these files to bootstrap the app. It wouldn't be a good idea to set up the configuration things rather than focus on the framework and its usage. Even for the advanced developer, it might not be a great way to do all these things manually. So, Angular CLI is the solution here
  • Working With View Components In ASP.NET Core MVCNov 09, 2017. View component is newly introduced feature in asp.net core MVC. It is very similar to partial view but it very powerful compared to partial view. It does not use model binding but works only with the data we provide when calling into it.
  • 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.
  • Power BI On-Premises Server Installation And ConfigurationNov 06, 2017. On October 31, 2017 Microsoft released the latest version of Power BI report server, in this version on-premises reports can connect to different data sources (SQL Server, Oracle, SAP HANA ...Etc.). Users can also use direct Query option or import data option and create schedule to refresh the imported data. This article will give the step by step process to install and configure a Power BI on premises server.
  • URL Routing Of ASP.NET MVC And ASP.NET Web FormsNov 06, 2017. Asp.Net MVC has route-based URLs which means URLs are divided into controllers and actions; and moreover, it is based on controller not on physical file.
  • If The Boot Configuration Data For Your PC Is Missing Or Contains ErrorsNov 06, 2017. The Boot Configuration Data (BCD) is a firmware-independent database for boot-time configuration data. It is used as new Windows Boot Manager. It replaces the "boot.ini" file that was used in the old Operating System. For more details check Windows startup process.
  • Retrieve User Profile Properties Using SPFx And PnP JS In SharePoint OnlineNov 05, 2017. SharePoint Framework is the new development model in which a lot of work has been going on since it went to General Availability on Feb 23, 2017. It is a page and web part model that provides full support for client-side SharePoint development, easy integration with SharePoint data and support for open source tooling. With the SharePoint Framework, you can use modern web technologies and tools in your preferred development environment to build productive experiences and apps in SharePoint.
  • How To Create A SQL Database In AzureNov 03, 2017. In this article you will see how to create an Azure SQL Database in the Azure portal. Azure SQL Database is a relational database-as-a-service which provides high performance, reliable and secure database used to build data-driven applications and websites.
  • Implementation Of Stack And Queue Using Linked ListNov 02, 2017. In this article, I will be discussing two data structures - Stack and Queue and their implementation using another data structure - Linked List.
  • Introduction To ASP.NET MVC Model BindingNov 02, 2017. Asp.NET MVC model binder allow you to map http request data with model. HttpRequest data means when user makes a request with form data from browser to controller at that time model binder works as middle man to map the incoming http request with controller action method.
  • 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.
  • Populating A ListView With Data Using Kendo Listview And Entity Framework In ASP.NET MVC 5Oct 31, 2017. Here, I am going to demonstrate how to load the data from a database to Kendo listview in ASP.Net MVC5.
  • Create Charts In PowerPoint Using C#Oct 31, 2017. When it comes to PowerPoint presentation, charts are an import thing. Because charts can visualize large amount of complex data, which is helpful for data comparison and analysis. This article focuses on how to create most commonly used chart types (including column chart, pie chart and combination chart) by using .NET Presentation library in your C# applications.
  • How To Use ServerSide Processing With jQuery DatatableOct 29, 2017. Create one WebService to Getdata(Here I am using asp.net WebService to get data). You can see my Solution Explorer . I have two web pages and one service, and the name of the service is webService.asmx.
  • Office 365 Public CDN OverviewOct 27, 2017. Microsoft has recently announced (over a months’ time ago now as I am writing this article) availability of Office 365 Public Content Delivery Network (CDN). This gives us the good option to host the static content such as JavaScript files, CSS, images, documents in CDN. The files in CDN will help better performance with SharePoint pages.
  • One-Way And Two-Way Data Binding With Examples In AngularOct 27, 2017. In Angular 2, Data Binding is mainly classified in two ways, namely One-Way binding (i.e. unidirectional binding) and two-way binding (i.e. bi-directional binding).
  • 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 Do 'LinkedIn Connection Analytics' Using Power BI Oct 26, 2017. Learn to use new free 'LinkedIn Connection Analytics' dashboard with Power BI.
  • Setting Or Retrieving Geotag In Media File In UWP With XAML And C#Oct 25, 2017. Reading this article, you can learn how to set or retrieve Geotagging in Media File in Universal Windows Apps development with XAML and Visual C#.
  • Creating A Comment Box Using Angular 1.0.7Oct 25, 2017. AngularJS is a JavaScript framework. It is a library written in JavaScript. AngularJS is distributed as a JavaScript file, and can be added to a web page with a script tag.
  • 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.
  • Basic Introduction To Power BIOct 17, 2017. In this article I will discuss the fundamental concepts of Power BI. So this article will cover basic knowledge on power BI, the need of power BI, the importance of data visualizations, the components of Power BI, the architecture of Power BI, the building blocks of Power BI & the cost of power BI tools.
  • Power BI - Get Data From SharePoint List / LibraryOct 16, 2017. In this article, we will explore two methods to get data from SharePoint List / Library in Power BI.
  • Get To Know The New Microsoft SharePoint Migration ToolOct 13, 2017. For many years SharePoint Migration has been a very challenging task for all the SharePoint professionals as it really requires a lot of planning, assessment and careful implementation to ensure that the data remains secure and it doesn’t get missed during the migration.
  • Let's Move 'On-Prem' Data Warehouse To 'Azure SQL Data Warehouse' With Redgate Data Platform Studio (DPS)Oct 13, 2017. In this article we will learn how to migrate ‘On-Prem’ data warehouse to the Cloud, specifically Azure SQL Data warehouse. I will share the lessons learned and some do’s and don’ts from my experience that may be helpful.
  • Read Excel File In C# WinFormOct 13, 2017. Here we are going to learn to read Excel files in C# windows form applications.
  • An Easy Way To Encode And Decode File In ASP.NETOct 13, 2017. In this article, I’ll explain a way to encode and decode a file in ASP.NET using C# and VB.NET with example.
  • ASP.NET Core 2.0 CachingOct 12, 2017. Caching frequently used data can improve the performance of a web application. For applications hosted on multiple servers, using distributed caching means the application can access data regardless of the instance server. Caching should be considered an alternate to using Session State.
  • Getting Started With Entity Framework Core - Database-First DevelopmentOct 12, 2017. This article is the first part of the series on Getting Started with Entity Framework Core. In this post, we will build an ASP.NET Core MVC application that performs basic data access using Entity Framework Core. We will explore the database-first approach and see how models are created from an existing database. We will also take a look at how classes become the link between the database and ASP.NET Core MVC Controller.
  • How To Send Notification Via SMS When Dropbox Is Modified With Microsoft FlowOct 12, 2017. This article helps you to learn how to notify someone via SMS when a Dropbox file is modified through Microsoft Flow.
  • 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)
  • ASP.NET Core 2.0 File ProvidersOct 11, 2017. ASP.NET Core provides an encapsulation of System.IO.File type in order to limit the access to file systems via PhysicalFileProvider type, which is an implementation of IFileProvider.
  • Logging Exception in Database Using CustomFilter ExceptionOct 11, 2017. As per request from one of my followers I am writing this article, which will explain how we can handle Errors in an MVC application. In this article I am also going to explain how we can log our exception message in our Data Base.
  • Shared Storage Using Azure File ServiceOct 10, 2017. In most cases, the virtual disks we are creating for an Azure VM are connected to that particular VM with a 1:1 relationship which can’t be accessed by another VM at the same time. In case you need a shared storage by multiple VMs you should use Azure File Shares. Azure File shares can be mounted concurrently by cloud or on-premises deployments of Windows, Linux, and macOS. This is mostly used in case of any requirement of something like a shared application setting or if you need to share any tools or utilities between developers and administrators.
  • Linked List Implementation In C#Oct 09, 2017. In this article, I will discuss one of the most important Data structures- Linked List.
  • What Is Version Control And Why You Should Use ItOct 09, 2017. In this article, we will learn what Version Control is, and what are the benefits of version control. Version Control means keeping the copies of your code or files from every stage in its lifecycle. Version control system allows us to manage all versions of our code with representing single version at a time.
  • How To Connect Facebook to Twitter With Microsoft FlowOct 08, 2017. Microsoft Flow is a cloud-based service. It allows us to react to an event in one place and do something with the data from that event in another one service.
  • Managing Virtual Machine DisksOct 08, 2017. In this article, we will see how to add additional data disks and scale existing in a Virtual Machine.
  • How To Implement Dependency Injection In MVC ProjectOct 07, 2017. Here I am going to explain how to implement dependency injection in MVC Project in detail including separate layers for getting data through Services and Repositories.
  • 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.

About Import-Data-from-CSV-file-to-DataGridView

NA
File APIs for .NET
Aspose are the market leader of .NET APIs for file business formats – natively work with DOCX, XLSX, PPT, PDF, MSG, MPP, images formats and many more!