How To- Create Zip FIle in ASP.Net Using C#, VB.Net

Here, I am explaining how to Create a zip file in ASp.Net Using C# and VB.Net. We can easily Create Zip Files Archives using DotNetZip Library.

In my previous posts, I explained Convert DataTable into List, Constructor Chainning in C#, Convert a Generic List to a Datatable, Get Property Names using Reflection in C#, Hard drive information using C#, Create Directory/Folder using C#, Check Internet Connection using C#, SQL Server Database BackUp using C# and some other articles related to C#, ASP.Net,  jQuery, Java Script and SQL Server.

For creating zip file add the reference of  Ionic.Zip.dll in your application and add following namespace-

using Ionic.Zip;

Place one FileUpload control on aspx page and one button to upload files and create zip file in it's Click Event.

SQL Server- Case Sensitive Search in SQL Server

Today I was working on text search functionality in my application. It was not a very big deal until I had not a requirement for Case Sensitive search functionality. This was new thing (at least for me). I Googled it and find number of search results with same solution. So here I am just adding one more search result for Google.

In previous posts, I explained Check Primary Key Existence in Table, Reset Identity Column in SQL Server, Insert Values into Identity column, Identity Column in SQL Server , STUFF Function, LEN Function, UNICODE Function, LEFT Function, CHARINDEX Function, Simple script to backup all SQL Server databases, Table-Valued Parameters and some other articles related to SQL Server , ASP.Net, C#.

In  SQL Server ,  Installation by default are case insensitive .This means that SQL Server ignores the case of the characters and treats the string 'Dot Net World' equal to the string 'dot net world'.

How To- Convert Data Table into List

Recently I have posted an article Convert a Generic List to a Datatable. Today I am explaining here the reverse way of my previous article i.e conversion of DataTable into List.

You may also like these posts Get Property Names using Reflection in C#, Hard drive information using C#, Create Directory/Folder using C#, Check Internet Connection using C#, SQL Server Database BackUp using C#, Partial Methods, Contextual Keyword, C# Static Methods and some other articles related to C#, ASP.Net and SQL Server.

 So Lets start the conversion of DataTable into List. First of all add the following namespaces-

How To- Find Duplicate Records in DataTable Using LINQ

This is a simple tip post . Here, I am explaining how to find the duplicate records in DataTable using LINQ.

In my previous posts, I explained Constructor Chainning in C#, Convert a Generic List to a Datatable, Get Property Names using Reflection in C#, Hard drive information using C#, Create Directory/Folder using C#, Check Internet Connection using C#, SQL Server Database BackUp using C# and some other articles related to C#, ASP.Net,  jQuery, Java Script and SQL Server.

Query for finding duplicate records in  DataTable using LINQ is very simple. For example, We have the following DataTable.

C#- Constructor Chaining in C#

In this post, I am explaining about Constructor Chaining in  C#. I konw this will be taken for granted for those of us who have been working with  C# for a while now but may be a newbie will find this helpful.

In my previous posts, I explained Convert a Generic List to a Datatable, Get Property Names using Reflection in C#, Hard drive information using C#, Create Directory/Folder using C#, Check Internet Connection using C#, SQL Server Database BackUp using C# and some other articles related to C#, ASP.Net,  jQuery, Java Script. and SQL Server.

What is Constructor Chaining? 

Constructor chaining is an approch where a constructor calls another contructor in the same class or base class.

How To- Validate Numeric Values only in TextBox using Java Script/jQuery

In this post, I will explain how to validate user to enter only numeric values in TextBox using jQuery / Java Script.

In previous posts, I explained Page Scroll to Top with jQuery, Automatically Refresh Page Using Java Script , How to Create a Textarea Character Counter, Animated Sliding Recent Post Widget For Blogger, Change Input to Upper Case using Java Script, Calculate Age from Date of Birth Using Java Script, jQuery .toggleClass() example and some other articles related to jQuery, Java Script etc.

To validate numeric values in TextBox, we need to write the following jQuery or Java Script function.

How To- Convert a Generic List to a Datatable

Today when I was working I my project, I need to convert the List into a DataTable for some reasons. I goggled it and get some solutions for this. But I get a very good solution Here.So I am posting that solution for my readers.

In my previous posts, I explained Get Property Names using Reflection in C#, Hard drive information using C#, Create Directory/Folder using C#, Check Internet Connection using C#, SQL Server Database BackUp using C#, Partial Methods, Contextual Keyword, C# Static Methods and some other articles related to C#, ASP.Net and SQL Server.

Here,I have not constrained reference type or value type only. We need to take care of both the cases while converting List to DataTable as the underlying type can be both value or reference type.

Blogger- Adding Floating Facebook Like Box into Blogger Blog

In my post Adding Facebook Like Box into Blogger Blog, I explained you how you can add Facebook Like box in your blogger blog. This post is the refined version of my previous post. Here I will show you how you can add floating Facebook Like box into you blogger blog.

You can find some more articles related to Blogging, SQL Server , ASP.Net, C# and many more. To add floating Facebook like box follow the below procedures.