How To Bind Excel Sheet Data to Gridview or Export Excel Data to Gridview in Asp.Net

Description:-

             In this Example we Explain that How to Fetch Record or Data From ExcelSheet and Bind into the Gridview . as we already know how to Fetch Data from SQlServer Database and Binding the Gridview.but  it is some Difficult task to Retrieve Data From the Excel Database.

Here we have to use OleDB Connection instead of Sql Connection. In this Example We Retrieve All Data From the ExcelSheet and Bind into the Gridview and We also Bind All id’s of each Record in DropDownList. When user Select id From the DropDownList at that time only this Record are Bind Into the GridView.

That is the Image of the ExcelSheet database and Gridview to Bind Excel database are as shown Below.

So,How to Fetch or Retrieve Data or How to Create Connection to the Excel database are shown in this Example.

to show Example of How to Export Gridview Data or row to PDF Export Gridview Data to PDF

how to sorting Data in Gridview Sorting Row in Gridview 

how to upload File and Bind to Gridview upload file in Database and bind to Gridview 

To Download the Complete Project Click on the Below Download Image Link

How to Upload and Retrieve image or File from Database and bind image to Gridviw in ASsp.Net

Description:-

            

  In this Example we explain that how to Upload Image of File in database and Retrieve this File and Display it in Gridview.

In this Example we also Check only .jpg,.jpeg,.gif,.png image are Inserted only if other type of Image you Choose then the Message will appear only .jpg,.jpeg,.gif,.png image are allowed other type is not allowed.

we also provide user to Display Gridview Row details in Javascript Modalpopup when user move mouse on the Gridview Row.

Here is a code for Checking the Extention of the Image File are as follow

string fileExtension = Path.GetExtension(FileUpload1.FileName.ToString());

        fileExtension.ToLower();

        if (fileExtension != ".gif" && fileExtension != ".jpg" && fileExtension != ".jpeg" && fileExtension != ".png")

        {

            ClientScript.RegisterClientScriptBlock(this.GetType(), "ke", "<script>alert('only jpeg,jpg,png,gif photo is allowed');</script>");

            return;

        }

We also check for File like .doc,.docx are Inserted only if you choose other type of File then Message will be appear only .doc,.docx File are allowed other type is not Allowed.

Here is a code for Checking the Extention of the Word File are as follow

string file = Path.GetExtension(FileUpload2.FileName.ToString());

        fileExtension.ToLower();

        if (file != ".docx" && file != ".doc")

        {

            ClientScript.RegisterClientScriptBlock(this.GetType(), "ke", "<script>alert('only .Doc and .docx is allowed');</script>");

            return;

        }

this is the Image For Displaying Uploaded Image.

To Show Example of How to Upload File in MVC plz Click Here Upload File in MVC

to show Example of Export Gridview Data to PDF file Export Gridview Rows to PDF File

insert,update,delete in Modal Popup Modap Popup For CRUD operation

C# Get All Files from Folder and Subfolders and bind it in DropDownList in Asp.Net

Description:-                             

   In this Example we explain that how to Fetch List of File From the Directory that Direcory are available in our Website.

Here is a Function that will Fetch All List of File From our Cuurent Website or WebApplication are as Follow

public void ProcessFile(string path)

    {

        FileInfo fi = new FileInfo(path);

        if (Path.GetExtension(fi.Name).Equals(".aspx"))

        {

            DropDownList1.Items.Add(fi.Name);

            DropDownList2.Items.Add(fi.Name);

        }
}

in which Function we check that if File Extention is “.aspx” then and then it will be added to DropDownList. The path means we provide a string path of our Application It which they are Currentally Located.

To use this Example First you Have insert Following Namespace in your Class File like

using System.IO;
using System.Collections.Generic;

We all know that this is very useful when we have to search this File Name is Exist or Which Directory is Exist. My Real Experience when I was devloped the Website at that I have a Requirement to Calling a File a from List of File that are Available in Our Website as per Condition so at that time I was Devloped this Example and also you can use this Example for Doing this type of Solution.

Look at this above Image that Contain a Structure of the Website and Contain a List of File and Directory  that I have Fetch and Bind into the DropDownList in this Example are as show below.

to show Example of Bind Excelsheet Data to Gridview Export Excelsheet Data to Gridview 

Dynamically Create Rows Using DataTable and Bind to Gridview DataTable Example for binding data to Gridview 

Upload File and Bind to Gridview Upload File to Database and bind to Gridview

 

How to Create Nested Gridview in Asp.net

Description:-                                  

