Contact Us

Popular posts from this blog

Send API POST Request in MS SQL Server

To send an API POST request in MS SQL Server using multipart/form-data, you can use the following T-SQL code: Example of content type : multipart/form-data SQL DECLARE @url VARCHAR(200) = 'https://example.com/api'; DECLARE @boundary VARCHAR(50) = '---------------------------' + CAST(NEWID() AS VARCHAR(36)); DECLARE @param1Name VARCHAR(50) = 'name'; DECLARE @param1Value VARCHAR(50) = 'John Doe'; DECLARE @param2Name VARCHAR(50) = 'email'; DECLARE @param2Value VARCHAR(50) = 'johndoe@example.com'; DECLARE @param3Name VARCHAR(50) = 'file'; DECLARE @param3Value VARBINARY(MAX) = (SELECT BulkColumn FROM OPENROWSET(BULK 'C:\path\to\file.txt', SINGLE_BLOB) AS x); DECLARE @param4Name VARCHAR(50) = 'description'; DECLARE @param4Value VARCHAR(200) = 'This is a sample file'; DECLARE @formData NVARCHAR(MAX) = N'--' + @boundary + CHAR(13) + CHAR(10) + ...
Read more

Configure the API gateway in Microservices Architecture with example in .NET Core

API Gateway in Microservices Architecture In a microservices architecture, an API Gateway is a layer that sits between clients and the microservices that provide the necessary functionalities. It acts as a single entry point for all client requests and handles communication between the clients and the underlying microservices. The API Gateway serves as a mediator between the client and the backend services. It receives incoming requests from clients and routes them to the appropriate microservice. It also handles authentication, authorization, load balancing, and other cross-cutting concerns such as rate limiting, caching, and request/response transformation. By providing a single entry point and a unified interface for clients, the API Gateway simplifies client access to the system and helps to decouple the client code from the underlying microservices. It also provides a central point for monitoring and logging of all the incoming requests, making it easier to identify and troublesho...
Read more

Use immutable data structures to avoid unnecessary change detection In Angular

In Angular, change detection is triggered whenever there is a change in the component's data or state. This can be a performance bottleneck if the component's data is updated frequently, and the component has a lot of child components or bindings. One way to optimize change detection is to use immutable data structures. Immutable data structures are data structures that cannot be modified once they are created. Instead, when a change is made to the data, a new instance of the data structure is created with the updated values. Here's an example of how to use immutable data structures in Angular: HTML import { Component } from '@angular/core'; import { List } from 'immutable'; @Component({ selector: 'app-list', template: ` {{ item }} ` }) export class ListComponent { items = List (['item 1', 'item 2', 'item 3']); addItem() { // The...
Read more

Delete Empty Rows or Null Rows in Datatable in C#

How to Delete Empty Rows or Null Rows in Datatable Example:  In this application we can see how to Delete Empty Rows or Null Rows in Datatable. Mostly this issue comes from while uploading the excel(.xls,.xlsx) file data into your sql table through datatable in windows application or web application. In rare cases,we can see while getting data from excel to datatable it will copies the empty rows also. Below Code. C# public DataTable DeleteEmptyRowsFromDataTable(DataTable dt) { for (int i = dt.Rows.Count - 1; i >= 0; i--) { if (dt.Rows[i][1] == DBNull.Value) dt.Rows[i].Delete(); } dt.AcceptChanges(); return dt; }
Read more

How To Setup Angular 10 Environment On Windows

If you are new to angular, Please follow below steps to setup angular 10 in your windows environment.  Download and Install node.js in your windows environment. Download Node JS   We need code editor tool to create and run the angular projects. We have best tools to choose from online.  Visual Studio Code is Open Source Tool, Download and Install VSCode . WebStorm is Premium Tool, To Download and Install WebStorm Tool   Once you have install above tools. We need to install Angular CLI latest version. To Install the Angular CLI in your windows environment. We have two ways to install. globally - npm install -g @angular/cli@latest  In upcoming posts I will explain you two types: a) globally   b) locally.  Now Angular Setup is ready in your windows environment, so you can create the projects and libraries.
Read more

