GRIDVIEW Archives - Dot Net Tricks

Export Data From GridView To Excel in Asp.net

By Abdul Khursheed March 21, 2013

A good way to display data is to show it in a GridView. However, it becomes difficult to manipulate and filter large amounts of data in this way. Exporting data to an Excel file is a great solution for handling large amounts of data because Excel has many features -- such as sorting, searching and filtering.

ASP.NET GRIDVIEW

Get Multiple DataKeyname Values from Gridview RowCommand in Asp.net

By Abdul Khursheed March 14, 2013

Get multiple datakeyname values from gridview rowcommand in asp.net DataKeyNames="yourColumnName" If we want to get this DataKeyNames value from gridview in rowcommand event we will get it like this protected void gvUserInfo_RowDataCommand(object sender, GridViewCommandEventArgs e) { GridViewRow gvrow; string str = gvUserInfo.DataKeys[gvrow.RowIndex].Value.ToString(); } If we want to declare multiple DataKeyNames values we will declare it as DataKeyNames="Column1,Column2,Column3" Now if we want get these DataKeyNames values we will declare it like this

ASP.NET GRIDVIEW JQUERY WEB SERVICE

Display data on Click of Row in GridView using Jquery and Web Service in Asp.net

By Abdul Khursheed March 12, 2013

Display data on Click of Row in GridView using Jquery and Web Service in Asp.net //Table Script————————————————–------------------------------------------------------- CREATE TABLE [tblgrid]( [UserId] [int] IDENTITY(1,1) NOT NULL, [userName] [varchar](50) NULL, [City] [varchar](50) NULL, [Designation] [varchar](50) NULL, [sal] [bigint] NULL ) Design Page or Aspx Page---------------------------------------------------------------

ASP.NET GRIDVIEW JQUERY

Display data on Click of Row in GridView using Jquery in Asp.net

By Abdul Khursheed March 12, 2013

Display data on Click of Row in GridView using Jquery in Asp.net //Table Script-------------------------------------------------- CREATE TABLE [tblgrid]( [UserId] [int] IDENTITY(1,1) NOT NULL, [userName] [varchar](50) NULL, [City] [varchar](50) NULL, [Designation] [varchar](50) NULL, [sal] [bigint] NULL ) Aspx Page or Design Page-------------------------------------------

ASP.NET GRIDVIEW

Custom Pagination in GridView with Formatted using Asp.net

By Abdul Khursheed February 26, 2013

Follow the Below Code to achieve result Default.aspx------------------------------------------------------------------------------------------------

ASP.NET GRIDVIEW JAVA SCRIPT

Select All CheckBox inside GridView Using JavaScript in Asp.net

By Abdul Khursheed February 25, 2013

To select all the checkbox at a time inside the gridview using JavaScript go through the below code. You can get the values of each checkbox wheather it is checked or not in step 4. Step 1:

ASP.NET GRIDVIEW

Use of CheckBox in GridView with paging in Asp.net

By Abdul Khursheed February 25, 2013

Step 1:

ASP.NET GRIDVIEW

Paging Using SQL and DIV without using any Control (ie:Grid/Repeater)

By Abdul Khursheed February 25, 2013

Follow these 3 steps: Create a page named as paging.aspx Create Table named as ProductDetails Create a storedprocedure named as SQLPaging paging.aspx :

< < Prev Next >>

paging.aspx.cs :

ASP.NET GRIDVIEW

Export Data From Gridview to Excel in Asp.net

By Abdul Khursheed February 25, 2013

Step 1: Create a page GridToExcel.aspx and write the below code.

Step 2: In the GridToExcel.aspx.cs page write the below 4 functions in your code. protected void Page_Load(object sender, EventArgs e) { FillData(); } protected void FillData()

ASP.NET GRIDVIEW

Multiple row deletion in GridView in Asp.net

By Abdul Khursheed January 23, 2013

Multiple row deletion in GridView in Asp.net on Button Click CheckBox chk = new CheckBox();…