What is Nested Gridview :-

                 Gridview Contain more than one other Gridview inside in it. It’s Called a nested Gridview.this type of Facility is provided by asp.net and are very useful to store All Detail in it.

For Example:-

            Suppose we have to Display student personal information and student Education Detail at that time one gridview can not capable of Displaying All information of student like personal and Education because of each contain more Field like Name,Age etc .. in personal information and Degree,Year,Result etc.. in Educational information so that type of information one Gridview can not Display in a proper manner because of screen Width. Due to this problem we are create a Nested Gridview in which parent Gridview contain student personal information and Child Gridview contain Educational Detail so all different type of information are store in proper way.

             in this Example we use the JQuery for Expand and Collapse the Gridview.in which there are two image plus.png and minus.png when click on plus.png the Gridview row is Expand and when click on the minus.png the Gridview row is Collapse.this is the code for Jquery are as Follow

For Ex:-

            

<script src="MenuScript.js" type="text/javascript"></script>

<script type="text/javascript">

        $("[src*=plus]").live("click", function () {

            $(this).closest("tr").after("<tr><td></td><td colspan = '999'>" + $(this).next().html() + "</td></tr>")

            $(this).attr("src", "../0_Images/minus.png");

        });

        $("[src*=minus]").live("click", function () {

            $(this).attr("src", "../0_Images/plus.png");

            $(this).closest("tr").next().remove();

        });

    </script>

                So main Advantage of this Example is that we can Display our data in a Proper way so our Website user can easily Understand and we can make a user Friendlly Website through this type of example.


How to Create Nested gridview in MVC with Expand and Collapse please Click Here Nested Gridview in MVC

to show Example of How to Create a Paging in DataList click here Paging in DataList

to show Example of How to Export Gridview Data to PDF File Export Gridview Rows to PDF file

How to Export Gridview Data to PDF in asp.Net or GridView Row to PDF in Asp.Net

Description:-

                 

In this Example we Explain that How to Export Gridview data to PDF and display same Look as in Gridview in Asp or C#.Net.

In this post , I am not concerning the formatting of data into PDF. For exporting the data, I am using the iTextSharp (third party dll) in this post.

Exporting Gridview Daata to PDF you have to First of all download the iTextSharp and add the reference of following dlls into your application.

You can also Export you Data to Word or excel to show this Example Click Below Link

Export Gridview to Word :- Gridview to Word

Export Gridview to Excel :-   Gridview to Excel
 

Implement Remember Me functionality using CheckBox ASP.Net 

set WaterMark Text in PDF using itextsharp in C#

How to set Default Button in MVC Web Form Application 

How to Bind XML File data to Treeview in asp.net

JQuery datepicker calender with Dropdown month and year in asp.net.

itextsharp.dll
itextsharp.pdfa.dll

And add the  namespaces in your aspx.cs means CodeBehind  page.

using iTextSharp.text;

using iTextSharp.text.html.simpleparser;

using iTextSharp.text.pdf;

How to Export GridView Row or Record to MSExcel or ExcelSheet in Asp.Net

Description:-

In this Example we Explain That how to export Gridview rows or Record to the Microsoft Excel Document when Click on Export or Image of Excel.or export selected or checked rows from gridview to Excel sheet without using any third party control in asp.net.

If you  exporting the document to Excel directly as done in case of word the row background color is automatically  applied throughout to all the columns in the Excel Sheet.so this reason we have to avoid it.

First I am manually changing the background color of each row of the exported rows of gridview black to white.

second we are applying the background color to each individual cell of the Gridview rather than the whole row. because when you export rows you will notice that the formatting is applied only to the GridView’s cells and not all.

Also I am applying textmode style class to all cells of the Grid and then adding the style CSS class to the GridView before rendering it to the Excel or word or pdf document.

This is very useful when we have to generally Create a Report or you can Directally print the Document. In this Example when user click on the Image of Excel at that All Gridview Record are Exported to the Excel Document with same Look and same color as in Gridview.

you have set ContentType of the page Before sending or Exporting data to ExcelSheet like

Response.ContentType = "application/vnd.xls";

you can also Export your Gridview to Word or PDF to show this Example please click below link.

Export Gridview to PDF :-   Gridview to PDF

To show Example of Rotate the Ads or Advertised in Webpage Rotate Ads without Refreshing Webpage

Enter only Ahpabet in TextBox validation input only Alphabet in TextBox

How to Create Captcha Code in Asp .Net

What is Captcha code:-

                                Captcha  code is a one kind of program that Generate Grade and Test the user or Human is Pass or Not.

