C# Corner

Resources  
  • Roles And Responsibilities Of SQL Developer Dec 09, 2017. In this article, I have shared the Roles and Responsibilities of a SQL Developer.
  • Audit Made Easy Without Audit Log - Part OneDec 07, 2017. In Microsoft SQL Server, the activity of each of the database table is tracked in the other table and that is called the Audit trail or Audit log of the database table.
  • How To Control SQL Injection In PHPDec 07, 2017. This is an interview question, when a person showcases himself as the FULL Stack developer, it is very important that the developer should have base knowledge on the security aspects of the applications.
  • Object-Relational Mapper For SQLite3 In Node.jsDec 07, 2017. Node.js is getting more popular day by day and many frameworks and platforms are supporting Node.js for its high-performance web server development. In this post, you will learn the database development in Node.js with the popular ORM library; Sequelize.
  • 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.
  • 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.
  • 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.
  • How To Save Multiple Links In A List Column And UI On Custom List Form In Visual Web PartDec 06, 2017. In this article, we will discuss how we are storing multiple links in the list field and supporting the UI on custom list form in Visual web part
  • Creating Angular 5 App With Visual Studio 2017 - An Easy WayDec 05, 2017. There are multiple ways to create an Angular app with Visual Studio and this article explains one of the easiest and simplest ways to create Angular 5 App with Visual Studio 2017 using a template.
  • Creating A Chat Application In Node.js With Express, MongoDB, Mongoose And Socket.ioDec 05, 2017. In this article, we are going to create a chat application in NodeJS with the back end MongoDB. We will also be using Mongoose for creating the MongoDB models and Socket.io for making multi directional chats on multiple client window.
  • 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.
  • How To Delete Attachments Of SharePoint List Item Using Rest APIDec 05, 2017. I have created a custom list named “Attachments” in the host site and have added multiple items with attachments, now let’s say that we want to “Delete” the attachments on any particular item which we want.
  • 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.
  • Comparing Objects In C#Nov 29, 2017. In this article, we are going to compare two objects of the same class having collection property or multiple collection properties.
  • A Beginner's Guide To Windows Server SetupNov 29, 2017. All developers must be familiar with how to interact with a server for various project requirements. This server interaction varies depends on the project requirements. Some of may be just connecting to an SQL Server database server through an application, some of you may be hosting your application to an IIS server.
  • 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.
  • Getting Started With Kotlin - BasicsNov 29, 2017. Google announced Kotlin as an official language for Android Application development in Google I/O 2017.Kotlin is a statically-typed language, developed by JetBrains and Open source Contributors in the 2011, that runs on JVM(Java Virtual Machine) and is compiled to JavaScript source code. It is very suitable for server-side application development with full compatibility of Java frameworks. You can use multiple frameworks like - Spring, Vert.x, Ktor etc. for web application development.
  • 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.
  • 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
  • How To Build A Kubernetes Cluster On Azure Using KubesprayNov 26, 2017. The concept of sticking our compiled code into containers is becoming quite popular at the moment, and for very good reason. If you develop for the cloud, and don't use containers or similar technology now, then you should really take a look at whats involved. The huge benefits of using containerized infrastructure/deployment are being pushed by the cloud vendors, and also increasingly being recognized by mainstream enterprise as an all round good egg and something worth investing time and resources into embracing. Containers and 'server-less computing' are two technologies that most developers are going to have to embrace in the next short few years.
  • 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.
  • How To Create A Stored Procedure In SQL Server Management StudioNov 25, 2017. In this article you will learn about how to create store procedure in sql server’s SQL SERVER MANAGEMENT STUDIO and very informative information and interview questions and answers about store procedure.
  • 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.
  • Introduction To Suave With F#Nov 23, 2017. In this article, we will see how to construct a simple web application with the F# language and the Suave web server on Visual Studio Code.
  • 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.
  • Use SQL Server 2017 in Docker ContainersNov 21, 2017. How to use SQL Server 2017 on Docker containers to automate deployment using VSTS
  • Introduction To SQL Operations Studio And Connecting It With SQL ServerNov 20, 2017. Learn how to use SQL Operations Studio (preview) to connect to SQL Server, and then use Transact-SQL (T-SQL) statements.
  • Creating A SQL Database And SQL Server On The Azure PortalNov 20, 2017. This article shows how to create a SQL Database and Server on the Azure Portal and also the process of configuring the threat protection to our Database.
  • Dynamic Checkbox Functionality Using Angular In ASP.NET MVCNov 17, 2017. Checkboxes in AngularJS and asp.net MVC (server-side) application.
  • 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.
  • Auto Complete with ngTagInput using Web API in AngularJSNov 16, 2017. AutoComplete,ngTagInput,Web API,AngularJS,AutoComplete in AngularJS using Web API
  • Always Encrypted In SQL Server 2016 - Step By Step Guide - Part ThreeNov 15, 2017. This is part three of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see how to search on encrypted column and how to deploy a certificate to a different environment.
  • Everything You Want To Know About SharePoint 2016Nov 15, 2017. The new kid in town. Well, I hope you won’t mind when I say that SharePoint 2016 is the new kid in town considering the fact that it has been more than a year since Microsoft has released SharePoint Server 2016 and it has also announced the release of SharePoint Server 2019 a month back at Ignite Conference. However, there’s reason for me to still call SharePoint 2016 as the new kid in town because it still remains to be a cutting-edge platform for many SharePoint professionals out there and I’ve seen many organizations actively working on adapting SharePoint Server 2016 as the modern collaboration platform for their IT workspace.
  • What Is SQL Operations StudioNov 15, 2017. Learn and download SQL Operations Studio
  • 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).
  • Azure Table Storage In ASP.NET Core 2.0Nov 14, 2017. Add a class to encapsulate storage access. Add a private helper method to access storage
  • SSMS 2016 - Enhanced ScrollbarNov 14, 2017. Detailed description with screenshots of the enhanced scroll bar introduced in SSMS (SQL Server Management Studio) 2016.
  • Server Side Custom Paging In Angular-UI Grid Using Web APINov 13, 2017. In this article, you will learn how to implement server side custom paging using Angular UI-Grid with Web API and SQL Server database and stored procedure. In this article, I will demonstrate server side paging and sorting only, Filtering we should learn in next article.
  • DROP IF EXISTS In SQL Server 2016Nov 13, 2017. With this very small but handy tip, we’ll check the enhancement that has been made to DROP statement in SQL Server 2016. Earlier, we used to write additional checking logic to make sure that the object exists to drop. If we miss writing the check and if the object is not available, then we are being served with an error message. With SQL Server 2016, now we can check the existence of the respective object without any error being generated.
  • Automating Code Deployment With Azure And GitHubNov 13, 2017. In this article you will learn about how to use ‘App Services’ and exploit Github’s source code management functionalities and version control in order to automate the deployment of your software and maintain a record of prior changes in order to mitigate extra effort in pushing to production.
  • 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.
  • Introduction To Serverless Architecture In AzureNov 11, 2017. In this article, we will see how to create logic apps in Azure.
  • 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.
  • Introduction Of New Useful Features In SSMS 2016Nov 10, 2017. This article is an effort to list out a few exciting improvements that have been made to SQL Server Management Studio 2016. I believe, most of these new features can help improve the speed of our work and are more convenient to use the SSMS.
  • Enums In C#Nov 09, 2017. Suppose we are creating a program in which we have to use multiple named constants of similar type and on the basis of a particular constant we have to perform some operation. So what we normally do is initialize each named constant with a value. This may require a lot of effort if the number of constants is large. Also the look and feel of the code is not up to the mark. Have a look at the below program to understand more. The program contains months of the year. We have to put lots of effort to assign each month to a value.
  • 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.
  • Configuring SQL Server 2016 Express On LAN For C# Connection StringNov 08, 2017. In this article I will share my experience about configuring SQL Server 2016 Express on LAN for SQL connection using my C# application’s connection string
  • 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).
  • Retrieve SharePoint Lookup Field Value Via C#Nov 07, 2017. Get and set a SharePoint Lookup Field via SSOM C#. In this article, I have explained how to get & set SharePoint lookup field (single/multiple) values programmatically via Server Side Object Model in C#.
  • 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.
  • 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.
  • Step By Step Guide To Setup Sample SSAS Multi Dimension CubeNov 06, 2017. Create one Windows account and give full access to that account to read OLTP database or add an account on which SSAS Service is running and give full permission to that account for OLTP Database.
  • SQL Server 2016 - How To Detect The Current Cumulative Update/Service Pack That Was InstalledNov 05, 2017. In this article, I will explain how to detect the current Cumulative Update / Service Pack installed on your SQL Server.
  • Binding DropDown List Using Tuple In ASP MVCNov 05, 2017. Tuple is a generic static class that was added to C# 4.0 and it can hold any amount of elements, and they can be any type we want. So using tuple, we can return multiple values.One great use of tuple might be returning multiple values from a method. It provides an alternative to "ref" or "out" if you have a method that needs to return multiple new objects as part of its response.
  • 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.
  • Create An Azure SQL Database Using PowerShellNov 03, 2017. A resource group is a logical container into which Azure resources are deployed and managed as a group. So let's create a resource group for that using New-AzureRmResourceGroup command.
  • Introduction To IIS Server, HTTP Request Life Cycle, And Introduction To Application PoolOct 29, 2017. This article will give basic knowledge on IIS server, Http request life cycle, hosting a website in IIS & an introduction to application pool. Before we start on this let's have a quick look at what is a website & how it’s related to servers.
  • 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.
  • Missing 'Manage Delegates' Option In PWA Setting In Project Server 2016Oct 23, 2017. In this article, we will be fixing the issue Missing 'Manage Delegates' option in PWA Setting.
  • .NET Highcharts With ASP.NET MVCOct 22, 2017. This article will demonstrate how to implement DotNet Highcharts with Asp.Net MVC application. Highcharts is a JavaScript library to implement charting functionality like line chart, bar chart, column chart etc. We can create different types of charts using highcharts. Today with this article, I will try to show you how to create Highcharts in Asp.Net MVC from server side.
  • How To Return A Pair Of Closest Birthdates Using API, Multi Threading And MVC 5 Using C#.NETOct 18, 2017. This article demonstrates how to use multi-threading to return the name of 2 customers who have the closest birthdate. I also include how create API to add\ retrieve customer details from SQL database using tasks and how to use MVC to call and API to add a new customer.
  • T-SQL - Display Decimal Numbers As MoneyOct 17, 2017. In this article, we will show how to display decimal numbers as money with and without cents
  • Cloud Databases In Azure - Part TwoOct 16, 2017. In the first article of this series, I explained about how to create SQL Database in Azure. I recommend you read the first article.
  • Running Business Rule Only On Record CreateOct 16, 2017. We know that business rules are executed on form load and on change of the associated field, which means if we have business rule for any entity it will fire for new record as well for existing records when form loads.
  • ASP.NET Core 2.0 Response CompressionOct 16, 2017. When you’re unable to use the compression features of web servers (IIS, Apache, Nginx), ASP.NET Core provides an alternate option, Response Compression middleware. It’s performance won’t match server based compression features though.
  • How to use NPM Install (The Command) behind Corporate Proxy ServerOct 14, 2017. When you want to install packages for angular, angular CLI, typescript etc. via NPM using Command Prompt and you are working in an office environment where everything runs behind a corporate proxy server, you will most probably get the below exception.
  • Always Encrypted In SQL Server 2016 - Step By Step Guide - Part TwoOct 14, 2017. This is part two of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see the sample queries on encrypted columns and Limitations of Always Encrypted feature. In case, if you have missed out the first part of the series.
  • 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.
  • ASP.NET Core 2.0 Response CachingOct 13, 2017. As you navigate between a controller with caching enabled (Home) and another one without it (Movies), you’ll notice that time isn’t been updated i.e. it's not coming from server but rather from cache.
  • User-Defined Types In SQL ServerOct 13, 2017. When we are working with any programming language, we create user defined types as per our requirement. It is a better idea to have this feature in the SQL server.
  • Getting Started With SharePoint Framework For SharePoint 2016 On-PremisesOct 12, 2017. Once you have installed and upgraded the September 2017 Public Update for SharePoint 2016, you will be able to upload and deploy SharePoint Framework packages that contain web parts via the SharePoint App Catalog just as you would with SharePoint Add-ins.
  • 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.
  • T-SQL - Retrieve Task Hierarchy In Project ServerOct 12, 2017. In this article, we will show how to get the Task Hierarchy for a Specific Project in Project Server Database using SQL
  • Generate Access Token For Google Service Account Form JSON Or P12 Key In C#Oct 11, 2017. Service Accounts are used for server to server communication so users don't need to interact for Authentication. Let's learn to get access token for Google Service Account.
  • 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.
  • How To Use Ratings In Lists And Libraries Using Rating Settings, Server Side Coding And PowerShell CommandsOct 09, 2017. In this article I will discuss how to make use of ratings with your lists & libraries. Ratings are the features introduced by Microsoft which allow users to evaluate & rate the authors. Here I will explain how to use ratings on the lists & libraries.
  • Installing And Using .NET 4.7.x, .NET Core 2.0, And C# 7.x With VS 2017Oct 09, 2017. This article explains how to install and use .NET Framework 4.7, .NET Framework 4.7.1 & .NET Core 2.0 and troubleshooting if you are getting an exception while installing these latest components. This article also explains how to use the different versions of C#, e.g. C# 7, C# 7.1, C# 7.2 with Visual Studio 2017 and installing multiple instances of Visual Studio 2017 side by side.
  • 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.
  • Create Simple Azure FunctionOct 07, 2017. Azure functions allow up to run the code in a server-less manner. That means we do not have to create the VM to host the running code nor do we have to create a web application and publish code to web applications to run continuously.
  • Upload Multiple Files To SharePoint List On Single Click Using Angular And jQueryOct 07, 2017. This article explains how to upload more than one files into a SharePoint list on just single click using Angular and jQuery.
  • Always Encrypted In SQL Server 2016 - Step By Step Guide - Part OneOct 06, 2017. Lets say, we have a requirement to encrypt the PII data for an existing ASP.NET web application. Data needs to be encrypted at rest as well as on transit. Considering the existing PROD data, we need to identify an encryption approach that best suits the requirement. I'm going to share my experience in finding the encryption approach and implementing it on a sample database.
  • Create New Record To SharePoint List Using Angular With Rest APIOct 04, 2017. In this article, I am going to explain how to create SharePoint list item using Angular js. This will help to create a new record for long SharePoint lists which contain 100+ fields since we no longer specify field names in this code.
  • TextBox Validation Client Side And Server Side In ASP.NET WebFormOct 03, 2017. Validation is main thing to process the data. We store the textbox value into database table. Before moving to storing and storing data into database first we check the value of each textbox.
  • Selecting Lookup View Dynamically Using JavaScript In Dynamics CRM/ 365Oct 03, 2017. Lookup Views are shown when user clicks on Look Up More Records in any Lookup Field. In Dynamics CRM/365, Lookup Views are available in almost all entities, In newly created custom entities also it will be available by default. Lookup View of Account Entity is shown.
  • Develop Chatbot On NodeJS Platform Using Microsoft Bot Framework (Part Three) - Manage Conversation Using Multiple DialogsOct 03, 2017. In article Develop ChatBot On NodeJS Platform Using Microsoft Bot Framework (Part Two) - Manage Conversation Using Root Dialog, we have discussed how to handle conversation using root dialog in chatbot developed using Microsoft Bot Framework NodeJs SDK. In this article, we are going to handle the conversation flow with multiple dialogs instead of root dialog. We are also going to use trigger for dialogs.
  • How To Secure PII Data In SQL Server Using CLE (Column Level Encryption)Oct 03, 2017. PII (personally identifiable information) which is used to identify individual identity such as SSN, DOB, Bank Account Number etc. When you are working with financial application you face the scenario where you have to store the data in encrypted format, so no one can see the actual data.
  • NodeServices - Where JavaScript And .NET Meet Back On The Other SideSep 30, 2017. JavaScript is everywhere. It's in the browser, on the server, and it's climbing through your windows and snatching your people up. And because it's a fairly trivial language to pick up (but impossible to master), it can be extremely useful when you want to do something on the server.
  • Creating A Wave Audio Player Using WinMM The APISep 28, 2017. This is the part two of my three part trilogy concerning the use of windows mixer controls, playing an existing wave file through some available speaker, or recording and saving a wave file from an available audio input device such as a microphone. You might be wondering about the order I am presenting these tutorials. Simple, ...when my father taught me to play pool, we would often come upon a scenario where there are multiple shots available.
  • Understanding And Controlling The Windows Mixer APISep 27, 2017. This tutorial is going to be a three part introduction to playing and recording audio files using winmm.dll (a WinAPI). This first part is about understanding, opening and controlling windows mixers. The other tutorials will be about recording and playing audio .wav files. We will not be working with .mp3 (you can see the documentation to understand those functions.)
  • WebGrid Custom Paging Links To Avoid Load On Server Using Stored Procedure And ASP.NET MVCSep 27, 2017. I will show you how to fetch the data dynamically from the database and bind to the WebGrid control, using the stored procedure in MVC 4.0. In this blog, today, I will show you how to write code in ASP.NET MVC for implementation of WebGrid Control using Static Data. In later sessions, I will show you the process of using GridView Dynamically, that means using SQL Server data source.
  • How To Implement Angular Data Table With CRUD Using ASP.NET MVC And AngularSep 22, 2017. In this article, we will discuss how to implement Angular Data Table with (Insert, Update, and Delete) Short Form (CRUD) using Asp.net MVC + Angular JS in one page without any full page reloads. This table will be similar to JQuery Data Table and this one is implemented using Angular Data table.
  • How To Customize UI-Grid Height DynamicallySep 22, 2017. In this article, you will learn how to customize UI-Grid height dynamically based on record count list.
  • Basic PDF Export Using JQuery In ASP.NET MVC RazorSep 21, 2017. Here i will show you after insert records how to export the record in pdf format using jquery.
  • How To Create WebAPI In ASP.NET MVC With C#Sep 21, 2017. This article demonstrates how to create and use an insert update and delete record using Web API in MVC with C# technology
  • How To Migrate Your On-Premises / Enterprise Data Warehouse Into Azure SQL Data WarehouseSep 21, 2017. I will share how you can start migrating your data into the Azure SQL Data Warehouse
  • How To Secure PII Data In SQL Server Using .NET AssemblySep 21, 2017. PII (Personally Identifiable Information) is used to identify individual identity markers such as SSN, DOB, Bank Account Number etc. When you are working with financial applications you face a scenario where you have to store the data in encrypted format, so no one can see the actual data.
  • 35 Essential Basic-Advanced SQL Query-Questions Asked In Technical InterviewsSep 19, 2017. These are all query-based questions asked in tech interviews, including some simple looking tricky one liner SQL statements and joins.
  • Exposing Local Web Server To Internet Using NgrokSep 19, 2017. I was recently working on some bot framework applications where I wanted to test if my bot application was working properly with different available channels like Facebook messenger, Skype etc. But there was one problem. Before I could integrate my bot with different channels, I needed to publish my bot application and register it on http://dev.botframework.com/ site. Also the endpoint should support HTTPS. This is where ngrok comes into play.
  • Encrypt And Decrypt User Password In SQL Server DB Using C# Winform ApplicationSep 18, 2017. In this article we are going to learn how to maintain the user login details in sql server table with password encryption format and decrypt the user password and validate the credentials in login form.

About insert-multiple-record-in-sql-server-table

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!