Multiple rows to one comma separated value in Sql Server
Multiple rows to one comma separated value in Sql Server
Multiple rows to one comma separated value in Sql Server
Hello guys in this video you'll see how to solve issue A non-fatal error occured during cluster initialisation in Postgre SQL on Postgre installation. You will often see this issue while installing Postgre. We have a workaround for you to solve this issue. Just follow the steps and your issue will solve.
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:
This post introduced you to ASP.net and why it is a good choice for the web development process.
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.
Hello guys, in this article we will see how to fix CWE-23 Path Traversal vulnerability Unsanitized input from an HTTP parameter flows into global::System.IO.Directory.CreateDirectory, where it is used as a path. This may result in a Path Traversal vulnerability and allow an attacker to create arbitrary directories when we scan our code with snyk.
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.
In this article we will see how to create slick slider with single slide. Slick slider is used for creating image carousal.
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)).
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.
HashMap is a component of the Java Collections Framework that implements the Map interface. It offers a key-value pair data structure in which elements are stored as a combination of keys and their corresponding values. HashMap does not support duplicate keys, but it does support mapping multiple values to the same key. It provides constant-time performance for simple operations like as element addition, removal, and retrieval.
Hello guys, now a days we often need to implement api's in our Asp.net Core project and for testing api's we often use swagger. Swagger is a type of Api developer tools which helps developers in using and testing api's in a better way. We will see how to use Swagger in Existing Asp.Net Core MVC Project.
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 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.
In Java, the LinkedList class implements the List interface and provides a doubly-linked list data structure. It provides a versatile means of storing and manipulating a collection of items. A LinkedList, unlike an ArrayList, uses references to connect components rather than contiguous memory allocation.
Hello guys, We often found ourself in the need of a realtime chat app . For two way communication in your webapp. We will see how to implement real time chat using SignalR with .Net core and Vue.js. SignalR is basically used for any sort of realtime functionalities. We will use .Net core for managing chathub . You can see complete steps in the article.
Hello guys, sometimes while working with Devexpress tools you may have found one issue with dropdown when you use that on a popup. The items of dropdown gets overlapped by popup. We will see how to fix DevExpress Dropdown Items Overlapped by Popup.
Office 365: Migrating and Managing Your Business in the Cloud
Hello guys, sometimes we have to integrate google Login in our .Net applications. It can be hard sometimes to integrate that. So we will see how to integrate that using GoogleAuthentication Nuget package , which makes it easier to use and integrate.
In C, control statements are used to control the flow of program execution based on certain conditions or loops. These statements allow you to make decisions and repeat actions in your code
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.
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.
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 paypal integration in Asp.Net MVC.
Hello guys , often we need to apply masking on phone, email or many more field to accept data in certain format. So in this article we will see how to apply input mask in jquery.
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
Collection of Char or char type array.
Hello, guys sometimes we need to implement a Facebook login in our application. We will see how to implement Facebook login in Asp.net MVC.
Browser Reload On File Save:- In Asp.Net you might have noticed you browser getting refreshed whenever you save any File using Fileupload in Webforms or MVC. We will see how we can stop that.
This tutorial demonstrates how to accept payments with Stripe Checkout in an ASP.NET Core 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. We are using latest version on Stripe.Net api in this. Check out complete steps to Implement Stripe Payment Gateway In ASP.NET Core
Hello guys, sometimes when we create audio and video songs related websites we might need some cool audio/video player for our songs list. So we will see how to use Jplayer- Html5 Music Player with jquery.
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:
Encapsulation means that covering up of data under a single unit.
LINQ (Language Integrated Query) is a powerful tool in .NET that provides a unified way to query data from various data sources. When working with databases, LINQ can be used in conjunction with Entity Framework, a popular Object-Relational Mapping (ORM) framework, to simplify the process of mapping data to objects and querying the database.
Hello guys, while using Paypal payment gateway we often need for payout to some other user using paypal. So in this article we will see how to do payout using paypal payment gateway.
n JavaScript, flat() and flatMap() are array methods introduced in ECMAScript 2019 (ES10) that allow you to work with nested arrays in a concise manner. Let's explore each method:
how to use Web Api in Asp.net MVC
Java Program to Display Fibonacci Series
Method is a series of statements that together perform a task.
Error Handling in Asp.Net Core has changed a bit from what we used to use in Asp.Net Mvc. Before .Net Core We used to use OnException Methods to handle Exceptions while executing actions But it doesn't' see working in .Net Core as many features are changed.So In this Article we will see how to make exception handling work in Asp.Net Core.
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.
C# List<T> class is used to store and fetch elements. It can also have duplicate elements. It is found in System.Collections.Generic namespace. List<T> class in C# represents a strongly typed list of objects. List<T> provides functionality to create a list of objects, find list items, sort list, search list, and manipulate list items. In List<T>, T is the type of object. What is the ‘T’ in List<T>? List<T> class represents a strongly typed list of objects. List<T> provides functionality to create a list of objects, find list items, sort list, search list, and manipulate list items. In List<T>, T is the type of objects. How to create List in C#? List is a generic class and is defined in the System.Collections.Generic namespace. You must import this namespace in your project to access the List<T> class. using System.Collections.Generic; The List<T> is a generic collection, so you need to specify a type parameter for the type of data it can store. The following example shows how to create a list and add elements.
In C++, input and output operations are commonly performed using the Standard Input/Output Library, which includes the <iostream> header. This library provides the 'cin' and 'cout' objects for reading input and displaying output, respectively.
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 Core.
Hello guys, often we want to support file upload in web applications and you will notice if you try to upload file more than 4MB you will face error Maximum request length exceeded .We will see how to fix error maximum request length exceeded in asp.net mvc.
After installing or updating the system or uploading your web app on IIS, you may receive the error HTTP Error 502.5 - ANCM Out-Of-Process Startup Failure upon accessing the website. So we will see how to solve that error.
We will discover how to integrate the Razorpay payment gateway with ASP.Net Core in this tutorial. Here, we go over Razor Pay and show you how to incorporate it into ASP.Net Core MVC. Please read through my earlier post, "Build CRUD REST APIs with EF Core." You can view the result of our integration of Razorpay with ASP.Net Core MVC at the conclusion of this post.
Hello guys , we often need to integrate sms functionality in our asp.net web application . For that purpose we often use different sms libraries. In this article we will see how to send sms using Twillio in Asp.Net.
Hello guys, now a days we often need to add QR Code Generator in our websites to store some information in QR Code for implementing that we will use Jquery QR Code js library with Asp.Net MVC. Jquery QR Code Generator is a free jquery library which can be used across different programming languages.
Hello guys, in this article we will create script for creating database backups from sql database server. We will use powershell script batch file for this purpose.
Image compression is a way of reducing the size of the images. compress your image in different formats PNG, JPEG, and GIF images. We will learn how to compress image using ImageCompress nuget package which you can download from nuget.
An unconditional statement in C is one that is executed without regard for whether a certain condition is true or false. Unconditional statements are processed sequentially, one after the other, and do not rely on any conditional logic.
Child internet safety refers to the precautions, guidelines, and measures taken to protect children from potential dangers and risks associated with their use of the internet and online platforms. As children increasingly access the internet for educational, entertainment, and social purposes, it becomes essential to ensure their online safety. Here are some key aspects of child internet safety:
In this article, we'll explore how to integrate Microsoft Azure Translator API into an ASP.NET MVC application to translate website text dynamically.
Hello guys, we often want to integrate payment gateways in our Asp.Net applications. Some of the most popular payment gateways are Authorize net, payumoney,paypal,stripe and razorpay. We have already covered payumoney and stripe in our blogs. In this article we will see How to implement Authorize.Net Payment gateway in asp.net mvc.
Hello guys, we often need to implement user authentication and validate user authentication for all actions. We will see how we can create custom filter attribute and use that for user authentication.
Hangfire is an open-source library to schedule and execute background jobs in .NET applications. You'll be able to create a simple background process inside the same application pool or thread without creating separate applications. Hangfire creates background jobs in persistence storage, like MS SQL Server, Redis, MongoDB, and others, that may prevent you from losing the job on recycling IIS pools or exception prevalence.
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
Hello guys we often have to deal with json files in asp.net mvc and we also have to read json files using c# and asp.net. So in this article we will see how to read json file in asp.net mvc.
Hello guys, sometimes we need to allow users to type only alphabets in the textboxes. For that purpose , we will see how to apply alphabet validation using javascript
PayU or PayuMoney is the fastest growing Payment Gateway in India that supports all major banks and credit/debit card for payment settlement. PayUMoney provides support to enterprise user on behalf of PayUbiz Payment Gateway. As PayuBiz support more number of service then Payumoney.
Selenium automation of keyboard and mouse events is an essential ability for efficient web testing. Knowing how to imitate user interactions is crucial whether you're performing repetitive activities or testing web apps. This in-depth guide will go through how to utilise Java's Selenium WebDriver to automate keyboard and mouse events.
The java.lang.IndexOutOfBoundsException is an exception class in Java that is thrown when an index used to access an array, list, or other collection is either negative or greater than or equal to the size of the collection. This usually indicates an attempt to access an element at an invalid index that does not exist in the collection.
A parameterized constructor in Java is a constructor that accepts one or more parameters when creating a class object. These parameters are used to set the values of the object's instance variables.
Hello guys sometimes while trying to run Your Asp.net core project you may face error HTTP Error 500.31 Failed to load ASP NET Core runtime . This error is basically because the framework required by the project is not on your system. So we will see how to solve that.
Hello guys, sometimes while working with Asp.Net application and mobile apps we often need to use Firebase database . So we will be using Firebase Database in Asp.Net web application.
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.
Creating a NuGet package from a .NET Framework Class Library involves creating the DLL in Visual Studio on Windows, then using the nuget.exe command-line tool to create and publish the package.
Threading is an important aspect of programming that allows developers to perform multiple tasks at the same time. In C#, threading is an efficient way to run multiple pieces of code concurrently.
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 .
A default constructor in Java is one that is provided by the Java compiler if no other constructors are explicitly defined in a class. The default constructor takes no arguments and is in charge of setting the object's fields to default values.
Hello guys we will see how to fix Error An error occurred while processing your request.Swapping to Development environment will display more detailed information about the error that occurred.The Development environment shouldn't be enabled for deployed applications. It can result in displaying sensitive information from exceptions to end users. For local debugging, enable the Development environment by setting the ASPNETCORE_ENVIRONMENT environment variable to Development. In asp.net core IIS
Small businesses often struggle to provide prompt responses to customer inquiries and concerns, which can lead to a negative customer experience and potential losing valuable customers. To improve customer service, businesses can consider hiring a support team for call and email responses or implementing chat support services on their website.
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 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 and also we will see how to get fcm server key.
How to Connect to a Database with MySQL Workbench
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().
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 guys in this article we will learn about basics of ChatGpt and how chatgpt can help people with lots of things.
To find the biggest number in a 1D array in C, you can iterate through the array and keep track of the maximum value encountered.
Hello guys, now a days world is fastely moving forward for AI. And for that python is getting used a lot. In this article we will see how we can implement realtime face detection on web cam in python using OpenCV library.
Never study to be successful, study for self-efficiency. Don’t run behind success. Follow behind excellence, success will come all way behind you.