Delete Empty Rows or Null Rows in Datatable in C#

-

How to Delete Empty Rows or Null Rows in Datatable

Example:  In this application we can see how to Delete Empty Rows or Null Rows in Datatable.

Mostly this issue comes from while uploading the excel(.xls,.xlsx) file data into your sql table through datatable in windows application or web application. In rare cases,we can see while getting data from excel to datatable it will copies the empty rows also.

Below Code.
C# 
public DataTable DeleteEmptyRowsFromDataTable(DataTable dt)
 {
   for (int i = dt.Rows.Count - 1; i >= 0; i--)
   {
     if (dt.Rows[i][1] == DBNull.Value)
     dt.Rows[i].Delete();
   }
     dt.AcceptChanges();
     return dt;           
 }

Comments

Post a Comment

Popular posts from this blog

How To Setup Angular 10 Environment On Windows

-
If you are new to angular, Please follow below steps to setup angular 10 in your windows environment.  Download and Install node.js in your windows environment. Download Node JS   We need code editor tool to create and run the angular projects. We have best tools to choose from online.  Visual Studio Code is Open Source Tool, Download and Install VSCode . WebStorm is Premium Tool, To Download and Install WebStorm Tool   Once you have install above tools. We need to install Angular CLI latest version. To Install the Angular CLI in your windows environment. We have two ways to install. globally - npm install -g @angular/cli@latest  In upcoming posts I will explain you two types: a) globally   b) locally.  Now Angular Setup is ready in your windows environment, so you can create the projects and libraries.
Read more

Recommended Visual Studio Code Extensions for Angular Development

-
Every Angular Developer should know these recommended VS Code Extensions. I guess most of the developers using the Visual Studio Code tool for coding. There are large number of extensions are available in market place. But I choose necessary extensions, which is related to angular development. It will speed up your work when you're doing development. Extensions can help to improve productivity and code quality for Angular development in VS Code. By automating tasks and enforcing best practices, these extensions can help developers to create better code more quickly and with fewer errors. Angular Language Service - Provides rich editing experience for Angular templates with autocompletion, diagnostics, and jump-to-definition features. Angular Snippets - Provides a collection of Angular snippets to quickly insert common code structures, such as components, directives, and services. Angular Console - Provides a GUI tool for generating and managing Angular projects and associated fi...
Read more

Send API POST Request in MS SQL Server

-
To send an API POST request in MS SQL Server using multipart/form-data, you can use the following T-SQL code: Example of content type : multipart/form-data SQL DECLARE @url VARCHAR(200) = 'https://example.com/api'; DECLARE @boundary VARCHAR(50) = '---------------------------' + CAST(NEWID() AS VARCHAR(36)); DECLARE @param1Name VARCHAR(50) = 'name'; DECLARE @param1Value VARCHAR(50) = 'John Doe'; DECLARE @param2Name VARCHAR(50) = 'email'; DECLARE @param2Value VARCHAR(50) = 'johndoe@example.com'; DECLARE @param3Name VARCHAR(50) = 'file'; DECLARE @param3Value VARBINARY(MAX) = (SELECT BulkColumn FROM OPENROWSET(BULK 'C:\path\to\file.txt', SINGLE_BLOB) AS x); DECLARE @param4Name VARCHAR(50) = 'description'; DECLARE @param4Value VARCHAR(200) = 'This is a sample file'; DECLARE @formData NVARCHAR(MAX) = N'--' + @boundary + CHAR(13) + CHAR(10) + ...
Read more

How to Create Custom DialogBox using JQuery

-
Image
Example: In this application I will show you how to create Dialog box using  JQuery . Mostly we use JavaScript Default confirmation box for yes or no options.But we can't add another option into that Default Confirmation box in that requirement we want to create custom Dialog box. For my requirement I need three button Yes,No and Cancel Options in Dialog Box. Lets see how it possible with JQuery 1. Create a new webform with the name of 'UIDialog.aspx'. 2. Add a JQuery and Css plugins for custom Dialog Box below head tag. Please see in code. 3. Create a function in that I have three buttons in aspx page. Please see below code. <head runat="server">     <meta name="viewport" content="width=device-width, initial-scale=1">     <title>jQuery UI Dialog - Modal confirmation</title>     <link href="Css/styles.css" rel="stylesheet" type="text/css" />     <script type=...
Read more

Difference of High-Level Design (HLD) and Low-Level Design (LLD)

