How to Rotate row as column on mysql using case
Sometime we need to show row data as a column so this is possible by using case on mysql database. A MySQL pivot table is a way to transform data…
How to get all users details in single row from mysql database
On this blog I will explain how to show the users details in single row some time we this type of query in our project First I create a table…
How to select only date from a DATETIME Field in MySql ?
Example:- Data on database column just like 30-12-2022 01:14:41 Now you want to only date so you run below query
UPDATE Query On MySql With Inner Join
Sometime we need to update data on database table that contain related type column so we use update query with inner join On this example we have two table first…
How to get current date,year and days in month in C#
In C#, you can use the DateTime class to get the current date, year, and days in a month. Here is some sample code that demonstrates how to do this:…
How to use transaction in asp.net C#
A transaction is a single unit of work which means either run ALL query or NONE. If a transaction is successful, then all of the data that we want to…
Insert Data into SQL Server using C#
To insert data into a database using C#, you need to follow these steps: Step 1 : Establish a connection to the database: You can use the SqlConnection class in…
Retrieving Data in GridView from database Using ASP.Net
On this tutorial i will explain how to show data from database on gridview using asp,.net Page: EmpList.aspx Page: Emplist.aspx.cs
How to configure Proxy server In xampp Apache
You can configure proxy server by using following steps Step1:- First open xampp control pannel then click on Config after select Apache(httpd.conf) just like show on below image Step2:- after…