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 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.
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.
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.
Decision-making statements Contains Conditional,unconditional and repetitive statements
Here we discuss paragraph tag , acronym tags, and marquee tags.
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:
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.
Inheritance is the concept that is used for code reusability and changeability purpose.
Hello guys in this article we will discuss about features of .net core 7 which we can see in the upcoming release of .net core
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 this article we will see how to highlight code segments in in your website with js. We will be using Prism js syntax highlighter for this. Prism is a lightweight, extensible syntax highlighter, built with modern web standards in mind. It’s used in millions of websites, including some of those you visit daily.
Hello guys, sometimes we need to allow users to type only alphanumeric in the textboxes. For that purpose , we will see how to apply alphanumeric validation in javascript
Angular Material Select Dropdown with Image
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 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.
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.
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, 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.
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.
Hello guys in this video we will see how we can get visitors location information like country and city using simple javascript code. We will see how to do that.
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)).
Hello guys, in this article we will see how to create new branch and merge old branches into new branches on github. While working with many people on same projects we have to create different branches to manage code. We will see how to do that.
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.
Hello guys, now a days we always want to implement Google authentication login using Google Api . In this article we will learn how to Integrate Google SignIn in Asp.Net mvc.
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.
Innovation has become essential in today's digital-first economy. Artificial intelligence (AI) is being used more and more by businesses trying to stay competitive in order to boost productivity, improve customer satisfaction, and open up new growth prospects. However, realising AI's full potential necessitates more than experimenting with technology; it calls for the proper plan and skilful implementation. AI development services can help with that.
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.
HTML (Hypertext Markup Language) is defined as the standard markup language for creating and structuring web pages. It forms the backbone of the World Wide Web and is essential for creating and rendering web content in web browsers. HTML is not a programming language; rather, it is a markup language used to define the structure and content of web documents.
First C# Program
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.
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:
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.
you can import any package by this way; here I show you how to import java.util.list package
How to create a table with fixed header and scrollable body
Hello guys, now a days we often have to use web api's in our Asp.Net core projects. In this article we will see how to create web api in asp.net core. We will create HttpGet,HttpPut,HttpPost and HttpDelete api's and see how to test them.
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.
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
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, while working with blogging sites we often want to add buttons to share our articles on whatsapp , for providing user option to share link on whatsapp we have to use api.whatsapp.com. We will see how to add a WhatsApp share button on a website.
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.
The foreach loop in C# executes a block of code on each element in an array or a collection of items. When executing foreach loop it traversing items in a collection or an array. The foreach loop is useful for traversing each item in an array or a collection of items and displayed one by one. the foreach loop when working with arrays and collections to iterate through the items of arrays/collections. The foreach loop iterates through each item hence called foreach loop.
Hello guys, in this article we will learn about Integrating Google Map Places Api in Asp.Net MVC. For integrating Google Map Places Api you will need a billing account attached with your API Key. We will see how to do that in detail.
Model Validation In ASP.NET Core MVC 6.0
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.
How to Implement CAPTCHA in ASP.Net MVC
This tutorial demonstrates how to accept payments with Stripe Checkout in an ASP.NET Core 7.0 application built with C# . 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 Integrate Stripe Payment Gateway In ASP.NET Core 7.0
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.
We use FindElements here to return a collection of anchor tags.
In C++, classes are the building blocks of object-oriented programming (OOP). They serve as blueprints or templates for creating objects. Classes define the structure and behavior of objects, encapsulating data (attributes) and functions (methods) that operate on that data.
how to use Web Api in Asp.net MVC
This article will discuss key factors when choosing a Mohali mobile app development training program. It will also highlight what makes tecHangouts unique from the competition.
Hello guys in this video we will see how we can get user location details using javascript. We will see how we can get public ip address as well as country , city and other details.
Because there are no library functions with predetermined definitions, a user-defined function is one that is written by the user when writing any application. To fulfill the user's individual needs, the user must create his or her own functions. Such functions must be appropriately defined by the user. There is no such necessity to include any specific library in the program.
Hello guys sometimes while working with MySQL database you can have error Unable to connect to any of the specified MySQL hosts . So we will see how to solve this error.
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.
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.
Shuffling an array means we want to randomly rearranging the list or an array.
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.
In modern web development, it's common to interact with external APIs or services to retrieve data for your application. However, when your web application runs in a browser and makes requests to a different domain or origin, you may encounter Cross-Origin Resource Sharing (CORS) restrictions. We will see how to use api with proxy url in Asp.net website. This also helps us to resolve CORS errors.
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.
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 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 How to refund payment using Paypal in Asp.Net MVC. For this we will use paypal sale api.
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.
Zoom API integration in ASP.NET empowers developers to seamlessly incorporate Zoom's powerful video conferencing capabilities into their ASP.NET applications.In this article we will see creating zoom meeting in asp.net mvc using zoom api step by step.
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.
Collections means the process of which the objects are handled by your program.
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.
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 delete files to Azure Blob Storage in an ASP.NET Core Web
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, 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.
In Java, access modifiers are keywords that control the visibility and accessibility of classes, fields, methods, and other members within a class or package.
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, while creating asp.net core application we often need to implement export of data and for this purpose we sometimes need to export views to pdf file. So, We will see how to export view as pdf in Asp.Net Core MVC in simple steps using itextsharp library which is free.
Many times you might have got requirement of changing DateTime Format Of your IIS Hosted Web Application.Sometime Date format changes work on LocalHost but on IIS the date format remains same. Select Application Pool Select Project and click on Advanced settingsExpand Process Modal and Select Identity Select Custom Account and Click on set and enter UserName Password(System Credentials) and ok
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.
Type conversions between classes in an inheritance hierarchy are referred to as "upcasting" and "downcasting" in Java. When working with polymorphism and inheritance, these conversions are frequently required. Let's look at both ideas:
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.
Never study to be successful, study for self-efficiency. Don’t run behind success. Follow behind excellence, success will come all way behind you.