C# Corner

Resources  
  • Azure Storage CRUD Operations In MVC Using C# - Azure Blob Storage - Part TwoApr 18, 2018. This article will give a step-by-step demonstration how to store any physical object into Azure Blob Storage.
  • Real-Time Data Storage In Firebase Using Android StudioApr 09, 2018. This article demonstrates how to store real-time data in Firebase using Android Studio.
  • How Are You Using Document Libraries In SharePoint?Apr 05, 2018. SharePoint is well known for its content management ability. We can store files in SharePoint (inside Document Library) and use search and approval workflows features on top of it. I have seen many organizations are using only the content management feature of SharePoint by uploading tons of files. But, is it the right way of using SharePoint?
  • How Develop Analytics For SharePoint Online Using Power BIApr 03, 2018. In this article, we will discuss how to use data stored in SharePoint Online Site to develop analytics using PowerBI.
  • Data Governance Using Labels In Office 365Mar 22, 2018. Many organizations have started using Office 365 for their business purpose. With this now we have many documents being stored all across Office 365. With this, organizations are looking for implementing the governance around their data. The documents should be classified and governance should be carried over as per the classification. Performing all these things manually is next to impossible, as the document can be anywhere in Office 365 and can be uploaded by any user.
  • Building Real Time Applications With Firebase Database And AngularMar 16, 2018. Firebase helps us make development faster, so we can skip the development part where we build API and database objects like stored procedure.
  • Introduction To Redux - Advanced React - Part TwoMar 09, 2018. In this article, we will see what Actions, Store and Reducers are,.
  • Working With Arrays In JavaScriptMar 09, 2018. Arrays are the collection of same data-types values or a collection of data items. In memory variable, we can store one value at a time but in arrays, we can store many values and retrieve as per index number of stored values.
  • Execute SQL Server Stored Procedure With User Parameter In Power BIFeb 28, 2018. Sometimes there is a situation in which we need to get data by consuming SQL Server stored procedure. SQL Server stored procedure has parameters which we need to pass dynamically. Power BI provides a functionality to execute Stored Procedure using Managed Parameters. During this article we will talk about, • How to create Manage Parameter • How to pass manage parameter to a Stored Procedure • Invoke Query Result and load data to Power BI Desktop
  • Deploy SharePoint Framework Client-Side Web Part To Office 365 CDNFeb 22, 2018. SharePoint Framework encourages us to host customizations outside of SharePoint. Consisting fully of client-side assets, these customizations can be hosted on public CDNs or other locations optimized for delivery of static resources. But hosting resources externally isn't without downsides. Assuming you're not hosting your organization's customizations publicly, it adds yet another location for you to monitor and maintain. So, to deploy SharePoint Framework web-parts in Private CDNs of the Office 365 CDN there's a new edition of SharePoint Online. In this article, we will discuss the SPFx web-part deployment procedure in Office 356 private CDNs and discuss other possibilities.
  • SQL Coding Best PracticesFeb 14, 2018. While executing your procedure, the system will first scan through all system procedures and then user defined procedures. This means that the procedure might take more time for execution thus decreasing system performance.
  • Stack, Heap, Value Type, And Reference Type In C#Feb 13, 2018. Now, let’s see what happens when we declare any variable like int a=10 in C#. When C# compiler will run, it will allocate a block of memory which will have name of variable i.e. a, its type i.e. int and its value i.e. 10. Now this memory can be of type Stack or Heap i.e. variable gets store in Stack or Heap.
  • Database Naming Standards For The ProgrammerFeb 09, 2018. Let us face it, in most companies that programmers work for, we end up doing database work. I do not agree with this since I think the DBA or BIA should handle database programming and we should stick to what we do best… coding. Would you want a DBA writing code? I think not. With that said, here are database naming standards that I use when in this situation. DBA’s might not agree with how database coders name databases; stored procedures etc. but we need something.
  • Microsoft Defines Windows Progressive Web App Plans for 2018Feb 07, 2018. Microsoft articulated more about their Progressive Web Application plans in a recent article. They are the first platform to include PWAs in their App Store.
  • Apple Starts Implementing Progressive Web App (PWA) Plumbing & Rejecting App Store SubmissionsFeb 07, 2018. Apple has recently begun purging iOS apps, rejecting new submissions and started work on Service Workers and Web Manifest support.
  • Build InfoPath Form On Existing SharePoint ListFeb 06, 2018. An easy step by step procedure to create a InfoPath form on an existing SP list
  • Deploying Multiple ASP.NET Core Apps To Docker And AzureJan 22, 2018. API - has controller with CRUD operations for a movies database. It uses a class library Data, which contains repositories. Database is hosted in Azure and connection string stored in application settings (appsettings.json).
  • Stored Procedures In Azure Cosmos DBJan 16, 2018. There are many performance benefits when executing complex operations like Batching in case of using Stored Procedures. Reason is all these operations get executed closer to data as Stored Procedures are stored at server side.
  • 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.
  • Using Collection In KotlinJan 02, 2018. Collections are used to store groups of related Objects in memory. Like java, kotlin also supports collection frameworks.
  • Linking Android-Kotlin Application With Google Play Store For RatingDec 26, 2017. In this article, I am going to illustrate how a developer can link their app with Google Play store so that a user can navigate to the play store to rate applications by clicking on a particular button or image.
  • Consuming ASP.NET Core 2.0 Web API Using HttpClientDec 26, 2017. We’ll create a library to wrap the functionality of HttpClient. I’ll use builder pattern for this purpose. Add a class with methods for storing parts of HttpClient.
  • Read And Write Operation In HDFSDec 26, 2017. HDFS is hadoop distributed file system; in simple terms a file is stored in a distributed machines. The Hadoop framework was designed considering reliability, throughput, network I/O, and disk I/O; but compromised with latency, which is best in RDBMS.
  • Validation Of Excel Data In C#Dec 24, 2017. This article demonstrates how to validate an Excel sheet before uploading or storing its data into a database.
  • SharePoint 2013 - Different Ways To Enable User Information ListDec 22, 2017. You can find a great description of User Information List on MSDN, yet if I had to explain it in brief I would say it’s a list which stores the users and their information. The information of the users includes details like their Name, Email ID, Display Name, Login Name, Job Title, About User, and Department. Whenever a user is added to the site, he/she appears in the User Information List. The User Profile Services sync the user data into the User Information List from Active Directory.
  • 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.
  • MVC Angular CRUD Operation Using WEB API 2 With Stored ProcedureDec 18, 2017. In this article, I am going to explain how to do CRUD Operation in Asp.Net MVC AngularJS Using WEB API 2 With Stored Procedure.
  • Introducing Hadoop /Big Data For BeginnersDec 14, 2017. Companies like Facebook ,NASA, and Google have huge amount of data (can be hundreds of petabytes or exabytes). Each and every like, click, comment, review, update, search, call, visit, piece of financial and health information, transaction, photo upload etc., which is a very huge data set, gets stored somewhere(database).This data is called Big Data.
  • Step By Step Procedure To Create An Azure Logic AppDec 06, 2017. The article is on the detailed procedure of building an Azure Logic App. These steps are described with photos.
  • 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
  • How To Use Indexed DB To Improve Page Load PerformanceDec 05, 2017. Indexed DB is a local storage system, which will store data in client-side on browser. This is useful for applications that require us to store large amounts of data. These applications can run more efficiency and load faster.
  • Difference Between MySQL DATETIME And TIMESTAMP DataTypesNov 29, 2017. A simple question that may come to one's mind while working with MySQL is "Whether to assign DATETIME or TIMESTAMP datatype for a column as both seem to store the same data?”. Even though they store the same data, they differ in some ways and let's check those things out with the help of a small example.
  • Introduction To ngrx In AngularNov 27, 2017. In Angular, ngrx is built on the concept of Redux, a state management container. In ngrx, this state management is achieved by a store.
  • 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.
  • ASP.NET Core 2.0 Secret ManagerNov 22, 2017. I discussed in the previous post how configuration settings can be stored in configuration files. However, these files are checked in the source control and not suitable to store confidential settings. In a production environment these settings can be stored in environment variables or Azure Key Vault however, for development ASP.NET Core provides an alternate solution: Secret Manager.
  • Creating An Azure Data Lake Store And Data Analytics Account In Azure PortalNov 20, 2017. This article shows how to create an account on Azure Data Lake and Data Analytics in the Azure portal.
  • Uploading, Validating, And Storing A File Into Database Using EF In ASP.NET MVC5Nov 20, 2017. Here, you will learn how to upload a file, validate a file and store a file into database using JQuery, Entity Framework in ASP.NET MVC5
  • Simplest WPF Dependency Property For Beginners On Background ColorNov 19, 2017. Dependency property is not wrapped over any private members unlike CLR properties, and it is also stored in Key-Value pairs inside the DependencyObject host instance. You must use Dependency properties if you need to create and apply properties on custom usercontrols, or change properties based on external inputs like Theme, Style, animation etc, or while applying data binding or set with a resource (static/dynamic) .
  • 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.
  • 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.
  • Create A Flash Light App In Xamarin.Android Using Visual StudioNov 08, 2017. Here it goes, My friend receive Samsung mobile phone few month ago. She like it in particular, yet one thing that it doesn't accompany is the toolbox for fundamental utilities. One of them is the spotlight application that triggers the gadget to enact or deactivate the electric lamp as required. Android supports you to have Camera API devoured in your application (all things considered, electric lamp is given to photographs or recordings and not as a floodlight). Anyway, I was believing that I ought to get an application from Play Store, correct? No! Despite the fact that it would give me an "exquisite" answer for my spotlight issue, yet shouldn't something be said about the armed force of ad I should experience, or the hazy UI of the application. So I figured I should manufacture an application for herself to have the capacity to trigger the spotlight on or off.
  • ASP.NET Core 2.0 Session StateOct 09, 2017. Using an empty project from a previous post, amend Startup class ConfigureServicee() method, and add services for session and its backing store.
  • ASP.NET - Connect to MySQL Azure DatabaseOct 07, 2017. Using MVC, Entity Framework, ASP.NET Scaffolding, and Azure MySQL you can create a web application that stores your information on an MongoDB Azure database. This demo shows you how to create a web application with MVC and Entity Framework 7, that communicate with a MySQL Azure database.
  • ASP.NET - Connect To Azure Cosmos DBOct 07, 2017. This article will show how to configure and use CosmoDB on an ASP.Net MVC web application, The tasks will be stored as JSON documents in Azure Cosmos DB.
  • 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.
  • 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.
  • 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.
  • Stored Procedure With Input And Output Parameter Using Entity Framework In ASP.NET MVCSep 23, 2017. In this article, we are going to learn how to get list and output value from a stored procedure using Entity Framework in ASP.NET MVC.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • Step By Step Procedure To Create A Microsoft FlowSep 14, 2017. Microsoft Flow is a part of Office 365 suite which is a cloud-based software tool that allows users to create an automated workflow across multiple applications and services without the need for developer help. Microsoft flows is built on top logic app engine. But as this app is built for targeting business personnel, the total process is UI based. To create a flow, the user specifies what action should take place when a specific event occurs.
  • Getting Started With Azure Cosmos DB - Table APISep 08, 2017. The table is made up of one or more partitions. Partition Key and Row Key are suitable to optimize your solution. The account name, table name, and partitionkKey together identify the partition within the same storage service where your table service stores the entity.
  • 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 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.
  • How To Perform Web Scraping Using Python ProgramSep 04, 2017. Web Scraping (also known as Screen Scraping, Web Data Extraction, Web Harvesting etc.) is a process to scrap (extract) data from web pages, web document, HTML document or XML document in a structured manner and then store in database, text file as a spreadsheet , as a XML , or in whatever file format we want to save in.
  • Understanding Media Services In AzureAug 17, 2017. Azure helps you to build custom media workflows in the cloud. It’s an end-to-end solution that delivers audio and video virtually in any device anywhere. It offers end-to-end workflow which is very highly scalable in coding, packaging, storing and distribution of media content to a wide range of devices including TV, PC, and mobile devices.
  • Learn Azure Blob StorageAug 11, 2017. Basically, it represents the durable store in the Azure cloud. And also, it allows storing blob, tables, messages, and queues.
  • Using Category To Store Your Master DataAug 08, 2017. In every CRM implementation, we deal with some sort of master data in CRM. Normally we use the traditional way to store master records by creating custom entities. But we do have a better way to store master data using Category entity.
  • Making Web Sites Look Like Native Apps Without the App StoreAug 02, 2017. Earning a place on a user's home screen is key to engagement with customers. The automatic Add to Home Screen Experience provides this capability to progressive web applications. This is driven by the web manifest file, providing valuable meta information to the browser.
  • 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.
  • SharePoint Online / Office 365 - Exporting All the Terms from Particular TermSet In .CSV File Using CSOM And Console ApplicationJul 28, 2017. In this article, I’ll explain how to export TermSets in .CSV file format using CSOM and console application. I’ll go through step by step procedure for exporting TermSet.
  • DataTable In Xamarin iOSJul 27, 2017. In this article, you will learn how to Store Values Using DataTable in Xamarin iOS, using Xamarin Studio.
  • 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.
  • Extracting Data From Large Spreadsheets Using Python And OpenpyxlJul 26, 2017. At least once in life, every computer user has to handle some spreadsheets or, excel files. Sometimes it's to put formulas in for accounting, sometimes it's to store data from Google forms or other surveys. So what do you actually do when the spreadsheet contains just survey data or no numbers to apply formulas at all? I know you'll get your hands dirty and do it manually.
  • Get User Profile Properties Data in SharePoint Designer 2013 WorkflowJul 18, 2017. Workflows helps SharePoint users to collaborate on documents, list items and to manage tasks by implementing business processes on documents and list items. Creating and assigning tasks to Manager is a very common scenario in workflows. All the user related information is stored in User profile service application (UPA). Although this sounds very straightforward, getting the user profile properties of the logged in user is very tricky in SPD 2013 workflow.
  • Best Practices For MVCJul 14, 2017. Add a class library project to the solution, named Store.Model. This library is where we ‘ll keep all of our domain objects. Entity Framework will count on them in order to build the database but we are not going to configure Code First using DataAnnotations attributes on this project. Instead, we are going to put all the Code First configuration in specific Configuration classes using the Fluent API. Add a folder named Models.
  • Deploying Event Hubs In Azure PortalJul 14, 2017. This article shows how to deploy the Event hub in the Azure portal. Azure Event Hubs are highly scalable data streaming platforms and event ingestion services capable of receiving and processing millions of events per second. Event Hubs can process and store events, data, or telemetry produced by distributed software and devices.
  • How To Upload Records From Excel File to Database Using Stored Procedure In MVCJul 10, 2017. In this article, I will explain how to upload records from Excel files in the database using store procedure and also how to check all types of validation.
  • React Tutorials - Day Four - Props And StateJun 30, 2017. Today, we will learn about Props and State in React. Props and State are used to store and follow the data in applications.
  • Export GridView In Excel And PDF Using Stored Procedure In ASP.NET In Real-TimeJun 28, 2017. This article will show you how to export GridView records using Excel and PDF.
  • Working With Variables In Windows PowerShellJun 27, 2017. Windows PowerShell variables are quite different when you compare them with Cmd.exe variables. In Command-prompt, all the variables are environment variables and they can only store a string of text. But in Windows PowerShell, variables can store more than just text, they store objects.These variables help you to create reliable scripts.
  • Working With PowerShell DrivesJun 25, 2017. Windows PowerShell drives are data store locations that you can access like any other ?le system drives in Windows PowerShell. The Windows PS providers create some drives for you, such as the ?le system drives (including C: and D:). Below examples provides you how to work with PowerShell Drives in Windows PowerShell.
  • Creating A Multi-Language Store Site With nopCommerceJun 18, 2017. In this tutorial, we will cover topics related to creating a multi-language store site with nopCommerce.
  • 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.
  • Create Data Lake Store In Azure Using PowerShell CmdletsMay 30, 2017. Create Data Lake Store In Azure Using PowerShell Cmdlets.
  • Streaming Data From Azure Storage To Data Lake StoreMay 29, 2017. Streaming data from Azure Storage to Data Lake Store.
  • Introduction To Term Store Management In SharePoint Online (Office 365)May 27, 2017. Introduction Of Term Store Management In SharePoint Online (Office 365).
  • Google Map Using SQL Server Stored Procedure In ASP.NET MVC 5May 23, 2017. I will show you how to show markers on places like country, state, continent etc., using stored procedure.
  • WCF Using Stored Procedure In ASP.NET To Insert RecordsMay 16, 2017. This article gives you a brief idea about WCF, using stored procedure in ASP.NET to Insert the records.
  • Generate JSON Data Using Web Service And SQL Server Stored ProcedureMay 08, 2017. Generate JSON Data Using Web Service And SQL Server Stored Procedure.
  • An Effective Way To Store Some Values In Database In ASP.NETMay 03, 2017. An Effective Way To Store Some Values In Database In ASP.NET.
  • AngularJS - Using Web Service And Stored Procedure In ASP.NETMay 01, 2017. AngularJS - Using Web Service And Stored Procedure In ASP.NET.
  • Entity Framework 6.0.0 Using Stored Procedure In ASP.NET MVCApr 28, 2017. Entity Framework 6.0.0 Using Stored Procedure In ASP.NET MVC.
  • Using Data Lake Store In AzureApr 15, 2017. This article presents information on uploading and modifying files in Azure portal.
  • Steps To Perform CRUD Operations Using AngularJS And Stored Procedure In An ASP.NET MVCApr 12, 2017. In this article, you will learn the steps to perform CRUD operations, using AngularJS and stored procedure in an ASP.NET MVC.
  • Insert Data By Stored Procedure In MVC 5.0 With Data First ApproachApr 11, 2017. This article shows you how to insert the data by stored procedure in MVC 5.0 with Data First Approach.
  • CRUD Operation Using Single Stored Procedure In ASP.NET MVC Of Real-Time ProjectMar 31, 2017. This article presents an overview of CRUD operations, using a single stored procedure in ASP.NET MVC of real- time projects
  • O365 - Programmatically Create New Term Store Management In SharePoint Online - CSOMMar 15, 2017. O365 - Programmatically Create New Term Store Management In SharePoint Online - CSOM.
  • New Term Store Management In SharePoint OnlineMar 12, 2017. This article imparts knowledge about New Term Store Management In SharePoint Online.
  • Getting Started With Remote Procedure CallMar 09, 2017. Getting Started With Remote Procedure Call.
  • SharePoint Server Managed Metadata Based NavigationFeb 23, 2017. In this article, let us see the systematic procedure to configure Managed Metadata based Navigation SharePoint 2013 and 2016.
  • Overview Of Managed Metadata In SharePoint Server 2013 And 2016Feb 23, 2017. In this article, we will see the systematic procedure to create and configure managed metadata Service Application in SharePoint 2013 and 2016.
  • Querying With U-SQL In A TSV File On Azure Data Lake StoreFeb 13, 2017. In this article, you will learn about using a U-SQL query in a TSV file on Azure Data Lake Store.
  • Import Data In Azure Data Lakes StoreFeb 10, 2017. In this article I will import my data in my Azure Data Lake Store account.
  • Bind Data In WebGrid Control Using Stored Procedure In ASP.NET MVC 4.0 And SQL Server 2012Feb 06, 2017. In this article, you will learn how to bind the data in WebGrid control, using stored procedure in ASP.NET MVC 4.0 & SQL Server 2012.
  • Implement Client Caching For SharePoint PropertiesJan 27, 2017. In this article, we will explore HTML5 Local Storage API, using which, the Web Applications can store data locally in the user’s browser.
  • Creating App Packages In Microsoft Visual StudioJan 09, 2017. The following article will help you to create application packages which are required to submit your application to the Windows Store.

About Store-Procedure

NA
Hire a remote developer
Looking to add more bandwidth to your software team? Web Developers, designers, testers are now available on demand. Flexible hours, very competitive rates, expert team and High Quality work.
X

Build smarter apps with Machine Learning, Bots, Cognitive Services - Start free.

Start Learning Now