angular material

   setTimeout(() => {

          this.dsSupportingDoc.paginator = this.paginatorSDoc;

        }); for paginator issue.

Personal files

 https://www.yogihosting.com/

Dropdown in excell

 today i made dropdown list in excel sheet using data visualastion u can create dropdown
unser Data > datavisualtion > select List  after list dropdown selection below click on textbox
then select data which exixst in other sheet click enter then it will convert to dropdown

Must c

 https://jscrambler.com/blog/how-to-protect-angular-code-against-theft-and-reverse-engineering?

angular excel conversion

 angular excel sheet download link

upgrade the dotnet version

 

✅ 1. Update SDK and Runtime

• Install .NET 8 SDK on your machine.

You can verify it using:

bash
dotnet --version

---

✅ 2. Update Target Framework in .csproj

Open your .csproj file and update the TargetFramework:

xml
<TargetFramework>net8.0</TargetFramework>

If you're using a multi-target project or want to support other platforms, update accordingly.

---

✅ 3. Update NuGet Packages

Update all NuGet packages to their compatible .NET 8 versions.

You can do this via the terminal:

bash
dotnet list package --outdated
dotnet add package <PackageName> --version <LatestVersion>

Or use Visual Studio NuGet Package Manager to upgrade.

---

✅ 4. Review and Update Code for Breaking Changes

Check the official Microsoft breaking changes list: 📘 ASP.NET Core Breaking Changes in .NET 8

Examples:

• Minimal APIs may have changes in how they handle results.

• Changes in JSON serialization with System.Text.Json.

• Middleware updates, especially if you're using custom authentication/authorization.

---

✅ 5. Optional: Upgrade EF Core (if used)

If you're using Entity Framework Core:

Update the EF Core NuGet packages to version 8.x.

Update your DbContext configuration if any new changes are needed. Review EF Core 8 breaking changes: 📘 EF Core 8 Breaking Changes

---

✅ 6. Clean and Rebuild

dotnet clean
dotnet build

Then run the app:

dotnet run

find the duplicates between two users

  delete  FROM tbl_Users

WHERE User_ID = 'cgius'

  AND Site_Location IN (

SELECT b.Site_Location

    FROM tbl_Users a

    JOIN tbl_Users b

      ON a.Site_Location = b.Site_Location

    WHERE a.User_ID = 'cccook'

      AND b.User_ID = 'cgius'

  )