-
High-Level Design (HLD) and Low-Level Design (LLD) are software design concepts that are not specific to any programming language. However, to illustrate the differences between HLD and LLD, we can use C# programming language examples. Suppose we are designing a software system that involves creating a payment gateway application in C#.  Here are examples of HLD and LLD for this system: High-Level Design (HLD): Define the functional requirements of the payment gateway system, such as processing payment transactions, handling errors, and providing a user interface. Identify the non-functional requirements, such as performance, scalability, and security. Identify the key components of the payment gateway system, such as payment processing engine, database, user interface, and error handling. Create an architecture diagram that shows how these components will fit together to form the payment gateway system. In HLD, the focus is on defining the system's overall structure and architectu...
Read more

Content Negotiation in Web API with example

-
Content negotiation in Web API C# refers to the process of determining the best format for data exchange between the client and the server. It allows the client to specify the format they prefer to receive data in, and the server will send the data in that format if it's available. In Web API C#, content negotiation is done through the use of media formatters. A media formatter is responsible for serializing and deserializing the data in a specific format, such as JSON, XML, or plain text. The process of content negotiation in Web API C# involves the following steps: The client sends a request to the server and specifies the media type it prefers to receive the response in, through the Accept header in the HTTP request. The server receives the request and examines the Accept header to determine the media type requested by the client. The server then looks for a media formatter that can serialize the response in th...
Read more

Naming Conventions

-
Image
Naming Conventions is very important for any application for better readability of  code. What is Naming Convention ?  Naming conventions are general rules applied when creating text scripts for software programming. They have many different purposes, such as adding clarity and uniformity to scripts, readability for third-party applications, and functionality in certain languages and applications. They range from capitalization and punctuation to adding symbols and identifiers to signify certain functions. Advantages of Naming Conventions are : 1. Consistency 2. Better understanding the code 3. Readability 4. Automation Types of Naming Conventions:  1. camelCase : First letter should be lower case. 2. PascalCase :   All words should be upper case. 3. kebab-case : Use dash symbol between word to word with lower case. 4. snake_case : Use underscore symbol between word to word with lower case. How and where these naming conventions will use ? Please check this pos...
Read more

Aggregation and Association and Composition and Its differences with examples

-
 Aggregation, association, and composition are object-oriented programming concepts that define relationships between classes or objects. Here are their definitions and differences: 1. Aggregation: Aggregation is a relationship where one object has a reference to another object, but the referenced object can exist independently of the object that references it. The object that references the other is known as the container or owner, while the referenced object is known as the contained or member object. Here are a few examples of aggregation in C#: Example - 1 : A university has many departments, and each department has many students. In this case, the Department class is the container, and the Student class is the contained object. Here's an example code: public class Department {     public List<Student> Students { get ; set ; } } public class Student {     public string Name { get ; set ; } } Example - 2 : A car has an engine, and the engine can ...
Read more

Tightly Coupled and Loosely Coupled in .NET Core with example

-
In .NET Core, tight coupling and loose coupling refer to the way software components are designed and connected to each other. Tight coupling in .NET Core means that two or more software components are highly dependent on each other, making it difficult to modify or replace one component without affecting the others. This can lead to maintenance and testing challenges, as well as reduced flexibility and scalability. Loose coupling in .NET Core, on the other hand, means that software components are designed to be independent and have minimal interdependence. This is achieved by using interfaces, dependency injection, and other techniques to reduce the direct dependencies between components. Loose coupling allows components to be more easily replaced, modified, or extended without affecting the rest of the system. Summary, loose coupling is generally preferred in .NET Core because it makes software more flexible, maintainable, and scalable. Advant...
Read more

Angular Code Optimization Techniques and Methods

-
Angular code optimization refers to the process of improving the performance of an Angular application by reducing the amount of time it takes to load and run the application. This includes reducing the size of the code, minimizing the number of requests to the server, and improving the rendering speed of the application. Code optimization techniques for Angular can include strategies such as using lazy loading, AOT (Ahead-of-Time) compilation, using OnPush change detection strategy, and optimizing the use of pipes, observables, and other directives. The goal of code optimization is to create a faster, more efficient application that provides a better user experience for the end-users. By optimizing the code, the application can load faster, run smoother, and use less resources, which can improve its overall performance and user satisfaction. Here are some tips to optimize Angular code: Use OnPush Change Detection Strategy : This strategy only checks for changes when the @Input propert...
Read more