C# Corner

Resources  
  • 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 Adaptive Card Design Using Microsoft Bot FrameworkOct 12, 2017. The Bot Framework supports different types of rich cards and provides a richer interaction experience to the user. In this article, I will show how to integrate adaptive card UI design in a Bot Application. The Adaptive Card contain a combination of text, speech, images, buttons, and input controls.Adaptive Cards are created using the JSON format specified in the Adaptive Cards schema and Microsoft provided Microsoft.AdaptiveCards NuGet package for .Net Developer to building cards and handles the serialization.
  • 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
  • Understanding Bing Search API In AzureOct 12, 2017. The Bing Search API adds intelligent search to your app, combing hundreds of billions of webpages, images, videos, and news to provide relevant results with no ad requirements. The results can be automatically customized to your users' locations or markets, increasing relevancy by staying local.
  • Understanding Face API In AzureOct 11, 2017. Add facial recognition capabilities to your app with the Face API. State-of-the-art algorithms detect human faces in images, opening a range of facial capabilities to your apps. Face detection can also identify attributes, including face landmarks (nose, eyes, etc.), gender, age, and other machine-predicted facial features.
  • Understanding Computer Vision API In AzureOct 11, 2017. The Computer Vision API gives you the tools to understand the contents of any image. Create tags identifying objects, beings, or actions present in the image, and then craft coherent sentences to describe it.
  • 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.
  • SharePoint OnPremises - Client Side File Upload Control And Uploading File In SharePoint Using Rest APIOct 06, 2017. In one of our SharePoint OnPremises projects, we have requirement to upload the user’s photo, his profile image in SharePoint Image library (PublishingImages). So we have implemented this feature using JavaScript and upload image in SharePoint Image library using rest API.
  • 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.
  • 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.
  • How To Create Blobs In Microsoft Azure Using C#Sep 29, 2017. This article is in continuation of a previous article - “Understanding Cloud Storage in Azure”, where we created a storage account and a Blob container with the name “images”.
  • 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.
  • Getting Started With Customizing A FormFlow Using Microsoft Bot FrameworkSep 25, 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 or more complex rich cards that contain text, images, and action buttons. And you can add natural language interactions, which let your users interact with your bots in a natural and expressive way.
  • 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
  • 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.
  • 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.
  • Never Let That Kid DieSep 21, 2017. It's my birthday and the last day of 5-day TOGAF program. The overall program was pretty interesting as there was no technology involved and five participants included, a senior executive from WHO and people having profiles and serious image. And yes, it was their misfortune to have me as one of the participants.
  • 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.
  • 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.
  • 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.
  • 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
  • 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.
  • 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.
  • 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.
  • 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.
  • Centering Image In Voice Of Customer SurveySep 09, 2017. This article is about the voice of the customer customization.
  • Getting Started With Bing Image Search APISep 08, 2017. In this tutorial, we will learn how to use Bing Image Search API. Remember, in our first example of cognitive services, we had created a demo Bing Speech API. In this tutorial, we will extend the same demo to search images, i.e., we will pass the text result of Bing Speech API to Bing Image Search 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • How To Perform CRUD Operation Using JSON File With Sorting And Paging In Angular - Part TwoSep 02, 2017. Today, in this article, I will explain performing CRUD operations in Angulars j. In my previous article I have retrieved records from json files with sorting and paging in. Now I will explain how to Insert, Update and Delete in angular js, and also with required filed validation. So let us go through step by step.
  • Working With JSON In SQL Server 2016Aug 28, 2017. JSON (JavaScript Object Notation) is a lightweight data interchange format. It is language independent, easy to understand and self-describing. It is used as an alternative to XML. JSON is a very popular data interchange format nowadays. Most modern services return the data into the JSON text.
  • Getting Started With Dialog Using Microsoft Bot FrameworkAug 28, 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 or more complex rich cards that contain text, images, and action buttons. And you can add natural language interactions, which let your users interact with your bots in a natural and expressive way.
  • New Features In SQL Server 2017Aug 27, 2017. There are many new features introduced with SQL server 2017 and also there is some performance improvement in existing features. Using the following links, we can learn more details about the new features in SQL server 2017.
  • Creating Login Form For Users With Image Uploading For Password RecallAug 27, 2017. The article is an alternate method of creating a login form where the conventional way of giving a password hint will be given as a question. In this, you can add an image which can be your hint if you forget your password.
  • Round Image In Xamarin.FormsAug 25, 2017. In this article we are going to display a rounded image in Xamarin forms PCL application. In Xamarin forms there is no default function available to make an image round. So, we need a plug-in for this.
  • Understand Azure Cosmos DB - DocumentDB API (SQL)Aug 24, 2017. Azure Cosmos DB is Microsoft’s globally-distributed, multi-model database service "for managing data at planet-scale." It builds upon and extends the earlier Azure DocumentDB, which was released in 2014. It is schema-less and generally classified as a NoSQL database. In this article I am going to create an Azure Cosmos DB using SQL.
  • How To Perform CRUD Operation Using JSON File With Sorting And Paging In Angular - Part OneAug 21, 2017. How to perform CRUD operation with paging, sorting, validation and also using file upload control and retrieving the records from json file.
  • Transform XML Output Of SQL Query To HTML Using "For XML" AUTO Statement With XSLT In C#Aug 21, 2017. Normally, we execute the query using ExecuteNonQuery statement and fill the output into data table. This article describes how to transform the XML output of SQL query statements using FOR XML AUTO to HTML using XSLT.
  • Docker And Docker Tool In Visual Studio 2015Aug 17, 2017. Docker is an open-source project for automating the deployment of applications as portable, self-sufficient containers that can run on the cloud or on-premises. Build Once and Run Anywhere is the mantra for Docker. Docker is also a company that promotes and evolves this technology, working in collaboration with cloud, Linux, and Windows vendors, including Microsoft. Docker image containers can run natively on Windows and Linux. The blog is mainly focused on explaining Docker, how to install Docker on development environments and how to run the ASP.Net Core application on it.
  • Connecting Login Form In C# With Database For User Type AuthenticationAug 15, 2017. This article describes how to connect a Login Form designed in C# with a database so that the user gets validated based upon the password given by the administrator who has created the login database.
  • Load Twitter Data Into SQL DatabaseAug 15, 2017. The requirement is to extract the data from Twitter and load extracted data into SQL Database. For this demonstration I am going to read the Indian Film actor Kamal Haasan's tweets and load that into SQL Server 2016 Database.
  • Creating A Data Volume In Windows PowerShellAug 12, 2017. We shall now try creating a data volume which can be used by more than one container images.
  • Building Container Image Through AutomationAug 10, 2017. The following is the continuation of the previous document. Here we will work with the automation concept through which the container images can be created.
  • Create SQL Server Database Project With Visual StudioAug 08, 2017. In this article, we’re going to learn about how to we can manage our database scripts using Visual Studio’s SQL server database project.
  • SQL Azure With Entity FrameworkAug 08, 2017. Exploring SQL Azure With Entity Framework
  • Understanding Azure Data Lake AnalyticsAug 07, 2017. This article will give an overview of Data Lake analytics account and create U-SQL job and execute this job to put data into the .csv file.
  • Understanding SQL Azure - Part OneAug 06, 2017. This article will give a idea about creating SQL DB in Azure and using it in Visual Studio
  • Understanding SQL Azure - Part TwoAug 06, 2017. This article will allow us to connect with SQL Azure and perform CRUD operations using EF.
  • How To Determine The Version And Edition Of SQL Server And Its ComponentsAug 06, 2017. For Business Intelligence features such as Integration Services, Reporting Services, and Analysis Services, you may have to install the latest service packs, cumulative updates, and hotfixes on the client-side computers to obtain the latest fixes while developing SSIS packages, SSRS reports, or Analysis Services cubes.
  • Compare Azure SQL Database And Azure SQL Data WarehouseAug 05, 2017. In this article, I am going to compare both Azure SQL database and Azure SQL data ware house. I was reading many articles; below is the tabular compression of both.
  • Building Your Own Container ImagesAug 04, 2017. Here, we will be building our own container images. For doing this we have two different ways, namely manual method and automated method. Let us see both ways.
  • Pulling Base Container ImagesAug 03, 2017. So far, we have deployed our container in the Nano Server VM and Windows Server VM. The next piece of work is to pull down the Images for these containers. The Docker is the container which we have created so far. In the following lab, we will pull some image for that container form the Microsoft Container images repository.
  • Setup And Connect To Azure SQLAug 03, 2017. Microsoft Azure SQL Database (formerly known as SQL Azure) is a managed cloud database i.e. Software as a Service (SaaS) provided by Microsoft Azure. In simple words, Microsoft Azure SQL is a cloud database that runs on a cloud computing platform and access to it is provided as a Service.
  • Entity Framework CRUD Operation Performed With SQL Stored Procedure Using ADO.NET Entity Data ModelJul 31, 2017. You can see my pervious article for Entity framework with Ado.Net data Model connection and how to create a new entity framework project and sql database connection maintained with created entity framework project. Also you can see how to create a class in entity framework based on data table.
  • How To Use Visual Studio For Azure SQL DatabaseJul 31, 2017. This article demonstrates using Visual Studio step by step for Azure SQL Database operation.
  • Angular, Bootstrap And ASP.NET MVC - Part Three (Data Binding In AngularJS)Jul 26, 2017. In this article, we are going to learn data binding in AngularJS. We learn how data is set into the form and how data is retrieved from the form. In AngularJS, data is stored in “$scope” variable in the controller.
  • Combination Of Id-ParentId And HierarchyId Approaches To Hierarchical DataJul 26, 2017. How to combine the Id-ParentId and HierarchyId approaches to keep and fetch the data in hierarchical and alphabetical order.
  • Cache Headers For MVC File Action Result (ASP.NET Core 2.0 Preview 2)Jul 25, 2017. I’m pretty sure that you are familiar with StaticFiles middleware of the framework. All it does is serve static files (CSS, JavaScript, image, etc.) from a predefined/configurable file location (typically from inside the web root, i.e., wwwroot folder). But along the way, it also does some cache headers configuration. The reason behind this is you don’t want your server to be called up every time for a file that doesn’t change frequently. Let’s see how a request for a static file looks in the browser’s network tab.
  • Learn Web API : Using SQL Helper ClassJul 25, 2017. This article demonstrates how to use Web API Using SQL Helper Class with easy to use data base access in Visual Studio 2017.
  • How To Use Query Editor For Azure SQL Database In Azure PortalJul 24, 2017. Azure Portal provided Query editor for database operations, which is very good for us. We don’t need any software installation in our computer; we can access and perform the task online.
  • Creating An Azure SQL Database And Connecting Through SQL Server Management StudioJul 23, 2017. This article demonstrates how to create an azure SQL Database, setting the Firewall rule and connecting through the SQL Server Management Studio.
  • BoxView In Xamarin Cross Platform With ExampleJul 17, 2017. The BoxView is a simple view, useful for drawing solid color rectangles. BoxView is a useful stand-in for images or custom elements when doing initial prototyping. BoxView has a default size request of 40x40. Used creates border property in page.
  • Taking Script From Database In SQL Server In Different ModeJul 17, 2017. This article explains how to take the script from database in SQL server in a different mode. Normally we take back up our entire database as “.bak, .mdf, .ldf” file but sometimes we need to alter, update or delete then create our database based on our database modification.
  • Create SSRS Drilldown ReportJul 17, 2017. Create SSRS drill down report, add link enable/disable based on specific condition, adding download links in reports.
  • ABC Of WPFJul 15, 2017. Basically I am working on .Net/Sql. For the project requirements I went through the WPF. I visited so many online tutorials and videos to get the knowledge. In this article I am going to share my understanding with you.
  • Uploading File To AWS S3 Using ASP.NETJul 14, 2017. In this article, I will show you how to upload a file (image/video) to Amazon S3 Bucket through a Asp.Net web application. For this first you need to have an account in Amazon web services. You can create an aws free tier account which is valid for 12 months. Visit this link to know more about a free tier account.
  • Creating A Database-Driven MVC Image Gallery With ThumbnailsJul 12, 2017. MVC Image Gallery, Save Image in a database, Retrieve Images from a database, Create Image thumbnail from the database, Upload Image through Ajax, Fancy Box Gallery
  • Connecting And Working With Azure SQL Database Using Visual Studio 2017Jul 12, 2017. This article shows how to connect and work with the Azure SQL Database. In this article, I am going to demonstrate how to connect and work with the Azure SQL Database using Visual Studio 2017.
  • Mirroring Database In SQL ServerJul 12, 2017. When there is any automatic failure we need another server that will monitor the principal server.
  • Monitoring Our Database When Accessing From Outside Or Applications In SQL ServerJul 08, 2017. This article explains how to monitor our database when accessing from outside or any other applications in an easy way.
  • Installing SQL Server vNext On Linux - Part TwoJul 04, 2017. With the release of Microsoft SQL Server on Linux, it is a huge step towards gaining markets in Database Technologies giving competition to other RDBMS software. Microsoft SQL Server is not only on Windows but it is on Linux also and people who love Linux can check the flavor of SQL Server in the Linux environment.
  • Deploying The Face API Using Visual Studio 2017Jul 03, 2017. This article demonstrates how to use Face API with C# in Visual Studio 2017 and develop a simple Windows application that invokes the Face API to detect faces in an image, by framing the faces.
  • Deploying An Azure SQL Database In Microsoft Azure PortalJul 03, 2017. This article shows how to create and configure the firewall and how to run sample sample queries in the SQL Database using Azure Portal.
  • ASP.NET MVC 5 - JQuery Image Difference/Comparison PluginJul 02, 2017. This article is about interactive visual image comparison using JQuery based plugins. Modern web development focuses more and more on user interaction due to which there are tons of cool interactive plugins available to be integrated in any web platform. Twenty Twenty is one such plugin which provides interactive image comparison visualization. This JQuery based plugin can be utilized to showcase product comparison in a more interactive way.
  • How To Download SQL Records In Excel Format Using MVCJul 02, 2017. I will explain how to download records in Excel format from database.
  • Learn AWS With MS-SQL(DB) Using SQL ClientJul 01, 2017. You want to login to the AWS console here. If you have no login register new users in here. After registering amazon will provide one year free access.
  • ASP.NET MVC CRUD With Dapper (Micro ORM)Jun 30, 2017. In this article, you will learn about CRUD (Create, Retrieve, Update, Delete) functionality in ASP.NET MVC with the help of DAPPER, the Micro ORM tool.
  • Retrieve User Details From Facebook In ASP.NET Core ApplicationsJun 30, 2017. In this article, we will learn how to retrieve user Details like Name, Profile Picture, Email, DOB and Gender after a successful Login with Facebook in ASP.NET Core Applications.
  • Angular Demo Application With ASP.NET Core MVC (Rent A Car)Jun 26, 2017. This project is a simple rent a car project developed in ASP.NET Core MVC and Angular with backend as SQL Server 2008 R2.
  • How To Create Azure SQL Database And Access It Through Visual Studio CodeJun 26, 2017. In this article, I’m going to cover how to create Azure SQL database and how you can access it through Visual Studio code.
  • Daily Shrink Database Log Automatically Using Jobs In SQL ServerJun 24, 2017. This article explains how to shrink database log daily using jobs in SQL server by step by step. We can shrink database logs automatically using jobs in SQL Server that we no need to run SQL Script manually.
  • Xamarin.Android - List View Using SQL Server DatabaseJun 21, 2017. In this article you will create a Xamarin Android List View using SQL Server.
  • Learn MVC Using Angular Image CropJun 21, 2017. In this article you will learn about MVC Using Angular Image Crop.
  • Automatic Daily Database Backup To Specific Database In SQL ServerJun 21, 2017. Automatic Daily Database Backup To Specific Database In SQL Server.
  • CRUD Operation Using Stored Procedure In ASP.NET GridView Real TimeJun 16, 2017. A GridView is a graphical control element that presents a tabular view of data.
  • Fix For 404 ResourceNotFound Error After Uploading To Azure ContainerJun 16, 2017. Here, in this post, we will see how we can resolve 404 ResourceNotFound Error after uploading to Azure CDN . It is obvious that you may feel very sad, if you are unable to see the image you recently uploaded to Azure container.
  • To Get All File Details From Local File Into SQL ServerJun 14, 2017. TO Get All File Details From Local File Into SQL Server.

About Retrieve-Image-from-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!