aamasum.hashnode.devStatic vs Dynamic Pivot in SQL Server: A Complete Guide with Real ExampleIn real-world applications like ERP, costing, or inventory systems, it's common to represent data in a pivot format—with rows turned into columns for better analysis. But here's the challenge: what happens when the column values (types) change over t...May 2, 2025·5 min read
aamasum.hashnode.devআপনার প্রোডাক্টিভিটি বাড়ান ১০ গুণ!৫০টি ফ্রি AI টুল — এখন কাজ হবে ১০ গুণ দ্রুত ও স্মার্টভাবে! 1. ChatGPT – যেকোনো লেখা বা প্রশ্নের উত্তর দিতে পারে।2. Canva AI – ডিজাইন তৈরি ও কনটেন্ট সাজাতে AI সহায়তা।3. Pictory – লেখা থেকে অটো ভিডিও তৈরি করে।4. Copy. ai – মার্কেটিং কপিরাইটিং বা ব্ল...Apr 28, 2025·3 min read
aamasum.hashnode.devWill a for loop or foreach loop throw an exception in C# if the DataTable is null or contains no rows?In C#, when working with a DataTable, you won’t get an exception from a for loop or foreach loop if the DataTable itself is not null but has no rows. However, if the DataTable is null, then trying to loop through it will throw a NullReferenceExceptio...Apr 11, 2025·3 min read
aamasum.hashnode.devDay 9: Authentication & AuthorizationSecure your Blazor app with user login, role-based access, and protected routes. 1. Key Concepts Authentication: Verify user identity (e.g., login). Authorization: Control access to resources (e.g., admin-only pages). 2. Setup Authentication Ste...Feb 28, 2025·3 min read
aamasum.hashnode.devDay 8: JavaScript InteropCall JavaScript from C# and vice versa, use JS isolation, and integrate JS libraries. 1. Why JavaScript Interop? Access browser APIs (e.g., localStorage, geolocation). Use existing JavaScript libraries (e.g., charts, animations). Direct DOM manipu...Feb 28, 2025·3 min read