Monday, May 27, 2013

How To- Export Gridview to PDF in ASP.Net with Image

In one of my previous articles I explained Export Gridview to PDF in ASP.Net . Here, I am explaining how to export Gridview to PDF which has images and pictures in it.

In my previous posts, I explained Send mail in ASP.Net, 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.

Exporting Gridview to PDF


For exporting the data, I am using the iTextSharp (third party dll) in this post. Download the iTextSharp .
I have following Table which contains the Image Information like Image Name and Image Path.
Export Gridview to PDF in ASP.Net with Image
For exporting images into PDF we need to convert the ImagePath shown in table into its absolute URl. For example, In the above image-

Friday, May 24, 2013

How To- Get Query String Value using Java Script

Query String Value using Java Script
In web application development, we all are well aware of Query String and Its uses. We can easily retrieve the Query String values from URL on server-side, but sometimes we need to find the Query String values from URL on client-side i.e using Java Script. But in Java Script, there is no standard way or function to get the Query String values from URL. So here I am explaining how can you get the Query String values from URL using 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.

The following Java Script code snippet facilitates you to retrieve the query string key value. You can also pass the default value if the key value is not find. Here is the function-

Tuesday, May 21, 2013

C#- Find Similarity between Two Strings in Percentage

In this post, I am explaining how can you check the similarity between two strings in terms of percentage in  C# ? To check similarity between two strings we have formula by which we can find similarity in %.

In my previous posts, I explained Create Hindi TextBox Using Google Transliteration in ASP.Net, Convert Multipage Tiff file into PDF in ASP.Net using C#, Send mail in ASP.Net, Convert DataTable into List, Constructor Chainning in C#, Convert a Generic List to a Datatable, Get Property Names using Reflection in 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.

The formula to check the similarity between two strings in % is-

Thursday, May 16, 2013

ASP.Net- Create Hindi TextBox Using Google Transliteration in ASP.Net

Hindi Textbox in ASp.Net
Here, I am explaining you how to create a hindi textbox in  ASP.Net using  Google Transliteration.Here I am mainly targeting english to hindi transliteration. You can use any language which is supported by Google.

In my previous posts, I explained Send mail in ASP.Net, 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.

To create a Hindi textbox in  ASP.Net using Google Transliteration, you have to add the following script source into your ASPX page.

Tuesday, May 14, 2013

How To- Convert Multipage Tiff file into PDF in ASP.Net using C#

Multipage Tiff to PDF
Here, I am explaining how to convert a multipage tiff file into PDF file in C#. Sometimes we have a requirement to convert the multipage tiff file into PDF.I am using the iTextSharp (third party dll) for conversion of multipage tiff file into PDF file.

In my previous posts, I explained Send mail in ASP.Net, 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.

Before starting the sample code, First of all download the iTextSharp and add the reference of following dll into your application.
itextsharp.dll

Tuesday, May 7, 2013

How To- Send mail in ASP.Net using C#, VB.Net

Send Mail in C#
This post is basically for freshers or newbies. In application development sometimes we need to send the mail through our application. Here I am explaining how you can send mail in ASP.Net using C#, VB.Net.

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.

The Microsoft .NET framework provides two namespaces, System.Net and System.Net.Sockets for managed implementation of Internet protocols that applications can use to send or receive data over the Internet.We use the SMTP protocol for sending mail in  C# .

Friday, May 3, 2013

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

Zip File in Asp.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.
Create Zip File in ASP.Net

Thursday, May 2, 2013

SQL Server- Case Sensitive Search in 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 ServerASP.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'.
^ Scroll to Top