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.
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, 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.
Hello guys, sometimes while working with sql server we often create tables with wrong columns names and we often need to rename those columns. So we will see how to rename table column in sql server.
Dependency Injection Using Ninject In ASP.NET MVC
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 obtain the IP address of a device using C#, you can use the Dns class from the System.Net namespace. Here's an example of how you can retrieve the IP address:
The String Joiner class in Java makes it easy to connect several strings with a defined delimiter. It is very useful for concatenating strings in a loop or dealing with string collections.
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.
Hello guys, in this article we will learn how to reload vue js child component. Sometime we need to reset child components or just re-render them. There few ways to reset child components but for beginner and those who have just started with vue js it can become a tough task to understand the flow to reset child components. So we will see how to reload child component.
Hello guys, sometime we need to shuffle our list or array randomly without being in a certain order. So , in this article we will learn how to shuffle a list randomly in c#.
how to use Web Api in Asp.net MVC
Setting up database on plesk server
Let’s explore how ServiceNow, particularly its IT Operations Management (ITOM) capabilities, drives efficiency, enhances productivity, and transforms the way businesses operate.
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.
The break statement is used to terminate the loop or statement in which it present. This statement is used to skip over the execution part of the loop on a certain condition.
In Java, the ArithmeticException is a subclass of the RuntimeException class. It is thrown when an arithmetic operation fails or produces an incorrect result. One of the most common causes of an ArithmeticException is attempting to divide by zero.
It is a way to represent memory location through symbol so that it can be easily identified.
How to Connect to a Database with MySQL Workbench
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 C# if-else statement also tests the condition. It executes the if block if the condition is true otherwise else block, is executed. the else statement to specify a block of code to be executed if the condition is False. the if-else statement checks a Boolean expression and executes the code based on if the expression is true or false. The if part of the code executes when the value of the expression is true. The else part of the code is executed when the value of the expression is false.
It is collection of character or char type array.
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.
Web Api in Asp.net MVC
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.
Hello guys, often while working with angular js you sometimes have requirement of implementing chat functionality where user can press @ and select users from the list , similar to what we do on skype or all big chatting platforms. For that purpose we can use Angular-mentions which is a package in Angular js for skype like @ chat functionality. We will see how to use that in detail.
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
Hello guys, we all would have used cookies in our Asp.Net Core web projects. If you have used httpcookies in Asp.Net core 2.1 project and you are trying to update your .Net core version to 3.1 . You will notice your HttpCookies are not working there. So, we will see how to fix HttpCookies Issue with Asp.Net Core 3.1.
Converting commas or other delimiters to a Table or List in SQL Server
There are two common objects in ADO.NET to read data, DataSet, and DataReader. C# DataSet and C# DataReader classes represent these objects. In this article, we'll learn about ADO.NET DataReader and how to use a DataReader in C#.
In ASP.NET Core, App Trim refers to a feature that automatically removes unused assemblies from the application's memory during runtime. This helps to reduce the memory footprint of the application and improve its overall performance.
What is C?
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.
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
To generate an image using C#, you can utilize the System.Drawing namespace, which provides classes for working with images. Here's a simple example that demonstrates how to create a new image and save it to a file:
In this article, I will be explaining how an email can be send using ASP.NET with C#. I will be working on window forms of asp.net web application.I will be demonstrating how to use asp.net to build web application to send an email.
Hello guys , while working with Angular js we sometimes gets caught in situtation where we have to apply css on child components.It's not possible by adding css normally in parent compponent due to the scope of component css. So we will learn how to apply css on child components in Angular js.
Shuffling an array means we want to randomly rearranging the list or an array.
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 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.
The NoSuchWindowException in Java is an exception that's thrown when a WebDriver (typically from a Selenium framework) tries to switch to a window that does not exist. This usually occurs in web automation scenarios when you're working with multiple browser windows or tabs
Java Program to Display Fibonacci Series
In this article we will see how to use dapper with stored procedure for selecting data from database with parameters.
Hello guys, we often need to export data from database into excel files in ASp.Net mvc using ClosedXML Xlworkbook. XlWorkbook is a third party library that helps in exporting excel file from datatable or dataset easily amd allows many formatting options that helps in better presenting data in excel.
In this article, we'll walk you through the process of using iTextSharp to create PDF documents within an ASP.NET MVC project. We'll dissect the code you've provided and explain each step to ensure you have a comprehensive understanding of the implementation. So follow the steps for learning How to generate pdf using itextsharp in asp.net mvc.
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.
Hello guys, you might have noticed while working with .Net core 3.1 that whenever you make any client side change(html,css,js). It doesn't reflect in browser even after reload. So we will learn how to solve the issue Visual studio not refreshing changes in browser on reload.
when a copy of the original value is passed to the function, then it is known as Call by value in C#
Inheritance is the concept that is used for code reusability and changeability purpose.
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.
How to create a table with fixed header and scrollable body
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 guys , we often need to implement Social Login in our web applications. Github login is also one of the social logins which is widely used now a days for authentication. We will see how to use that in Asp.Net MVC.
Expanding the reach of your ASP.NET webpage by making it accessible to users from diverse linguistic backgrounds is essential for enhancing user experience and increasing engagement. One effective way to achieve this is by integrating Google Translate into your Asp.Net webpage, enabling users to translate the content into their preferred language effortlessly.
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, we often need to implement type ahead functionality in our project. So for implementing type ahead with input boxes we will use Jquery Autocomplete. We will also see how to implement highlight text functionality in Jquery Autocomplete.
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.
Database Backup .bak
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:
How to create a read-only MySQL user
Access modifiers in C# are used to specify the scope of accessibility of a member of a class or type of the class itself.
In C, input and output functions are used to interact with the user and the external world. These functions allow you to read data from the user or files and write data to the screen or files. The standard library provides several functions for input and output
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#.
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.
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.
They are identify after method name and in the bracket.The information can be given to method as a parameter
Hello guys, sometimes while working with big databases in sql server we often need to find all tables where we have used specific columns. So we will see how to do that.
Hello guys, often while dealing with project where we need to implement payment systems and need user to enter card number and show them the card number format properly. So for that purpose we have to use controls from payment gateways which are bit harder to manage on custom websites. So we will see how to implement Input Box Card Number Formatting using jquery.
Hello guys sometimes while trying to run Your Asp.net core project you may face error HTTP Error 500.32 Failed to load ASP NET Core runtime . 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.
The underlying connection was closed: An unexpected error occurred on a send.
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.
C++ is a powerful, high-level programming language that is widely used for developing a wide range of applications, from system software to video games and web applications. It was developed as an extension of the C programming language and introduced several features that make it a versatile and efficient language for software development.
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
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.
You can design forms in HTML that let users enter data and send it to a server for processing. You can create forms using a variety of form elements and HTML tags. Here's a simple illustration of how to make a straightforward form in HTML:
In HTML, the table tag is used to create tables to display data in a structured grid format. The table tag can contain several attributes that help in defining and customizing the behavior and appearance of the table.
How to upload files to Azure Blob Storage in an ASP.NET Core Web
Web Api in Asp.net MVC
In this tutorial we will tell you how to create crud operations in Entity Framework
Never study to be successful, study for self-efficiency. Don’t run behind success. Follow behind excellence, success will come all way behind you.