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

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

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

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

Map Operator in RxJs

-
The map operator in RxJS is used to transform the emissions of an Observable stream. It applies a function to each emitted value and returns a new Observable with the transformed values. The original values are not modified. The map operator is often used in combination with other operators to create complex data flows. Advantages of the map operator in RxJS include: Transformation of data : The map operator allows you to transform the data emitted by an Observable, which can be very useful for manipulating the data in the way you need it. Efficiency : The map operator is an efficient way to modify data, as it does not modify the original data and creates a new Observable with the transformed data. Composability : The map operator is a composable operator, which means you can combine it with other operators to create more complex data flows. Clarity : Using the map ope...
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

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

Create function to convert from string to Integer using javascript

-
Create a function to convert a string to integer using JavaScript. Javascript function parseStringToInteger(inputValue: string): Number { let value: number; if (inputValue === '0' || Number(inputValue) === 0) { value = 0; } else if (inputValue === '') { value = null; } else { value = Number(inputValue); } return value; } How to use the above function to get the expected result :  Javascript const value = parseStringToInteger("25"); console.log(value); Output : 25
Read more

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

Export to Excel in Angular 6 | 7 | 8 | 9 | 10

-
Image
How to export the data in excel in Angular In Angular, we have different types libraries to export the data into excel file in different formats like (.xlsx, .xls, .csv). No need to communicate the server to export the data in excel file. Here we need to know about two famous angular libraries to export the data in excel file.  1. xlsx is a library to generate excel file in different formats with graphical design. Click here xslx ✋  to know more information about this library. 2. file-saver is a library to save the files in client side.  Click here file-saver ✋  to know more information about this library.  The main advantage of using this approach is, it will improve the performance to your application. In this post, We can see how to implement the export to excel functionality using xlsx library in Angular. Step 1 :   To create new application using angular cli, open Visual Studio code tool and open the terminal...
Read more