C# Corner

 
 
 
 
Resources  
  • 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.
  • Store Images In App Directory In Xamarin iOSSep 21, 2017. In this article, you will learn how to store images in the App Directory in Xamarin iOS, using Xamarin Studio.
  • Adding Check Box Functionality In An Android App Using Android StudioSep 21, 2017. In this article, I will show you how to create am Android app using Android Studio. Android Checkbox is a type of two state button, either checked or unchecked. There can be a lot of usage of checkboxes. For example, it can be used to know the hobby of the user, activate/deactivate the specific action etc.
  • Create SMS Android App Using Android StudioSep 21, 2017. In this article, I will show you how to create a pop up menu Android App using Android Studio. SMS stands for Short Message Service and is also commonly referred to as a "text message". With a SMS, you can send a message of up to 160 characters to another device. Longer messages will automatically be split up into several parts. Most cell phones support this type of text messaging.
  • 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 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
  • Purchasing A New Service To Your Office 365 TenantSep 21, 2017. This is going to be a very simple article where I’ll be describing about how to add a new service to your Office 365 tenant. Let’s say there comes a scenario where your organization has been using Office 365 for quite some time and all of a sudden, the business shows interest on a new Office 365 service then you need to follow the steps mentioned in this article below to purchase that new service for your existing Office 365 tenant.
  • How To Control An LED Using KeypadSep 21, 2017. In this article we are going to see how to add an additional key pad library. We will see how to control an LED using keypad by assigning a password character to it.
  • Store Photo In Backend Using Entity Framework In MVC Razor And BootstrapSep 21, 2017. Here i will show you image details will be shown along with user name. This one a sample exmaple of student management system In mvc and bootstrap.
  • 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.
  • CRUD Operation In ASP.NET Core MVC Using Visual Studio CodeSep 21, 2017. In this article, I am going to explain how to create a basic web application using ASP.Net Core MVC and Visual Studio Code in Windows System.
  • Pop Up Menu Android ApplicationSep 20, 2017. In this article, I will show you how to create a pop up menu Android App using Android studio. Android Popup Menu displays the menu below the anchor text if space is available otherwise above the anchor text. It disappears if you click outside the popup menu.
  • Create Instant Alarm Android App Using Android StudioSep 20, 2017. In this article, I will show you how to create an Instant Alarm Android App using Android studio.
  • Gallery Android App Using Android StudioSep 19, 2017. In this article, I will show you how to create an Android App using Android studio. Gallery is either in a building or on the internet, where photographs are on display.
  • What Is New In iOS 11?Sep 19, 2017. iOS 11 sets a new standard for the world’s most advanced mobile operating system. Your apps can now become more intelligent using the power of machine learning with Core ML. You can create incredible augmented reality experiences with ARKit. And you can deliver a more unified and immersive user experience with new multitasking features, including drag and drop for iPad, the new Files app, new camera APIs, new SiriKit domains, Apple Music integration, and more
  • Create A Website Having Azure Active Directory Authentication Using Visual StudioSep 19, 2017. Azure Active Directory (Azure AD) is Microsoft’s multi-tenant, cloud based directory and identity management service. Azure AD combines core directory services, advanced identity governance, and application access management. Azure AD also offers a rich, standards-based platform that enables developers to deliver access control to their applications, based on centralized policy and rules.
  • AVPlayer In Xamarin iOSSep 19, 2017. In this article, you will learn how to play videos using AVPlayer in Xamarin iOS, using Xamarin Studio.
  • CRUD Operations In MVC Using Entity Framework With AJAX Call, jQuery, And All ValidationsSep 19, 2017. This article describes how to perform basic CRUD operations in an Asp.Net MVC application using Entity Framework with Ajax call and j query. with using Datatable Grid ,Toaster messagebox and also Bootstrap css.
  • Custom Paging In Angular-UI GridSep 19, 2017. In this article, you will learn how to implement custom paging using Angular UI-Grid in MVC application with Web API.
  • 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.
  • Xamarin.Forms Tip - Implement Show/Hide Password Using EffectsSep 19, 2017. While developing login pages, we usually get a requirement that there should be an icon in password entry to show/hide password while entering the password. While looking for a solution to this requirement, I found that most of the implementation is done using custom controls whereas we can do this kind of small platform-specific customization using effects. Last year, I wrote this article about implementing custom fonts using effects so I thought let's try this also using the same tecnique.
  • Learn Universal Windows Programming Via Modern C++ (Check Box)Sep 19, 2017. In the button control, we are using the IInspectable to set the content of the text. How do we get the value from the IInspectable interface ? By IPropertyValue; using the “as” operator, we can convert from IInspectable to IPropertyValue.
  • 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.
  • Dependency Injection - Part 7 - Service Locator PatternSep 18, 2017. Service locator pattern is one of the most commonly used patterns. In general, this pattern is used along with other patterns like Adapter Pattern, Observer Pattern, Dependency Injection Principles and many more. In this post, however, we will be talking about its use with dependency injection, which is one its many uses.
  • Serve Static Files In ASP.NET Core Using Visual Studio 2017Sep 18, 2017. This article explains about static files and how to set default page using static files in ASP.NET using Visual Studio 2017 in a step by step way.
  • 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.
  • 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.
  • Fetch User Details And Profile Picture From Person Or Group Field Using REST APISep 18, 2017. In one of my projects (on Office 365) I have a requirement to scroll key contacts of a project with the use's Full Name, Department, Job Title, Phone (Work/ Mobile) and Picture URL. Since all contacts are internal employees I don’t have to input user details, I just need a person and group field in a list to capture the user.
  • Convert Rows To Columns Using Dynamic Pivot In SQL ServerSep 17, 2017. In this article, we will show how to convert rows to columns using Dynamic Pivot in SQL Server.
  • Create Log Backup Maintenance Plan In SQL Server 2016Sep 17, 2017. In this article, we will explain how to take log backups frequently by creating a Log Backup Maintenance Plan in SQL Server 2016
  • Build Chat Application On MEA2N Stack - Part TwoSep 17, 2017. In the previous part of the article series, Build Chat Application On MEA2N Stack – Part One, we built a basic chat application on Node.js platform using Express, Angular 2 and socket.io. In this article, we are going to use MongoDB Atlas for saving our chats and retrieving history whenever user requests it.
  • App That Changes Background And Audio Player In Android, Using Android StudioSep 17, 2017. In this article, I will show you how to change background and audio player Android App using android studio.
  • Use Of Slicer In Power BI And Its Integration In SharePoint OnlineSep 17, 2017. Power BI is a Microsoft tool which provides many types of Visual Reports such as Clustered Column Chart, Clustered Bar Chart, Pie Chart,Donut Chart,Gauge,R script Visual, Tree map, Filled Map, Waterfall Chart, Scatter Chart, Slicer and many more. Among these I will be demonstrating a slicer which can be used to filter a tabular report and other reports.
  • Creatively Common ResourcesSep 15, 2017. Some people hate designing things, and that's okay. But one thing that they might hate more is being sued for copyright infringement (for using content that someone else created without their expressed permission).
  • Using MPMoviePlayer In Xamarin iOSSep 15, 2017. Xamarin is a platform to develop cross-platform and multi-platform apps (for example, Windows Phone, Android, iOS). In Xamarin platform, the code sharing concept is used. In Xamarin Studio, Visual Studio is also available.
  • Two Ways To Get Data From Entity FrameworkSep 15, 2017. In this article, you will learn about two basic ways to get data from Entity Framework and display data in angular UI-Grid using MVC application with Web API.
  • Print Dialog And Print Preview Tools Using Entire Windows Form To PrintSep 15, 2017. In this article, we will discuss how to print an entire Windows form using print dialog & print preview tools step-by-step in a Windows Forms application step-by-step.
  • Create Bluetooth Android Application Using Android StudioSep 15, 2017. Android is one of the most popular operating systems for mobile. In this article, I will show you how to create Bluetooth android applications using Android studio.
  • Multiple Pages On The Form Using Panel Control In A Simple Windows Forms ApplicationSep 15, 2017. In this article, we will learn how to show multiple pages on the form using Panel Control in a simple Windows Application.
  • Change Android Application Icon Using Android StudioSep 15, 2017. In this article, I will show you how to change the Android application Icon using Android studio. Icons are part of the graphical user Interface of the mobile application.
  • CRUD Operation In ASP.NET MVC Razor Using SignalR And Entity FrameworkSep 15, 2017. SignalR is a library for ASP.NET developers that simplifies the process of adding real-time web functionality to applications.
  • Android Application To Set Silent Mode, Ringer Mode, And Vibrate Mode In A PhoneSep 15, 2017. Android is one of the most popular operating systems for mobile. In this article, I will show you how to set silent mode, ringer mode, vibrate mode in an Android application using Android studio.
  • How To Show Interstitial Ad Every 20 Seconds In An Android ApplicationSep 14, 2017. Android is one of the most popular operating systems for mobile. In this article, I will show you how to show interstitial ads every 20 seconds in an Android application using Android studio.
  • Create Voice Search Android Application Using Android StudioSep 14, 2017. Android is one of the most popular operating systems for mobile. In this article, I will show you how to create Voice Search android application using android studio
  • Rating Bar In Xamarin iOSSep 14, 2017. In this article, you will learn how to create a Rating Bar in Xamarin iOS, using Xamarin Studio.
  • Learn Universal Windows Programming Via Modern C++ (RadioButton)Sep 14, 2017. RadioButton is used to allow to the user select single items, whereas checkbox allows users to multiselect.
  • Create Immutable Type In C#Sep 14, 2017. A public constructor that accepts initialization data is required so that the client can pass-in minimum state for the type to be valid. Private constructor, on the other hand, is used by methods to construct a new object and set its entire state.
  • Create Text To Speech Conversion Android Application Using Android StudioSep 14, 2017. Android is one of the most popular operating systems for mobile. In this article, I will show you how to create a text to speech conversion Android application using Android studio.
  • Azure SQL Data Warehouse - Why Enterprises Should Now Consider It SeriouslySep 14, 2017. Today we will explore some of the reasons why enterprise should choose Azure SQL Data Warehouse.
  • SQL Server DB Backup Using Stored Procedure In WinForm ApplicationSep 14, 2017. In this article we are going to learn how to get database backup using stored procedure in SQL server in C# Winform applications.
  • GitHub Extension In Visual Studio 2017Sep 13, 2017. In this article, I will explore the GitHub Extension for Visual Studio 2017. GitHub is a web-based graphical interface Git or version control repository that mostly used for code. It provides for each project access control and several collaboration features like bug tracking, feature requests, task management, and wikis.
  • Using jQuery DataTables Grid With ASP.NET CORE MVCSep 13, 2017. In this article, we are going to learn how to use Client side Grid (DataTables Grid) with ASP.NET Core MVC in a step by step way.
  • How To Insert Form Data In Multiple Table In DatabaseSep 13, 2017. In this article, we gonna learn about how to insert from data in multiple tables using jquery ajax in asp.net web application.In real time applications it is not a good practice to save all customer data in one table.They save data in multiple tables and link them using relations(using foreign keys).
  • Build Chat Application On MEA2N Stack - Part OneSep 13, 2017. In this article we are going to build a basic chat application on NodeJs platform using Express and Angular 2. For saving chat history we will use MongoDB. We will be using socket.io for communication between server and client.
  • How To Create A Calling Application In Android Using Android StudioSep 12, 2017. Android is one of the most popular operating systems for mobile. In this article, I will show you how to create a Calling Application in Android Using Android Studio.
  • How To Create A Camera Application In Android Using Android StudioSep 12, 2017. Android is one of the most popular operating systems for mobile. In this article, I will show you how to start the camera application in Android using Android Studio
  • Update Managed Metadata Field Using SharePoint Designer 2013 WorkflowSep 12, 2017. In this article, I am going to explain how we can update a managed metadata field using SharePoint 2013 Designer Workflow. This solution will work for both SharePoint 2013 On-Premise and SharePoint Online (Office 365). I tested the below solution in Office 365 environment.
  • Create TimePicker Android App Using Android StudioSep 11, 2017. Android is one of the most popular operating systems for mobile. In this article, I will show you how to create a TimePicker Android application using Android Studio.
  • ASP.NET MVC CRUD Operation Using Entity Framework Without Writing Single CodeSep 11, 2017. Here, you will learn to do CRUD (Create,Read,Update and Delete) operations in MVC using Entity Framework without writing a single line of code.
  • Getting Started With Conversational Forms And FormFlow Using Microsoft Bot FrameworkSep 11, 2017. In this article, I will help you to understand how to use Bot FormFlow and how you can use it to collect information from the users. We are creating a sample demo Bot for bus booking bot.
  • How To Add Android Exit Dialog To Android App Using Android StudioSep 11, 2017. Android is one of the most popular operating systems for mobile. In this article, I will show you how to add Android Exit Dialog to Android App Using Android Studio.
  • Use Of HttpResponseMessage In WebAPISep 11, 2017. Here, you will learn the uses of HttpResponseMessage WebApi. For better understanding we will go step by step with simple examples.
  • Create Calendar Android ApplicationSep 11, 2017. Android is one of the most popular operating systems for mobiles. In this article, I will show you how to create a Calendar android application. Calendar is an important thing to handle the events and commitments. So, I will show you how to create calendar in Android applications using android studio.
  • SharePoint 2013 - On Premises - Powershell Script To Import Termsets On Given Site From .csv File In Specific FolderSep 10, 2017. In this article I’ll explain how to import multiple termsets using .CSV file from one specific folder.
  • Create Web Browser Android Application Using Android StudioSep 10, 2017. Android is one of the most popular operating systems for mobiles. In this article, I will show you how to create a Web Browser android application using android studio.
  • Working With Azure Tables - Part TwoSep 09, 2017. Let us look at the basic sample, which retrieves the Azure table data into the applications using Node JS.
  • Creating Drawer Layout Using Material Design In Xamarin.AndroidSep 09, 2017. In this article, you will learn how to create Drawer Layout using Material Design in Xamarin.Android.
  • Azure Cosmos DB With SQL Query Cheat Sheet PDFSep 08, 2017. Microsoft Azure Cosmos DB supports querying documents using SQL (Structured Query Language) as a JSON query language. Cosmos DB is truly schema-free. By its commitment to the JSON data model directly within the database engine, it provides automatic indexing of JSON documents without requiring explicit schema or creation of secondary indexes.
  • Data Mining And Market Basket ImplementationSep 08, 2017. This article talks about the major techniques which are used in data mining to extract raw data for the following steps like data cleaning, data pre-processing, etc. and constructing useful datasets which are used for prediction.
  • 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.
  • Getting Started With Bing Emotion APISep 08, 2017. In this tutorial, we will learn how to use Bing Emotion API. In our previous example of the cognitive service demo, we had combined two cognitive services, Bing Speech API and Bing Emotion API, so as to find images using speech to text (STT). To extend this demo, we will be using Bing Emotion API which will detect the emotions of a person from the image that we had searched using Bing Image Search API.
  • SharePoint 2016/2013/Online - Sites Health Monitoring By PowerShell AutomationSep 08, 2017. In this article, we will discuss a simple yet powerful automation technique using PowerShell that will try pinging the Site and if it fails, it will send the email notifications to the designated SharePoint Admins for the Site.
  • Visual Studio Team Service - Trigger A Build Using Any HTTP ClientSep 07, 2017. In this post, we are going to see how easily we can trigger a new build in VSTS from any of our widely used HTTP clients likeFfiddler or Postman.
  • Create TableView In Xamarin.iOSSep 07, 2017. In this tutorial, I am going to share how to create a table view in Xamarin IOS applications using C# and how to use navigation controller in our application.
  • How To Consume Web API Through SSIS PackageSep 07, 2017. In this article, I have illustrated the purpose of SSIS with Web API. It shows how SSIS can use Web API to do certain operations, like updating the database table based on Service response, and process the data, etc.
  • Find Out Creation And Modification Date Of Database Objects Like Tables And Stored ProceduresSep 07, 2017. Database Object refers to Table, Stored procedure, View, Function etc.; in other words, all the elements that are created for data storage and manipulation.
  • Aspect Oriented Programming In C# With RealProxy classSep 07, 2017. Example of implementing logging using RealProxy class.
  • Automation Of SharePoint Search Crawl Using PowerShell Scripts - Part OneSep 07, 2017. In this article series, you will learn how to create a new content source in SharePoint Search and automate the Crawl using PowerShell scripts.
  • UIToolbar In Xamarin.iOSSep 06, 2017. In this article, you will learn how to Create a Tool bar View Using UIToolbar in Xamarin iOS, using Xamarin Studio.
  • How Should We Store Images And Blob Files In SQL ServerSep 06, 2017. There is always a requirement from developers: How should I store images and BLOB files in SQL Server ? In this post let's explore the data types and methods used for storing Binary Large Objects also know as BLOBs, such as images and sounds, into SQL Server.
  • Getting Started With Bing Speech API In WPF ApplicationsSep 06, 2017. Cognitive services are a set of APIs that are designed to democratize artificial intelligence by enabling systems to see, hear, speak, understand and interpret our needs using natural methods of communication.
  • Getting Started With ASP.NET Core And Angular 4 Using WEB APISep 06, 2017. In this article, let’s see how to get started with ASP.NET Core and using Web API. Select depending on your need and install the Visual Studio 2017 on your computer. If you have already installed Visual Studio 2017 then skip this part.
  • CRUD Operation Using Entity Framework In Windows Form ApplicationSep 06, 2017. In this article, we are going to learn how to perform CRUD operations using Entity Framework in the Windows Forms Application.
  • Automation Of SharePoint Search Crawl Using PowerShell Scripts - Part TwoSep 06, 2017. In an earlier part of this series you have learned how to create content source and select the appropriate option for each category. In this continuation you will understand how to create PowerShell scripts to automate Crawls.
  • Swift Programming - Zero To Hero - Part FourSep 06, 2017. In this article, we will learn about arrays and accessing arrays using looping statements
  • Creating A Mini Browser Using Visual StudioSep 06, 2017. In this article, we will be creating a mini browser using Visual Studio.
  • Windows Forms Application C# - Splash Screen With Metro FrameworkSep 06, 2017. In this article, we will discuss how to create a splash screen using Metro Framework step-by-step. We will create a progress bar to load any process in a Windows.Forms application. The splash screen actually displays at the process running time.
  • Deep Dive Into Microsoft AzureSep 06, 2017. Microsoft Azure is a growing collection of integrated cloud services which developers and IT professionals use to build, deploy and manage applications through our global network of datacentres. With Azure, you get the freedom to build and deploy wherever you want, using the tools, applications and frameworks of your choice.
  • Web API Token Based Authentication With Angular - Part OneSep 06, 2017. Authentication is a vital process in system programming. Authentication means verifying the user who is accessing the system. Today we are using modern devices that have different types of Apps or software and sometimes we directly access the website from browser. To access this application, we probably need to pass our credentials and these systems verify it. If you are valid user then it will allow accessing the system otherwise not.
  • ASP.NET Core 2.0 MiddlewareSep 06, 2017. Create a Hello World app using ASP.NET Core Middleware. Middleware components are called in the order they appear in Configure() method; i.e., the order in which they're added to the pipeline. The response, on its way back to the client, also passes through the same middleware pipeline.
  • New String Function In SQL Server 2017Sep 06, 2017. It requires one separator argument and a minimum of two arguments otherwise it raises an error. All the arguments are implicitly converted to string types and then they are concatenated.
  • Understand Serverless Architecture In AzureSep 05, 2017. This article will give an overview about the server-less architecture functionality present in Azure using Logic App.
  • Getting Started With Raspberry Pi - How To Use BreadboardSep 04, 2017. In my previous article – Understanding Raspberry Pi - GPIO, we talked in about GPIO (General Purpose Input Output). In this article we will discuss about a handy tool – Breadboard – It a must tool for everyone working on building simple to complex circuits and also must when using Raspberry Pi.
  • How To Backup A Mirrored Database Using SQL AgentSep 04, 2017. Database mirroring is a primarily software solution for increasing database availability. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model. The simple and bulk-logged recovery models do not support database mirroring. Therefore, all bulk operations are always fully logged. Database mirroring works with any supported database compatibility level.
  • Getting Started With Azure SchedulerSep 04, 2017. Azure Scheduler allows you to describe actions to run in the cloud. You can schedule and run the actions automatically. You can schedule the scheduler by using Rest API or azure PowerShell.
  • Construct Readable XML Output From SQL Query From Two Or More Tables Using “For XML PATH” StatementSep 04, 2017. In my previous article I discussed about how to get a XML format output from query and process that by using XML AUTO statement, and I give different types of “for XML”.
  • Connecting To MySql Database In StrapiSep 04, 2017. This article helps you to create a connection to the My SQL database using the Strapi; this is an article for the beginners where the basic connection can be created with the existing MySQL database.
  • Load Testing Web Service Using Visual StudioSep 04, 2017. Web Services are the more commonly developed and used to expose the APIs for other systems to consume. Number of external systems consume the web services on a frequent basis.
  • User Guide To Enroll iOS Device With Microsoft Intune And Configuring Outlook AppSep 04, 2017. If your company or school uses Microsoft Intune for Mobile Device Management and Mobile application management, you can enroll your iOS device to get access to company email, files, and other resources. When you enroll your devices, your IT department can manage the resources, keep them secure, and give you the freedom to use your preferred device to get your work done.
  • Create Timer Task Application In Xamarin.Forms Using Visual StudioSep 04, 2017. Xamarin is the best cross platform tool to develop mobile applications. It provides cross platform app development in C#, so we don’t need to write java or Objective C. We can just use C# and leverage the same for all the platforms. Xamarin also helps us by providing the designers with the different platforms like Android,IOS,etc.

About SQL-Query-using-LINQ-to-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!