C# Corner

Resources  
  • Include jQuery Library In A View Or Page In Different WaysJan 19, 2018. If you are using layout, you can include your bundle (render bundle) in your layout. The benefit of this approach is, you don’t have to use the @Scripts.Render in all the views where you use layout which already includes the @Scripts.Render section.
  • CRUD Operations In SharePoint Using REST API - CREATE OperationsJan 18, 2018. REST API is a powerful CSOM concept that can be leveraged in SharePoint for converting sophisticated business designs into working and efficient SharePoint Artifacts (Add-Ins, CSOM solutions, etc.). REST does not require any separate references for its working unlike other frameworks (SPservices!)
  • Toolbar In Xamarin.iOS Application ViewJan 17, 2018. In this article, we are going to create Xamarin application that contains toolbar item with respective tools and functionality. Tools like add, edit, refresh, search in form of icon or text can be applied on the toolbar and the required specific functionality can be added with its event.
  • ASP.NET Core 2.0 - How To Use Dependency InjectionJan 15, 2018. In this article, I'll show you the new feature introduced in ASP .NET Core that allows you to inject dependencies directly into a View using the dependency injection container.
  • Comparison Of Subquery And JoinsJan 15, 2018. Here, in this article, we are comparing the SQL Join and SQL Subquery.
  • Why Dynamic Query Is BadJan 15, 2018. In this article, we will be talking about Dynamic Query and why it is bad.
  • Explore Azure Cosmos DB Without Azure SubscriptionJan 10, 2018. Azure Cosmos DB emulator is an exciting tool for getting started with Cosmos Db. This allows us to play with Cosmos DB without even having an Azure Subscription. That means you can write Cosmos DB code in your .net application and view your data on emulator.
  • Learn Angular 4.0 In 10 Days - Pipes And ViewChild - Day FiveJan 09, 2018. In this article, we will discuss about the pipes and view child concepts in Angular 4.0.
  • How To Dynamic List View In Xamarin.FormsJan 07, 2018. This article is about Dynamic List View Image Resizing in Xamarin.Forms.
  • SearchBar View With SearchContent In Xamarin.Forms ApplicationJan 06, 2018. SearchBar view control is the control that provides you the way to search from the list of content. It has the events 'SearchButtonPressed', 'TextChanged' for performing actions respectively. You can give the list of items that are required to perform the search for the item based on conditions and suggestions you want.
  • Store And Retrieve Using FILESTREAM From SQL DatabaseJan 06, 2018. Hello friends today I will explaining you regarding storing and retrieving image, video and other document files from SQL server using FILESTREAM future. If you are new to FIELSTREAM then read my previous article FILESTREAM Feature In SQL Server.
  • Azure SQL Intelligence For Database Administrator And DeveloperJan 05, 2018. When interacting with large volumes of data, Azure SQL comes into the picture. SQL Azure is a cloud database service owned by Microsoft, which is based on SQL Server database technology.
  • How To Install And Start The Reporting Services SharePoint Service In SharePointJan 05, 2018. In this article, we will learn about "How to Install and Start the Reporting Services SharePoint Service in SharePoint".
  • FILESTREAM Feature In SQL ServerJan 04, 2018. Today I am explaining what FILESTREAM is and how to use FILESTREAM in SQL server.
  • Various List Operations With SharePoint Online List View Threshold LimitJan 03, 2018. In this article, we will learn about how we can work with SharePoint Online List view threshold. A myth with SharePoint List view threshold is a storage limit with the number of records, but it is not correct. List view threshold displays the number of record limits in SharePoint views.
  • Xamarin.Forms - Dynamic GridViewJan 02, 2018. This article demonstrates how to create Dynamic GridView using Xamarin.Forms. If you ever need to show something in a data-bound grid view that is not in your data source, just create that extra row dynamically.
  • R Services In SQL Server 2017Jan 02, 2018. Hello Everyone. In this article I will be demonstrating how to use R Services in SQL Server 2017. This article is intended for those who have a basic idea of R language. If you don't, still no worries. You can still go through and grab it easily. I will go into details of R language in some other article.
  • ASP.NET Core 2.0 Cookie AuthenticationJan 02, 2018. Cookie Authentication allows developers to hook into events at various lifecycle stages of the authentication process. For instance you could log successful sign-ins using OnSignedIn or use OnValidatePrincipal (runs on every request) to invalidate the user (e.g. if you want to force sign-out).
  • Routing And Navigation With Angular 5Jan 02, 2018. Angular routing helps navigation across the application from one view to another view, it also allows us to maintain the state, implement modules and load the modules based on the role of the user. Let’s see in this article how we configure the routing and some basic concepts with it.
  • Xamarin.Android - Working With Recycler ViewDec 30, 2017. In this tutorial, we are going to learn how to render a simple RecyclerView with a custom layout
  • How To Display Analog Clock Using BoxView In Xamarin.FormsDec 29, 2017. Although Xamarin.Forms doesn't have a vector graphics programming interface, it does have a BoxView. Although normally used for displaying rectangular blocks of color, BoxView can be sized, positioned, and rotated. This is enough to render a classic analog clock.
  • Setting Up Add-In Development Environment In SharePoint Server 2016Dec 26, 2017. In this article, I have explained how to configure Sharepoint add-ins development environment and create a simple hello world web part in s=Sharepoint server 2016 on-premises.
  • ASP.NET MVC 5 - Buttons In Datatables jQuery PluginDec 26, 2017. Table view is one of the most important and basic forms of presenting data on a web page. However, adding action to each row is equally important simply because action for each row leads to different results. Jquery Datatables plugin is one of the most used plugins, as I have demonstrated its integration in ASP.NET MVC5 - Datables Plugin Server Side Integration in one of my articles.
  • Checkboxes In Kendo TreeViewDec 24, 2017. From this article, you will learn how to implement the check boxes in kendo tree view.
  • Working With Kendo UI TreeList And Custom Template In ASP.NET MVC 5 Web ApplicationDec 24, 2017. In this article, I will demonstrate how to work with KendoTreeList View and custom template in ASP.Net MVC5 using Kendo UI and EF
  • Configure Data Gateway With SQL Server Database Using Recommended Or Enterprise ModeDec 23, 2017. In this article, we will discuss how we can configure Data Gateway for On-Premise SQL SERVER Database for Live Data Connection using Recommended Mode.
  • ContextMenu In Xamarin.Forms ApplicationDec 21, 2017. In this article, we will learn how to add a ContextMenu on the list view having cell items in Xamarin.Forms application.
  • How To Configure Data Gateway With SQL Server Database For Live Data Connectivity Using Personal ModeDec 21, 2017. In this article, we will discuss how we can configure Data Gateway for On-Premise SQL SERVER Database for Live Data Connection using Personal Mode.
  • Querying ConsmosDB Using SQL APIDec 19, 2017. Here, we can find the first name and number of pets from child entity but to find out the last name we need to refer to family entity. To select last name along with first name we need to use join operator In DocumentDB
  • Stored Procedures Vs User Defined Functions And Choosing Which One To UseDec 19, 2017. In SQL Server, we usually come across queries, tables, views, stored procedures and functions. People often wonder what are the real differences between User Defined Functions (UDF) or simply functions and stored procedures or just procedures. There are two types of functions: Built-in and user defined. Built-in functions cannot be modified where as you can create and modify your own UDF. To utilize the full advantage of these features, we should understand their capabilities and what we can do with them and what we cannot. I am going to explain this in terms of SQL Server.
  • Getting Started With Apache SparkDec 18, 2017. In Big Data, Hadoop components such as Hive (SQL construct) , Pig ( Scripting construct), and MapReduce (Java programming) are used to perform all the data transformations and aggregation . Now with Apache Spark the same is being achieved with many more advantages like unified API performance, and support for multiple languages, 10X-100X faster than MapReduce.
  • Export SQL Result To A Text FileDec 18, 2017. This article gives an overview of how to export SQL query results to a text file.
  • Kendo Tree View Remote DatabindingDec 17, 2017. From this article, you will learn how to implement the Kendo tree view with remote data-binding.
  • MVVM Lite For Data Binding In Xamarin.FormDec 16, 2017. We are using MVVM light that will provide the facility to implement Model-View-ViewModel. This is the quick way for development of an application and also provides a user the facility to customize and design the application.
  • Xamarin.Android - Stop Watch Seconds And MillisecondsDec 14, 2017. In this article, I shall show you how to make a simple stop watch app in Xamarin Android. A stopwatch is a handheld timepiece designed to measure the amount of time elapsed from a particular time when it is activated to the time when the piece is deactivated. A large digital version of a stopwatch designed for viewing at a distance, as in a sports stadium, is called a stopclock. In manual timing, the clock is started and stopped by a person pressing a button.
  • Create Your First Azure SQL Database Using Azure Portal Dec 14, 2017. In this article, we will talk about how we can create a new database in Azure SQL. We will learn each step in a brief manner. Most of the time when we are beginner in Azure we always have a question how we can create a database in Azure SQL. It’s very easy and simple.
  • 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.
  • Remove Duplicate Rows In SQL Server Using CTEDec 11, 2017. In this article, you will learn how to remove duplicate rows in SQL Server using CTE.
  • Partial View In ASP.NET MVC Using Entity FrameworkDec 10, 2017. A partial view is same as user control in ASP.NET MVC that is used for code re-usability. Partial views help us to reduce code duplication. Hence partial views can be used for views like as Header and Footer views.
  • Xamarin.Android - Gesture Overlay ViewDec 10, 2017. In this article, I shall show you how to create Gestures using Gesture Overlay View in Xamarin Android
  • 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.
  • 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.
  • Tips And Best Practices To Improve ASP.NET Web Application PerformanceDec 01, 2017. This article suggests you a few tips to improve the performance of an ASP.Net application. There are many more things which may ensure a better performance and faster response time for a web application. I am discussing only a few of the best practices that will help you avoid some unwanted performance hitters from your application. So, you will have a more light weight application which runs quicker and gives a better response time.
  • Charts In ASP.NET MVC Using Chart.jsDec 01, 2017. This article demonstrates how to create charts in ASP.NET MVC using Chart.js and C#. This article starts with how to use Chart.js in your MVC project. After that, it demonstrates how to add charts in a view.
  • 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.
  • View Product Details Using Kendo ScrollView In ASP.NET MVC5 With Entity FrameworkNov 29, 2017. Here, I will demonstrate how to work with Kendo ScrollView to View the product details from a database using Entity Framework in ASP.Net MVC5
  • 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.
  • 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.
  • Client Side Routing Using Angular In MVCNov 29, 2017. AngularJS supports a Single page application routing module called ngRoute. When a user requests a specific url, the routing engine fetches that url and renders the view based on the defined routing rules. AngularJS appends '/#/' to the url to redirect to a particular url using $location service. For example, to redirect to '/Article', the url would be http://localhost/#/Article.
  • 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.
  • Uploading Ionic App On Ionic View In Ionic ProNov 23, 2017. Some of the ionic commands are deprecated in the newer version of ionic, which is called ionic pro. One of them is “ionic upload” that was used to upload the ionic app in ionic view for testing purposes.
  • Create Views In SharePoint ListNov 21, 2017. In this article, I will share the steps to create a View in SharePoint list. Already we have gone through how to create a list and their features.
  • 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.
  • Navigation In Angular Between Different RoutesNov 17, 2017. This article explains the navigation from one component's view to another component view with the help of router's navigation.
  • Creating CRUD API In ASP.NET Core 2.0Nov 17, 2017. ASP.NET Core gives a unified mechanism for creating MVC and Web API application. The key difference is that Web API will return JSON (or XML) and HTTP status codes instead of views, in order to communicate with the client.
  • 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
  • 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.
  • What Is SQL Operations StudioNov 15, 2017. Learn and download SQL Operations Studio
  • SSMS 2016 - Enhanced ScrollbarNov 14, 2017. Detailed description with screenshots of the enhanced scroll bar introduced in SSMS (SQL Server Management Studio) 2016.
  • 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.
  • 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.
  • How To Lock Objects In Power BINov 11, 2017. Sometimes, there is a situation where when we open a report and click on any visuals, it accidentally nudges a chart a little bit to the right or left. Sometimes, by mistake when end user viewing a report, arrangement of visuals scatters little bit. Microsoft rolls out one new amazing feature to resolve this issue and that is Lock Objects in Power BI.
  • 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.
  • 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.
  • ASP.NET Core 2.0 MVC Distributed Cache Tag HelperNov 09, 2017. Cache and Distributed Cache Tag Helper help improve performance of your application by caching view’s content, either in-memory or in a distributed cache (e.g. Redis). Distributed Cache Tag Helper uses IDistributedCache to store contents in a distributed cache. To learn more about distributed caching, please refer to an earlier post here.
  • 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.
  • 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.
  • 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
  • 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.
  • 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.
  • ASP.NET Core 2.0 MVC AreasNov 06, 2017. Razor pages inside Areas folder can use the Layout page located outside it (e.g. in /Views/Shared folder). You can define a separate Layout page for each Area too. Yet another approach is to define a common Layout page outside Areas folder and Layout pages inside Areas folder and use them as their layout, creating a nested Layout page structure. Below is a Layout page for Area2 that uses shared layout page (note you need an absolute path to shared layout).
  • Limitations To Be Aware Of In Microsoft TeamsNov 05, 2017. Since Microsoft Teams is officially backed up by an Office 365 group, restricting the access to create an Office 365 group will also restrict the creation of a Team in Microsoft Teams. As a result, users won’t be a to see “Add a Team" button in Microsoft Teams.
  • Get Master Page Control Value In Content PageNov 05, 2017. Asp.Net Master page helps us to create a consistent view for the pages. Master page behaves like a container and parent page of Content page. In your application you can add numbers of Master page depending upon your project requirement and layout.
  • ASP.NET Core 2.0 MVC View ComponentsNov 05, 2017. View Components are special types of views that are rendered inside other views. They are useful for reusing parts of a view or splitting a large view into smaller components.
  • 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.
  • 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.
  • 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.
  • ASP.NET Core 2.0 MVC Partial ViewsNov 03, 2017. Partial views are special type of views that are rendered inside other views. They are useful for reusing parts of a view or splitting a large view into smaller components.
  • ASP.NET Core 2.0 MVC Layout PagesNov 02, 2017. Layout page is added to the Views/Shared folder and is named (as a convention) _Layout.cshtml. There can be more than one layout pages in your application too.
  • Dependency Injection Into Views In ASP.NET Core MVCNov 01, 2017. The dependency injection in ASP.net core is not limited to middleware, controller, and models. It also supports dependency injection into view.
  • ASP.NET Core 2.0 MVC Dependency Injection In ViewsNov 01, 2017. In ASP.NET Core dependency injection is not limited to middleware, controllers and models etc. Views can also benefit from the services configured in the service container.
  • 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.
  • 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.
  • 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.
  • 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
  • Overview Of Partial View In ASP.NET MVCOct 11, 2017. In ASP.NET MVC, View gets activated or executed with the help of a controller. All the incoming browser requests first knock to the controller then controller functionality will decide which view or action should be executed.
  • 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.
  • Getting Started With ASP.NET Core MVC Apps Using VS CodeOct 05, 2017. In this article, we will discuss how we can create a HelloWorld app with ASP.NET Core 2.0 using Visual Studio Code. We will learn how to create an ASP.NET Core MVC application, how to create new Controller, how to create new View, and how to run the HelloWorld app etc.
  • 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.

About Limitations-of-View-in-SQL

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!