How to get distinct rows from a DataSet or DataTable

    DataTable dtDistinct=ds.Tables[0].DefaultView.ToTable(true,"Floor_id");

Comments

Post a Comment

Popular posts from this blog

𝗙𝗹𝘂𝗲𝗻𝘁𝗩𝗮𝗹𝗶𝗱𝗮𝘁𝗶𝗼𝗻 𝗶𝗻 𝗔𝗦𝗣.𝗡𝗘𝗧 𝗖𝗼𝗿𝗲 - 𝗖𝗹𝗲𝗮𝗻, 𝗙𝗹𝗲𝘅𝗶𝗯𝗹𝗲 𝗠𝗼𝗱𝗲𝗹 𝗩𝗮𝗹𝗶𝗱𝗮𝘁𝗶𝗼𝗻 𝗳𝗼𝗿 𝗠𝗼𝗱𝗲𝗿𝗻 .𝗡𝗘𝗧 𝗔𝗽𝗽𝘀

Image
FluentValidation is a popular .NET library that makes it easy to check if your objects have valid data. It’s like a set of rules you create to make sure your objects follow the correct format. The best part? It uses a clean and readable style that even beginners can understand. In this guide, we’ll walk you through how to use  FluentValidation  step-by-step, using a practical  User Registration  example. By the end, you’ll see how it simplifies input validation, keeps your code clean, and improves maintainability in your ASP.NET Core applications. 📘 What is FluentValidation? Think of FluentValidation as a rulebook for your objects. Imagine you're building a  library system . You need to ensure: The library has a name Each book has a valid ID, title, and author The library has a valid address, phone number, and at least five books Instead of writing lots of messy  if  conditions,  FluentValidation  allows you to define all these rules in one ...
Read more

12 essential distributed system patterns

Image
  If you design distributed systems, you cannot ignore these patterns (Explained in 2 minutes) 👇 Here are 12 essential distributed system patterns every architect should know 👇 1. API Gateway An API Gateway is a single entry point that sits between clients and your backend services. It acts as a reverse proxy that routes requests to the appropriate microservices. 2. Point To Point Async Integration Point To Point Async Integration is a communication pattern where one service sends messages to another service through a message queue. 3. Publish/Subscribe The Publish/Subscribe Pattern is an asynchronous messaging pattern where publishers send messages to a central message broker or event bus without knowing who will consume them. 4. Outbox Pattern The Outbox Pattern ensures reliable event publishing by storing events in a database table (the outbox) within the same transaction as the business data changes. 5. CQRS CQRS is a pattern that separates read operations (queries) from writ...
Read more

API Security — How Attackers Break A

  API Security — How Attackers Break 1. Broken Authentication How attackers break it: Using stolen/breached passwords Credential stuffing Brute-force login Bypassing MFA Using replay attacks on JWT tokens Example: /login endpoint accepts unlimited attempts → brute force Tokens are not rotated → attacker reuses 2. Broken Authorization (IDOR) The #1 cause of API data breaches. How attackers break it: Change the object ID in a URL to access others’ data GET /accounts/123 → change to → GET /accounts/124 Real issue: Developers validate that the resource exists, but don’t validate ownership. 3. Lack of Rate Limiting How attackers break it: Brute force your login Denial-of-service by sending massive calls Enumerating IDs Scraping customer data 4. Missing Input Validation How attackers break it: SQL Injection NoSQL Injection Command Injection XML External Entities (XXE) Path Traversal Example: GET /files?path=../../etc/passwd 5. Excessive Data Exposure How attackers break i...
Read more