In this Example we explain that how to create a captcha code in asp.net to increase our website Security.

Captcha code is nothing but it is a one kind image in which Text,Letter,number,Special Symbol are Display as in Define Format and are generally used in every website for security purpose.

when image is Generated by Fuction it will assign to Image Control and Display this Image. user have enter Text into TextBox same as Display in Image. after Click on submit Button it will check the Captcha code same as entered by user if true then proceed further otherwise it will create a new Captch Code if user enter code is False.

Generally Captch Code is Generated are stored in Session Variable and assign this image to Image Control.

Advantages Of the Captha Code :-

1.       Protecting Website Registration:-

Means when user create a Registration in your Website at that time Captcha Code is Generated  and user have to insert it to register into a website so Dummy user or robort can not Access your Website.

2.       Online Polls
3.       Login into an Bank account.
4.       Sending Email etc…

How to Send SMS to User in asp.net Send SMS in asp.net

Upload File and Bind to Gridview Upload File in Database and Bind to Gridview

Example of AutoComplete TextBox Autocomplete TextBox in Ajax

To Download the Complete Project click the below Download Image Link

How to Export Gridview Row or Record to the MSWord Document in Asp.Net

Description:-

In this Example we Explain That how to export Gridview Record to the Microsoft Word Document when Click on Export or Image of Word.Exporting to Word, Excel and CSV can be easily achieved using ASP.Net without any third party tools or export only selected or checked rows or records from gridview to Word or Excel sheet using asp.net.

This is very useful when we have to generally Create a Report or you can Directally print the Document. In this Example when user click on the Image of Word at that All Gridview Record are Exported to the Word Document with same Look and same color as in Gridview.

To Export GridView Record to MSWord First we Have to set the Content Type of the Page means to Display data in MSWord like

                        Response.ContentType = "application/ms-word";

you can also Export your gridview data to Excel or PDF to show this Example please click below Link

Export Gridview to Excel :- Gridview to Excel 

Change BackGround color of gridview when row is selected select row through Checkbox and change the color

to show example of Auto Complete TextBox AutoComplete TextBox in Ajax

Example Of Royal Flush in CSS

What is Royal Flush :-

        Royal means straight containing the Highest card of the one suit, generally we all know that it is a game of card.

In this example we include that how to create a Royal Flush Game Effect in your website for that this program is very  useful.

In this Example we Display Each card Overlaps with each Other like hiding one another.

To display on eachother we use a z-index property of the CSS like as Follow

#king_of_diamonds {

       position: absolute;

       left: 145px;

       top: 145px;

       z-index: 4;

}

What is z-index property in CSS:-

The z-index property specifies the stack order of an element.
An element with greater stack order is always in front of an element with a lower stack order.

Syntax:- object.style.zIndex="1"

Example of Vertical Menu in CSS Beautiful Vertical Menu Using CSS

OverLaps Layer with Each Other in CSS Display Layer on EachOther or OverLaps Layer

CSS Positionning -Fixed, Absolute,Relative and Static Position in CSS

Positioning

The CSS positioning properties allow you to position an element. It can also place an element behind another, and specify what should happen when an element's content is too big.
Elements can be positioned using the top, bottom, left, and right properties. However, these properties will not work unless the position property is set first. They also work differently depending on the positioning method.
There are four different positioning methods.

---

Static Positioning

HTML elements are positioned static by default. A static positioned element is always positioned according to the normal flow of the page.
Static positioned elements are not affected by the top, bottom, left, and right properties.

Example of Vertical Menu in CSS Beautiful Vertical Menu Using CSS

OverLaps Layer with Each Other in CSS Display Layer on EachOther or OverLaps Layer

How to Display Overlaps Layer on one Another in CSS

What is Layer :-

        Layer means peace of Html display on a top of the page with in pixel Format.
To Define the one layer you have to first set it’s position and width and height.

  For example:-

div.layer1 {    

                               background-color:lime;

                             width:150px;

                             height:150px;

                               position:relative;

                             top:10px;

                               left:80px;

                               z-index:4

                             }

The above code display that the one Layer is create with Lime  color and its width and Height is 150*150. And  Z-index Define the priority that which Layer are display on top and which are bottom. Left and Top Display the position of pixel the image or Content should be Display in Left or top Side.

Example of Vertical Menu in CSS Beautiful Vertical Menu Using CSS

OverLaps Layer with Each Other in CSS Display Layer on EachOther or OverLaps Layer

In this example we are create three layer and each layer are overlaps with each other.