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

Implementing DIP (Dependency Inversion Principle) in .NET Core project

-
Dependency Inversion Principle (DIP) is one of the SOLID principles that states that high-level modules should not depend on low-level modules, instead both should depend on abstractions. In .NET Core, we can implement DIP using various techniques such as Dependency Injection, Inversion of Control (IoC), and Service Locator. Here's a simple example of how to implement DIP using Dependency Injection in a .NET Core project: By following below steps, we can implement DIP in our .NET Core project using Dependency Injection. 1. Define interfaces for the low-level modules (dependencies) that the high-level module needs to use. For example: public interface ILogger {     void Log( string message); } public interface IDataProvider {     string GetData(); } 2. Create implementations for these interfaces.  For example: public class FileLogger : ILogger {     public void Log( string message)     {         // cod...
Read more

Remove duplicate objects/data from an array of objects in Javascript

-
How to Remove duplicate object data from an array using JavaScript. To remove the duplicate object data from an array, have to use the filter function. So, it will filter out the duplicate objects/data from an array. Please see the below example. Javascript var uniqueItems = []; var sampleData = [ { id: 1, name: 'firstname' }, { id: 2, name: 'middlename' }, { id: 1, name: 'firstname' }, { id: 1, name: 'lastname' } ] var duplicateItems = sampleData.filter(filteredData => { if (uniqueItems.find(items => items.id === filteredData.id)) { return true; } uniqueItems.push(filteredData); return false; });
Read more

CORS (Cross-Origin Resource Sharing) in .NET

-
CORS stands for Cross-Origin Resource Sharing. It is a security feature that allows web pages from one domain to access resources (such as APIs) on another domain. When a web page attempts to access a resource on a different domain, the browser will send a CORS request to the server hosting the resource. The server can then choose to allow or deny the request based on the domain of the requesting web page. CORS is important because it helps to prevent malicious attacks, such as cross-site request forgery (CSRF) and cross-site scripting (XSS). By enforcing same-origin policies, CORS helps to protect users from unauthorized access to their sensitive data. We use CORS to enable cross-domain communication between web pages and APIs. Without CORS, web pages would only be able to communicate with APIs hosted on the same domain. With CORS, we can make APIs available to web pages on other domains, allowing for a more flexible and dynamic web. CORS is co...
Read more

Restrict Special Characters Using JavaScript By Copy,Paste

-
Restrict Special Characters using copy,paste events in JavaScript. Please follow these steps: 1. Create a textbox with the name of txtValidation and add event by the name of onpaste to that textbox. <asp:TextBox ID="txtValidation" runat="server" onpaste="return Validate(this.value);"></asp:TextBox> 2. Create a Function to that event.  <script type="text/javascript">         function Validate(Value) {             var pastedData = window.clipboardData.getData('Text');             var reg = /^[a-zA-Z0-9 ]*$/             if (!reg.test(pastedData)) {                 alert('Not Accept Special Characters');                 return false;             }         }     </script> Some of the spec...
Read more

Angular CLI Commands - Cheat Sheet

-
Image
Angular CLI (Command Line Interface) is one of the powerful tool that allows you to perform a lot of actions in an Angular project by using simple commands. We can use the CLI tool directly in a command shell, or indirectly through an interactive UI such as Angular Console.  The Best Advantage is that, can avoid manual process to create lot of stuff like create components, directives, feature modules, services... etc.  It automatically recompiles the source code files and refreshes the app in the browser.  Let's see, how to install CLI tool and what are those CLI commands. Installing the CLI is very quite easy. All we need to do, is to run the below command in Terminal or Console. It will install the CLI tool globally with respective version. Here we need to know two things before installing the CLI tool. We can install latest version or any version released by angular team based on your project need. Check the Versions list.✋ Angular CLI Setup  1. Globally - To ins...
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

Restrict Special Characters in Windows Application using c#

-
Image
Example : In this application it will remove all the special characters when we trying to copy paste the special characters. Lets see how it is possible with Copy,paste. Please follow these steps : 1. Create a New Windows Form with the name of 'Form1', and take one label with the name of 'lblName' and one textbox with the name of 'txtName' and one button with the name of 'btnValidate'. Please see below image. 2. Add a code in TextChanged event for that textbox. Here my textbox name is 'txtName' in that I have added a event like . private void txtName_TextChanged(object sender, EventArgs e) {       txtName.Text = RemoveSpecialCharacters(txtName.Text); } 3. In that event you observed method name of 'RemoveSpecialCharacters'.Basically it will remove all the special characters when you are copy paste in to the textbox.       private string RemoveSpecialCharacters(String inString)       ...
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

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

RxJs Operators in Angular

-
RxJS (Reactive Extensions for JavaScript) is a library for reactive programming using Observables, which are a way to represent asynchronous data streams. RxJS provides a set of operators that can be used to transform, filter, combine, and manipulate these data streams. In RxJS, operators are functions that take one or more observables as input, and return a new observable. These operators can be chained together to create complex data stream transformations. RxJS operators have several advantages and disadvantages that are worth considering: Advantages: Composable : RxJS operators are composable, which means they can be combined in a variety of ways to create complex data stream transformations. This allows for a high degree of flexibility and modularity in reactive programming applications. Asynchronous : RxJS operators are designed to handle asynchronous data streams, which are common in modern web applications. This makes them well-suited for tasks like handling user input, making ...
Read more