Use DataTables on a ASP.NET GridView?

autodafe

We have several GridView used in our project. We would like to apply DataTables to these GridView. Is it there a way toget the HTML from the GridView and pass it to DataTables?

allan

This thread might be of some interest to you: http://datatables.net/forums/discussion/8256 . There are a number of other discussions about GridView as well.

Basically as long as it generates a TABLE with a TBODY and THEAD, then yes, you can use DataTables.

Allan

jp_noronha

Hi autodafe,

i made a gridview class to deal with datatable, as soon as possible i will post it. still in the process of translating to english and making some examples to demonstrate.

joao noronha

autodafe

@allan
thanks, I have seen that post

@jp_noronha
looking forward for your class and examples !!! if yiou wish to share it with me please contact me, I can give you my email address ;-)

autodafe

so far I have got it "half-working"
but only if I add:

protected void Page_Load(object sender, EventArgs e)
{
GridView1.PreRender += new EventHandler(GridView1_PreRender);

}

void GridView1_PreRender(object sender, EventArgs e)
{
if (GridView1.Rows.Count > 0)
{
GridView1.UseAccessibleHeader = true;
GridView1.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}


in the .cs file for the Page.
It adds a "search box", formats rows, but still need to check sorting and other features....

jp_noronha

use this:

[code]
///
/// Adds THeader e TBody tag to gridview
///
/// the gridview
public static void MakeAccessible(GridView grid)
{
if (grid.Rows.Count <= 0) return;
grid.UseAccessibleHeader = true;
grid.HeaderRow.TableSection = TableRowSection.TableHeader;
if (grid.ShowFooter)
grid.FooterRow.TableSection = TableRowSection.TableFooter;
}
[/code]

call it like this:
[code]
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);

MakeAccessible(objGridView);
}
[/code]

autodafe

Sorry for my Very Long post (you can delete if you want)
I got it working, it was a stupid error on my side (i was missing a "}" ) shame on me.... ;-)

autodafe

this is the HTML I get from my DataGrid, it has THEAD and TBODY



 CodiceNomeLivelloProfiloTipologiaPerc. Part TimeData assunzioneData dimissioni 





A05

Alberto Bruni


Liv 2

Magazziniere/Assistente

Collaboratore

100


27/12/2007








A10

Francesca Azzurri

Liv 1


Impiegato/Altro

Dipendente

100

04/01/2011
















Sorry if it's a bit too long....Copy/paste in JSBin WORKS (try it on http://live.datatables.net)



But DataTables on my pages doesn't work at all

i call it using simply:


$(function () {
$('#grdPersonale').dataTable();

mohammad_mc

first put this method on your page:

[code]

public static void MakeAccessible(GridView grid)
{
if (grid.Rows.Count <= 0) return;
grid.UseAccessibleHeader = true;
grid.HeaderRow.TableSection = TableRowSection.TableHeader;
if (grid.ShowFooter)
grid.FooterRow.TableSection = TableRowSection.TableFooter;
}

[/code]

then use it on onrender event of gridview:

[code]

protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);

MakeAccessible(objGridView);
}

[/code]

if you use master page the ID of gridview will change by the ASP.NET so datatable cant find your gridview by ID an all that you need to do is to set ClientIDMode attribute to static like this:
[code]

[/code]


and finally write jquery function:

[code]

$(document).ready(function () { jQuery('#gv_show_groups').dataTable(); })

[/code]

hope this helps you :)

varaprasadreddy

Hi please look for ASP.Net GridView

http://www.reddyinfosoft.blogspot.in/2012/12/jquery-datatable-plugin-in-aspnet-using_15.html

and For ASP.Net Repeater

http://www.reddyinfosoft.blogspot.in/2012/12/jquery-datatable-plugin-in-aspnet-using.html

gaffar

not working

gaffar

reddyinfosoft site went for long sleep