How to Return Query Results as a Comma Separated in MySQL
The GROUP_CONCAT() function was built specifically for the purpose of concatenating a query’s result set into a list separated by either a comma or a delimiter of your choice.
The GROUP_CONCAT() function was built specifically for the purpose of concatenating a query’s result set into a list separated by either a comma or a delimiter of your choice.
Hello guys sometimes while creating asp.net mvc web project. We often need to post files to the web api and the receive the files in the api. So we will see posting files to Web API in Asp.Net MVC.
Hello guys, sometimes we need to import data from excel file in asp.net . So we will use ExcelDataReader for that. You can check the steps on using that with asp.net project.
How to use Azure Blob Storage in an ASP.NET Core Web API to list, upload, download, and delete files
HashSet is a Java Collections Framework class that implements the Set interface. It gives a collection with no duplicate elements and no set order for its elements. HashSet is built on a hash table data structure, which allows it to add, remove, and search for elements in constant time (O(1)).
In Java, the ArrayList class implements the List interface as a resizable array. It offers dynamic arrays that can expand or contract in size as needed. ArrayLists are a component of the Java Collections Framework and provide a variety of methods for modifying the elements contained in them.
we will learn Microsoft Outlook Add Appointment and Get Appointment using Asp.Net MVC. There are two ways for that one is Microsoft.Interop library and second is Microsoft Exchange service. We will learn how to add and get appointments using Microsoft Exchange Service.
Hello guys, in this article we will tell you about what is Ajax? and how it can help you create better projects with better performance.Ajax basically used for Asynchronous Javascript and XML. As the name defines it helps you make server side operation asynchronously or you can say without reloading the page. So we will see few examples of using Ajax in Asp.Net MVC.
Creating and displaying SSRS Report in ASP.NET MVC
Hello guys sometimes we often need to convert base64 to tiff data and we have to verify if the base64 is correct for tiff image. So we will see how to Verify If base 64 string is valid for tiff image in C#.
LINQ (Language Integrated Query) is a feature in C# that allows us to perform queries against data sources, which can be arrays, collections, or any type of databases, using a SQL-like syntax. In this article, we will cover some basic concepts and functionalitites of LINQ and learn how to use it in your C# application
Hello guys, in this article we will learn how to integrate zoom c# wrapper in .Net. You can download the sample code from zoom official website . And after that follow this article for zoom integration in windows C# project.
In this article, we'll dive into integrating PayPal subscriptions into an ASP.NET Core application. PayPal offers a robust API that allows developers to create and manage subscription plans seamlessly. We'll walk through a sample code snippet that demonstrates how to create a subscription plan, add a product, and initiate a subscription for a user.
Hello guys, we often have to implement realtime chat functionality in our Asp.net web application. So we will see how to build real-time application with SignalR in Asp.Net Core
For many applications, you want to create and manage groups of related objects. There are two ways to group objects: by creating arrays of objects, and by creating collections of objects. Arrays are most useful for creating and working with a fixed number of strongly typed objects. For information about arrays, see Arrays.
Hello guys, we often want to integrate payment gateways in our Asp.Net applications. Some of the most popular payment gateways are payumoney,paypal,stripe and razorpay. We have already covered payumoney and stripe in our blogs. In this article we will see How to implement Paypal in Asp.Net Webforms.
Hello guys in this article we will see how to implement JWT Token Authenticate with Validate Token and Refresh Token automatically . We will create one action filter attribute that will automatically validate all the request and if the token is expired it will refresh the token again.
Collections means the process of which the objects are handled by your program.
JSON (JavaScript Object Notation) is a lightweight data interchange format commonly used for transmitting data between multiple systems, mostly in Web APIs and client applications. JSON is a text-based format that is easy for humans to read and write and also easy for machines to parse and generate. It is language-independent, meaning it can be used with any programming language that has the capability to parse JSON data.
Creating an HTML registration form entails the use of numerous form elements, such as text inputs, radio buttons, checkboxes, and buttons. Here's a simple HTML registration form example:
In C, an array is a collection of elements of the same data type, stored in contiguous memory locations. An index is used to access the elements of an array.
In this tutorial we’ll use slick Slider , A Slick Slider is a popular jQuery plugin, to build an attractive responsive image gallery. Slick.js is a well-known jQuery plugin created by Ken Wheeler that lets you build beautiful responsive carousels. so what I going to do is to create a custom slider one of my favorite slider is the slick slider. You can create a custom slider by following the steps below.
Hello guys , we often need to integrate twillio sms functionality in our asp.net web application. Sometimes we need to get Sms logs or history for all sent sms from twillio. So we will see how to get sms logs from twillio in Asp.Net MVC .
Hello guys sometimes we need to call async methods inside sync methods in our asp.net application. So we will see how we can do that.
The java.lang.IllegalStateException with the message "The driver executable does not exist" typically occurs in the context of automated testing using web automation frameworks such as Selenium WebDriver.
The List class has a lot of useful methods that you can use to organize data. This article will cover how to sort the items in your list and make them easier to read. The Sort method is the simplest way to sort a C# list
Hello guys, sometimes in MVC projects we often need to add pagination on client side or server side. In this article we will see how we can implement simple pagination in ASP.NET MVC using jquery.
A two-dimensional (2D) array is an arrangement of items in C that are arranged in a grid and are individually identified by a pair of indices: a row index and a column index. A 2D array can be compared to a table or matrix that has rows and columns. A 2D array in C is declared, initialised, and used as follows:
Operator overloading in C++ allows you to define how operators behave when used with objects of user-defined classes. You can customize the behavior of operators, such as +, -, *, /, ==, and many others, to work with your own classes, making your code more intuitive and expressive.
how to use Web Api in Asp.net MVC
Hello guys in this article we will see how you can create your own speech to text converter in javascript. So we will try to implement speech recognition and display speech in written format, similar like subtitles.
This article will explain repository design pattern with ADO.Net in MVC from the database without using the entity framework. I am going to use ADO.Net for this article.
Hello, readers, and welcome to Code2Night! In this blog post, we will focus on the latter and explore how to implement JWT Token Authentication in ASP.NET Core 7.0 Web api and .net core 7 web application. So we will see how we will generate jwt token and how we will verify the token using authorize attribute.
This tutorial demonstrates how to accept payments with RazorPay Checkout in an ASP.NET MVC application built with C# . The application uses Checkout to accept payments from card and upi and demonstrates step by step tutorial.
Hello guys in this article we will see how to solve an exception when you try to use old rdlc report and make changes into that . You will see you will get an exception ReportProcessingException: The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition' which cannot be upgraded. We will see how to solve that.
How to Implement CAPTCHA in ASP.Net MVC
The underlying connection was closed: An unexpected error occurred on a send.
In this tutorial, I will explain how we can use the Web APIs in the Angular application using HttpClient. Before we start the step-by-step process
This post introduced you to ASP.net and why it is a good choice for the web development process.
In HTML, you can use external CSS (Cascading Style Sheets) to separate the style from the HTML content. This is achieved by creating a separate CSS file and linking it to your HTML document. Here are the steps to use external CSS in HTML:
Hello guys, sometimes while working with big databases in sql server we often need to find all procedures where we have used a certain table.So we will see how to do that.
In this article we will focus on implementing Globalization and localization in ASP.NET Core With Resource Files . We will be trying to implement culture in Asp.Net core 3.1.So if your are struggling in using you Asp.Net Resource Files in .net core have a look at the article in detail.
So basically in a MVC Project we often use many controllers for making our web project functional.So one way is to handle exception separately on all of them or we can simple use a Base Controller. A Base controller can be told as a parent controller from which all other controller will inherit.So in that way Exception handling performed on Base Controller will get applied on all controllers which inherits from this controller.
In HTML and CSS, an ID (identifier) is a unique attribute used to identify an individual element on a webpage. Each ID must be unique within the document, distinguishing one element from all others.
A NumberFormatException is produced in Java when you try to convert a string to a numeric type (such as int, double, float, etc.) but the string's format is incompatible with the required format for that numeric type. This is common when using parsing techniques such as Integer.parseInt(), Double.parseDouble(), or Float.parseFloat().
The org.openqa.selenium.SessionNotCreatedException is an exception that can occur when working with Selenium, a popular automation testing framework used for web application testing. This exception typically indicates that a new session (browser instance) could not be created due to various reasons.
Abstraction is used to hide some information and show essential information to user.
How to delete files to Azure Blob Storage in an ASP.NET Core Web
Hello guys, sometimes we often want to restrict user from typing aplhabet characters and just all them to type numeric characters only. So we will see how to apply numeric only validation in javascript.
The Treemap is a component of the Java Collections Framework that implements the SortedMap interface. It keeps its elements ordered according to the natural ordering of keys or a defined comparator.
Web Api in Asp.net MVC
In this tutorial we’ll use slick Slider in responsive mode, A Slick Slider is a popular jQuery plugin, to build an attractive responsive image gallery. So we will see how to configure slick slider for responsive screens.
In this article we will learn how you can get outlook email in asp.net. We will use microsoft exchange services for getting or retrieving the email data from outlook account.
Publish in local folder
Hello guys we often need to import csv file and load into datatable in asp.net mvc. So we will see how you can load datatable from csv file or how to import csv in asp.net mvc.
Hello guys, now a days we always want to implement social logins in our web application . In this article we will learn how to implement Login With Microsoft in Asp.net.
In a production environment, securing your Swagger UI is essential to prevent unauthorized access. You can use authentication middleware to protect the Swagger UI endpoint. Below is an example of how you can configure authentication for Swagger UI in an ASP.NET Core application.
Editor is important for visible Test Results. We can use Eclipse and Intellij here we use Eclipse Editor.
Hello friends, as per being a .net developer we often have situations of Sending FCM Mobile Notification in Asp.net for Android. So we will see all steps for sending notifications on android for Asp.Net core.
Hello guys, sometimes we need to get mime type for specific file types. So we will see how we can get mime type for any file extension in Asp.Net.
Destructor is opposite of constructor.It is used to destructs automatically the instance of the constructor class.it is defined one time in the class.
The Java Collections Framework's LinkedHashSet is an implementation of the Set interface. It combines the advantages of LinkedList and HashSet. The order in which the elements were added to the set is the iteration order that the LinkedHashSet preserves. It offers constant-time performance for fundamental operations and disallows duplicate elements, just like HashSet.
Hello guys, while creating webapp using vue js you might have needed toggle button for activating/ deactivating your data. So we will learn Implementing Toggle Switch in Vue js using vue-js-toggle-button in this article .
In this article, we'll walk through the process of creating an ASP.NET MVC application that displays a list of employees using jQuery DataTables. This powerful plugin provides advanced interaction controls to any HTML table, making it a great choice for displaying data in a user-friendly manner.So we will see how to use jquery datatables in asp.net
In the technologically driven era we live in, software engineering stands not just as a profession but as a dynamic and vibrant journey. This journey is filled with opportunities for continuous learning, growth, and professional advancement. For those who dare to delve into its intricacies and navigate its challenges, software engineering offers numerous routes to personal and professional development.
To check if a character is a vowel or a consonant in C, you can write a simple program that evaluates whether the character is one of the vowels (a, e, i, o, u) or not. Here's a basic example of how to do this:
This tutorial demonstrates how to accept payments with Stripe Checkout in an ASP.NET application built with C# and Web Forms. The application uses Checkout to accept credit cards from the end user and send tokens to a back-end API. The back-end controller uses the Stripe .NET library to create a charge. There are four steps: Create the project and configure dependencies Create the payment Web Form Create a page to perform the charge Run the application
Hello guys, we often want to integrate payment gateways in our Asp.Net applications. Some of the most popular payment gateways are payumoney,paypal,stripe and razorpay. We have already covered payumoney and stripe in our blogs. In this article we will see How to refund payment using Paypal in Asp.Net MVC. For this we will use paypal sale api.
Dapper is a simple Object Mapper and is nothing but Object-relational mapping (ORM) and is responsible for mapping between database and programming language and also it owns the title of King of Micro ORM in terms of speed. It is virtually as fast as using a raw ADO.NET data reader and also Entity Framework.
In the C programming language, operators are special symbols or keywords that perform operations on operands. Operands are the values or variables that operators act upon
How to create a table with fixed header and scrollable body
Hello guys, sometimes while working with you asp.net mvc application we often need to have mapping between database objects to other objects. Often we do that mannually and we can also use automapper to automate mapping between similar kinds of object. So we will see how to implement AutoMapper in asp.net mvc.
JWT Token Authentication And Authorizations In .Net Core Web API
Hello guys we often need to implement charts in our web project. In this tutorial we will see how to implement pie chart in asp.net mvc using am charts library.
Angular Material Select Dropdown with Image
Hello guys in this tutorial , we will learn the first step of using sql server. We will see how we can create database and perform crud operation using sql queries.
Hello friends, as per being a .net developer we often have situations of Sending FCM Mobile Notification in Asp.net for IOS. So we will see all steps for sending notifications for IOS using Asp.Net core.
In this article we will learn some basics of how we can use Asynchronous Programming in C# . We will see some code examples for that.
Creating tables in HTML is a way to display tabular data in a structured format. HTML provides several elements for building tables, including the,,, and elements.
Hello everyone, in today's digital landscape, integrating Google authentication login using Google API has become increasingly essential. In this article, we will delve into the process of seamlessly integrating Google SignIn into Asp.Net Core 8.0, the latest framework in the .NET Core ecosystem. Let's explore how to streamline user authentication and elevate the security standards of your web applications by Integrating Google SignIn in Asp.Net Core 8.0.
Never study to be successful, study for self-efficiency. Don’t run behind success. Follow behind excellence, success will come all way behind you.