How to trigger row click event with DataTables and jQuery

Question

I am retrieving data from sql server into DataTables and needing a way to click on the table row to access more information. Here is my javascript:

$(function () {
  $("[id*=tblAccount]").prepend($("<thead></thead>").append($(this).find("tr:first"))).DataTable({
    "paging": true,
    "lengthChange": true,
    "searching": true,
    "ordering": true,
    "info": true,
    "autoWidth": true,
    "responsive": true,
    "dom": 'lBfrtip',
    "buttons": ['excel', 'print', 'pdfHtml5'],        
  });
})

<asp:GridView ID="tblAccount" runat="server" AutoGenerateColumns="false" CssClass="table table-bordered table-striped">
  <Columns>
    <asp:BoundField DataField="ACCOUNT_NUMBER" HeaderText="Account Number" />
    <asp:BoundField DataField="COMPANY_NAME" HeaderText="Tax Type" />
  </Columns>
</asp:GridView>

How can I click on the table row to access another page?

score 1 · Accepted Answer · 2018-12-07 05:41:37Z

1

As far as I understood the question, you may simply attach event handler to DataTable rows, like so:

$('table tbody tr').on('click',function(){
    //retrieve your extra details
});

However, I'd rather suggest to use DataTables embedded feature to display extra details inline: https://datatables.net/examples/api/row_details.html

edited Dec 7, 2018 at 5:41

answered Dec 6, 2018 at 16:38

user3307073

Sign up to request clarification or add additional context in comments.

1 Comment

Shane Over a year ago

Thank you! Your suggestion to display external details inline is just what I needed.

Jigar · Accepted Answer · 2018-12-07 05:45:31Z

1

you can write click event like this also.

$(document).on('click','table tbody tr',function(){
    //code here
});

answered Dec 7, 2018 at 5:45

Jigar

3,2833 gold badges36 silver badges55 bronze badges

Collectives™ on Stack Overflow

How to trigger row click event with DataTables and jQuery

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related