Content Negotiation in Web API with example

Content negotiation in Web API C# refers to the process of determining the best format for data exchange between the client and the server. It allows the client to specify the format they prefer to receive data in, and the server will send the data in that format if it's available. In Web API C#, content negotiation is done through the use of media formatters. A media formatter is responsible for serializing and deserializing the data in a specific format, such as JSON, XML, or plain text. The process of content negotiation in Web API C# involves the following steps: The client sends a request to the server and specifies the media type it prefers to receive the response in, through the Accept header in the HTTP request. The server receives the request and examines the Accept header to determine the media type requested by the client. The server then looks for a media formatter that can serialize the response in th...
Read more

Map Operator in RxJs

The map operator in RxJS is used to transform the emissions of an Observable stream. It applies a function to each emitted value and returns a new Observable with the transformed values. The original values are not modified. The map operator is often used in combination with other operators to create complex data flows. Advantages of the map operator in RxJS include: Transformation of data : The map operator allows you to transform the data emitted by an Observable, which can be very useful for manipulating the data in the way you need it. Efficiency : The map operator is an efficient way to modify data, as it does not modify the original data and creates a new Observable with the transformed data. Composability : The map operator is a composable operator, which means you can combine it with other operators to create more complex data flows. Clarity : Using the map ope...
Read more

How to Create Custom DialogBox using JQuery

Image
Example: In this application I will show you how to create Dialog box using  JQuery . Mostly we use JavaScript Default confirmation box for yes or no options.But we can't add another option into that Default Confirmation box in that requirement we want to create custom Dialog box. For my requirement I need three button Yes,No and Cancel Options in Dialog Box. Lets see how it possible with JQuery 1. Create a new webform with the name of 'UIDialog.aspx'. 2. Add a JQuery and Css plugins for custom Dialog Box below head tag. Please see in code. 3. Create a function in that I have three buttons in aspx page. Please see below code. <head runat="server">     <meta name="viewport" content="width=device-width, initial-scale=1">     <title>jQuery UI Dialog - Modal confirmation</title>     <link href="Css/styles.css" rel="stylesheet" type="text/css" />     <script type=...
Read more

HTTP and grPC Communication protocols used in Microservices

Microservices architecture is an approach to building distributed systems that involves breaking down a large application into smaller, loosely coupled services that communicate with each other through APIs. There are several communication protocols used in microservices architecture, including HTTP and gRPC. HTTP: HTTP (Hypertext Transfer Protocol) is a widely used protocol for communication between web applications and servers. In microservices architecture, HTTP is used for communication between services as it's a well-established and reliable protocol that's widely supported. HTTP is simple and easy to use, and it supports a wide range of data formats like JSON, XML, and plain text, making it a popular choice for microservices communication. gRPC: gRPC is a modern, high-performance, open-source protocol for communication between microservices. It uses Google's Protocol Buffers as a data format, which is a language-neutral, platform-neu...
Read more

Angular Code Optimization Techniques and Methods

Angular code optimization refers to the process of improving the performance of an Angular application by reducing the amount of time it takes to load and run the application. This includes reducing the size of the code, minimizing the number of requests to the server, and improving the rendering speed of the application. Code optimization techniques for Angular can include strategies such as using lazy loading, AOT (Ahead-of-Time) compilation, using OnPush change detection strategy, and optimizing the use of pipes, observables, and other directives. The goal of code optimization is to create a faster, more efficient application that provides a better user experience for the end-users. By optimizing the code, the application can load faster, run smoother, and use less resources, which can improve its overall performance and user satisfaction. Here are some tips to optimize Angular code: Use OnPush Change Detection Strategy : This strategy only checks for changes when the @Input propert...
Read more