The OP had asked about using a button, but all the comments and code above seem to only allow you to remove the row by clicking a cell in the row. Dim column As DataColumn Dim row As DataRow Dim view As DataView ' Create new DataColumn, set DataType, ColumnName and add to DataTable. Disclaimer: This site is started with intent to serve the ASP. Also, datatables supported the mobile responsive display. I have a requirement, where, when I click on the button, the row data corresponding to the button needs to be deleted. Rows(dgvData. C# Tutorials: Populate DataGridView From DataTable In C#. I want to add button on each row for edit and delete(like below image) I have tried with code: Test. I've got options to either delete a row or restore a row if it has been previously deleted. dataTable object, information about the table is read directly from the HTML page. This example modifies the multiple row selection example by only allowing the selection of a single row. Sets additional column variables to facilitate custom columns. In order to implement the jQuery Datatable, follow the below mentioned steps. For example, this might be activating a user account in a list of users, where you simply click an Activate button. Fork anonymous (public) fiddle? - Be sure not to include personal data - Do not include copyrighted material. In this you can insert new rows in database, edit existing row and update the row in database and delete any row in database. body" But I don't know how to retrieve the other values like "service" or "datarows" Thank you for your help !. Customised control buttons Very often, when editing a form, the system user is required to perform a repetitious task that you wish to optimise the action of. One guy asked me a question, he was having problems in updating and deleting rows when looping through a DataTable rows. We are using two of DataTables methods to add and remove rows from the table. The datatable contains data from a sharepoint list. I currently face 2 problems: When I delete more than 1 row, I get a pop-up modal for each row that is being deleted ( I should only get the modal once, but it is handling each request separately). I have a DataTable bound to an ObjectListDataProvider. - Kevin Meredith Aug 15 '17 at 13:22. This code is not reviewed. The table of data should be refreshed so that the deleted row is not visible. HTML preprocessors can make writing HTML more powerful or convenient. Can I refresh datatable after change row data (update, delete. If a row is unselected, the button will be disabled. In table form controls Many of the Editor examples use Buttons to provide buttons and row selection interaction options. how to add button on each row in jquery datatable. jQuery delete table row click: This article explains how to remove selected table row. This is a Bootstrap html, css and javascript snippet. I am trying to add a button into a row in a table. It contains the value 0 or 1, which represent the status 'not active' and 'active'. I have some issues in deleting a row on click of a button. In this article, you learned about adding any sort of button, link or action within jquery datatables which corresponds to a particular row in order to perform operations like CRUD (Create, Read, Update, Delete). If you want to see how awesome this is. Live example. I have installed according to the manual and installation instructions, however I cannot get the buttons to respond. I have made it to put some buttons in one column of the table, so user can interact with each row's data. Vue jQuery DataTables. Dynamically add and delete html table row on user click using jQuery. Please note - this property requires the Editor extension for DataTables. NET Framework and DataGridView control to display the Book table stored in the BookStoreDB database of SQL Server Express. List of IT requests built using the Script Editor web part To illustrate the process of migrating a SharePoint customization. I feel it is duplication of buttons in each row, instead we can select one row and click on edit/delete button somewhere at the top as shown in this example. Here is an example with table having edit and delete in each row. In table form controls Many of the Editor examples use Buttons to provide buttons and row selection interaction options. For example, this might be activating a user account in a list of users, where you simply click an Activate button. dataTables and jquery. SelectedRows(0). This example modifies the multiple row selection example by only allowing the selection of a single row. Binding Angular directive to the DataTable. From this video. In this web tutorial you can find how to made PHP PDO Insert Update Delete Select Data Operation system by using Ajax JQuery with DataTables server-side processing and Bootstrap modal. I have a requirement, where, when I click on the button, the row data corresponding to the button needs to be deleted. About HTML Preprocessors. The List view forms the launching view where records are displayed and you can choose to Edit, Delete or Insert a record. In our upcoming videos we will discuss writing a generic handler that calls. I work with Datatables. Im trying to populate the column values using a datamodel. This method will bind values of selected row into textbox, hides save button, show update button and stores primary key value of selected record in hiddenfield. Here we have perform Live Datatables table add edit delete using Ajax jquery in PHP Mysql. Tengo una tabla (datatable) la cual hago una consulta en php. Using the above code you sent under the delete button click event you'll expect to see a row of data removed , unfortunately this isn't the case, at least not immediately. This code is not reviewed. (check one with "x") [ ] bug report => search github for a similar issue or PR before submitting [x ] feature request [ ] support request => Please do not submit support request here Current behavior tables without bu. This is used by many of the examples on this site. The DataModel is the backing data for the view, and isn't supposed to actually be the Domain Model. $() when working with rows in the table to ensure that all rows are considered, regardless of paging and filtering. 10 has changed the parameter names. jQuery Datatable is very lightweight and gives us some inbuilt functionalities like searching and sorting etc. The data table has delete button on each row in case a user wishes to remove a row. com/public/1zuke5y/q3m. Windows DataGridView with inline edit and remove buttons only rather than displaying the buttons on all rows at once. Customised control buttons Very often, when editing a form, the system user is required to perform a repetitious task that you wish to optimise the action of. Delete button is always disabled but when user select any row in the table it becomes enabled and user can delete selected row by pressing it. Join a community of over 2. margin-bottom-xs{margin-bottom:10px}. php(143) : runtime-created function(1) : eval()'d code(156) : runtime. The following example creates a simple DataTable with two columns and ten rows. 1- Creación de la base de datos: Empezaremos creando la base de datos, para ello debemos abrir nuestra herramienta de gestión de base de datos y crear la base de datos. AcceptChanges(). i'm using datatables editor with the buttons 'new', 'edit' and 'delete'. This works by reading the state as the button is created (which is generally during the initialisation of the table) and then restoring those values when activated by the end user. jeditable Recently I was asked to help on a private project of making a database accessible and searchable in a HTML frontend using HTML tables. In order to "delete a row from a datatable", therefore, you must remove it from the DataModel. Here in this post i will show how to group rows using Jquery DataTable Plugin. This example shows a modification of the multiple row selection example, where just a single can now be selected. net using c#, vb. net MVC C#, if you haven't read the first article, please check part-1 article first, as we will continue the remaining operations of create, Edit and delete in this part, you can already see List from database in jQuery datatable using WEB-API with. child API methods. let me re-describe same problem , I used below code for edit and delete column but it shows 0 (zero) in action method when want to edit (pass departmentid zero) or delete record. Join a community of over 2. In this article, you learned about adding any sort of button, link or action within jquery datatables which corresponds to a particular row in order to perform operations like CRUD (Create, Read, Update, Delete). For instance, Markdown is designed to be easier to write and read for text documents and you could write a loop in Pug. The OP had asked about using a button, but all the comments and code above seem to only allow you to remove the row by clicking a cell in the row. PunchEventTable. This is used by many of the examples on this site. jquery dataTables - how to add an edit and delete option. $() when working with rows in the table to ensure that all rows are considered, regardless of paging and filtering. The app is live here. If you are not using the Angular way of rendering your DataTable, but you want to be able to add Angular directives in your DataTable, you can do it by recompiling your DataTable after its initialization is over. body" But I don't know how to retrieve the other values like "service" or "datarows" Thank you for your help !. cancel = True. This is what I'm trying to achieve in this event,. In order to implement the jQuery Datatable, follow the below mentioned steps. The DataTables Content Delivery Network (CDN) is a permanent store of the software released as part of the DataTables project for you to use on your site without needing to host it yourself. To do that the following line of code can be used to set the Primary Key in the database to the DataTable. 9, and DataTables v1. Source codes here on Github (as comparison of two commits); YouTube video-lessons Playlist; Yajra’s DataTables Package; Previous article about Fake Users Generation with their images; Article. SelectedRows(0). NET Framework remoting. 'Delete Rows' button, the selected rows get deleted. table datatable bootstrap-3 snippet datagrid hover layout template gmail scrolling span data delete confirm edit pager pagination plugin fuelux grid data-grid dropdown button position modal pt sidebar list-group gradient. I am able to delete 1 or multiple rows on a checkbox selection. One of the frequently used jQuery plug-ins is DataTables. 2 comments on "AngularJs: Delete Table Row tr on button click" Chris Geirman October 28, 2017 at 2:56 am I did something similar to this, but rather than delete the row immediately, I left a dismissable confirmation in it's place. Hi , iam insert data through gridview using datable, and i have 2button , insert and delete button , i wants to delete a row from the gridview using delete button below the code i constructed for i. row() not working on. In this blog, I am going to demonstrate how to show list data in a table with action (edit and delete) buttons using Datatables JS. Example snippets with Bootstrap HTML, JavaScript and CSS. This one is also straightforward. In this tutorial we will show you how to add, edit and delete records using jQuery, Ajax, PHP and MySQL. DataTables in Codeigniter ( Add Edit and Delete Buttons ) Select Multiple Rows With Checkboxes Using jQuery DataTable CodeIgniter and Jquery Ajax - Crud select insert update delete. Net using C# or jQuery DataTables and ASP. I would encourage you to read Scott Mitchell's article for the same. This page is a quick access reference for initialisation options and API methods. Now that we have this implemented, what advantage does this approach provide? We have the ability to create custom reports using SOQL and the output uses the DataTables interface, which provides more flexibility when viewing the data such as multi sorting and instant search. Yes, both Add and Delete button can be shared by all rows in the datatable. This is one of the most common problems users have with jQuery DataTables plug-in and it has very simple solution if you understand why it occurs. If you are not using the Angular way of rendering your DataTable, but you want to be able to add Angular directives in your DataTable, you can do it by recompiling your DataTable after its initialization is over. 2 comments on "AngularJs: Delete Table Row tr on button click" Chris Geirman October 28, 2017 at 2:56 am I did something similar to this, but rather than delete the row immediately, I left a dismissable confirmation in it's place. One main feature is the row actions - it is really cool, but I want to show actions as specific columns and not as a dropdown menu. Basically, I had to write this functionality for one of my client's projects. Select a row from a table of data, click a button to delete the row, and remain on the same page. cancel = True. I would like to create a button that, when pressed, it would remove a record that is highlighted within a datatable. using bootstrap which is setup) Any help appreciated. The most concise screencasts for the working developer, updated daily. I have a datable where the last column contains two buttons (summary and edit) but I only want the buttons to be visible if the flags in each of the columns 2 and 3 are set to true? so if column 2=true then show summary button, if column 3 =true then show edit button. Tables plug-in for jQuery. datatables - preload data to array via ajax performs multiple connections. We can pass this array to Datatables as a dataset or create row dynamically from the array and add it to the table. Event handler is attached as follows:. like datatables. Clicking on “Edit” button should open a modal dialog. In the row of the database you have a button that allow moving on to move detailed information about the user (moving to another page, another datatable). I would like to add a column. When you initialise the jQuery. Data tables are widely used in applications to show data sets with necessary features which are must to have for good user interactions like Pagination, Sorting by columns, Scrollings in horizontal and verticle directions, etc. Event handler is attached as follows:. 6 demos of Bootstrap data tables with paging, rows per view and more The data tables and Bootstrap In the table tutorial of Bootstrap , I showed how you can create simple tables by using Bootstrap built-in classes. select would work. The problem is that when you click the Add button and a new row is added successfully, rather than expose the Delete button for that particular GridView control ID, all the Delete buttons for all three Gridviews are exposed. For instance, Markdown is designed to be easier to write and read for text documents and you could write a loop in Pug. DataTables 1. Table2 with key of field from table1 e. Keep the rest of the files unchanged. Since the datatable isn't sorted for the final output, I don't see how a. I am deleting my rows via Ajax outside of my datatable definition. Log in if you'd like to delete this fiddle in the future. DataTables – Data from Ajax, Edit in Place Quite often, when it comes to tabular data and the need to put them on the screen in a convenient form with various additional features, we can seriously consider how exactly can this be accomplished?. NET Forums / General ASP. Note that the data table and the buttons make ajax requests. Example on how to use jquery. Description. This is very simple javascript function using jQuery library for deleting or adding html table row on user click. But now row 1 in the table corresponds to row 0 in the DataGridView, so if. Hi, I'm trying to implement datatables in my mvc application. I'm submitting a. Instalación del CRUD de datos usando dataTables, Bootstrap, PHP y MySQL. i have an update button for every row. DataTables example - Export buttons. Also, datatables supported the mobile responsive display. Angular 6 Editable Table Row. Add, edit, delete row to dataTable on the fly using PrimeFaces Posted on November 18, 2012 by admin 17 comments This tutorial will show how to add, edit, delete row to data table on the fly. Datatables implementation in laravel — justlaravel. My problem: I have the column 'active' in my table. Binding Angular directive to the DataTable. When the button is clicked, a message is shown. 1) was using DataTables v1. How to delete row on Click of Button in Data Table. select would work. Private Sub MakeDataTableAndDisplay() ' Create new DataTable and DataSource objects. Does anyone know where I can find an example of this type of table?. Fork fiddle. Remove Methods DataRow. dataTables and jquery. It is passed the row node which can then be modified. I have a delete button which does this: TTDataSet. We are using two of DataTables methods to add and remove rows from the table. Arrays and array-like objects with a length property (such as a function's arguments object) are iterated by numeric index, from 0 to length-1. Customised control buttons Very often, when editing a form, the system user is required to perform a repetitious task that you wish to optimise the action of. net vb? how can I have a row delete based on user selection in the form. currentTarget to get the id of the button clicked, use that id in a switch statement in order to identify which one was and base on that call the correct. The DataTables Editable plug-in will disable the button initially and when the user select a row in the table, the button will be enabled again. My problem: I have the column 'active' in my table. Difference between DataRow. The data table has delete button on each row in case a user wishes to remove a row. If you are not using the Angular way of rendering your DataTable, but you want to be able to add Angular directives in your DataTable, you can do it by recompiling your DataTable after its initialization is over. On button click, we remove selected row/tr may be its dynamically added table row or already available on DOM. -**- In button delete click event - get the index of the selected datagridview row - remove the Selected Row VB. This example shows a modification of the multiple row selection example, where just a single can now be selected. Description. When delete button in actions column is clicked a modal pops up, asking for delete conformation. Here in this post i will show how to group rows using Jquery DataTable Plugin. In order to "delete a row from a datatable", therefore, you must remove it from the DataModel. This is useful in order to tell the server what row is being updated - this can readily be expended to include column information as required. With DataTables, you can easily build powerful data overviews of data coming from both SharePoint and external APIs. The table of data should be refreshed so that the deleted row is not visible. I am trying to add a button into a row in a table. My row selection action navigates away from the page where the datatable is, so this is not a desired result. in this c# tutorial we will see How To Add a row to datagridview an update a row and delete it in c# steps: 1 - create a new csharp project our a new form in existing project. Take a look at the implementation of datatable:. How to delete row on Click of Button in Data Table. Also, datatables supported the mobile responsive display. You can also make your own custom column definitions via Following video. The problem is if the command button is clicked the delete happens as expected but the rowselector still gets fired and selects the next available row. Hi everyone, I'm using the datatable for a CMS and I'm having troubles when deleting a record, I first make the call to the ajax and delete the actual [datatables] Server side delete row - jQuery Forum. We can pass this array to Datatables as a dataset or create row dynamically from the array and add it to the table. Vue jQuery DataTables. NET Forums / General ASP. datatables - preload data to array via ajax performs multiple connections. margin-left-xs{margin-left:10px}. The basic idea here is that the data isn't actually removed from the database, but simply marked as deleted allowing a WHERE condition to be applied, removing that data from the user's view. I am deleting my rows via Ajax outside of my datatable definition. This article shows you how to add the row selection feature in a JSF datatable using selectOne radio buttons, and provides an example JSR 168 portlet implementation using IBM Rational Application Developer 6. Here is an example with table having edit and delete in each row. Ask Question But I'd like to add the ability to delete and or edit a row. This is a Bootstrap html, css and javascript snippet. Using the above code you sent under the delete button click event you'll expect to see a row of data removed , unfortunately this isn't the case, at least not immediately. Go ahead insert more than 20000 records. The Buttons that Editor defines are documented below. You can modify the column in the datatable to add the button with modal. 10 has changed the parameter names. In this part you just need to provide URL of edit page with its parameter. 2), you may need to change some parameter names for your DataTables, because Shiny (<= v0. Log in if you'd like to delete this fiddle in the future. Is there a way to add an IF statement? here's my code so far: "columnDefs": [. The content posted here is free for public and is the content of its poster. I was previously using a row click event but changed it to the button as I didn't want row clicks to unintentionally trigger the event handler function. This code is not reviewed. Clicking on the "Select All" checkbox worked in that the checkboxes in every row across all pages (3 pages) were checked. I have a datatable, which contains 5 columns. Customised control buttons Very often, when editing a form, the system user is required to perform a repetitious task that you wish to optimise the action of. VueJS DataTables Snippets with Delete Button Component - DataTable. Just add HTML/Blade code for the button you want. In all our demo datatable, we have column template with some custom buttons. The result is that a datatable in which the rows are removed can never be used to update a database (exact what you want). The Buttons that Editor defines are documented below. javascript jquery datatables Adding lines to table with jQuery and DataTables was published on July 27, 2013 Sebastian Dahlgren. I am trying to have my script delete the row completely once the "locatebutton" has been pressed. I was waiting for the new release of the lightning:datatable component to see if now with new version this component could be useful to really suit my needs. The most concise screencasts for the working developer, updated daily. In this blog, I will show how to use jQuery DataTable with the Delete button. Delete row in datatable in JSF example program code : JSF h:dataTable tag is used to render and format HTML table element. php(143) : runtime-created function(1) : eval()'d code(156) : runtime. remove()) will remove the selected row from the DataTable completely, deleting the allocated memory for data and node from the browser. My row selection action navigates away from the page where the datatable is, so this is not a desired result. Hi everyone, I'm using the datatable for a CMS and I'm having troubles when deleting a record, I first make the call to the ajax and delete the actual [datatables] Server side delete row - jQuery Forum. If you have used DataTables in Shiny before (specifically, before Shiny v0. Vue jQuery DataTables. Hi everyone, I'm using the datatable for a CMS and I'm having troubles when deleting a record, I first make the call to the ajax and delete the actual [datatables] Server side delete row - jQuery Forum. Dim table As DataTable = New DataTable() ' Declare DataColumn and DataRow variables. This method can be used to delete an existing record using the Editor main form. On button click, we remove selected row/tr may be its dynamically added table row or already available on DOM. Changing the background color of table rows depending on cell values using JQuery/DataTables/Bootstrap Here the final table we would like to generate : different properties appear on that table like changing color row column depending on the value of the colums, applying color on columns values depending of the inconsistency of the values (for. currentTarget to get the id of the button clicked, use that id in a switch statement in order to identify which one was and base on that call the correct. You can also make your own custom column definitions via Following video. Fork fiddle. margin-bottom-xs{margin-bottom:10px}. Table1 ProductId ProductName Table2 [2005] How to handle datatable delete row problem-VBForums. After deleting several DataRow items with the Delete method, one of the rows is undeleted by invoking RejectChanges. jQuery Datatable is very lightweight and gives us some inbuilt functionalities like searching and sorting etc. This item is inserted into the table and is selected. PHP MySQL CRUD (Create, Read, Update, Delete) Operations using jQuery PHP MYSQL CRUD PHP MySQL CRUD is all about INSERT, UPDATE, DELETE and SELECT SQL queries using PHP , it will help beginners to know about PHP and MySQL operations. Description. It is possible to add new row. While this can be useful for allowing the user to edit all fields at the same time, or to select the rows to delete, you might wish to show the row controls inline with the table, rather than using row selection. Remove Methods DataRow. Hey, I have a bunch of DataTables on my pages. You can use a template to define the contents of a subrow, while a subview can contain any Webix widget. I would encourage you to read Scott Mitchell's article for the same. This example shows a modification of the multiple row selection example, where just a single can now be selected. DataTables 1. This is used by many of the examples on this site. When the button is clicked, a message is shown. Why should we use jQuery Datatable. Live example. I need to delete rows based on their index from the dataview (rows 0-199, or rows 200-399, etc. In one of my previous famous post in which we have already seen how to live add edit delete records from simple html table by using PHP with Ajax Mysql. Difference between DataRow. Take a look at the implementation of datatable:. Note that the data table and the buttons make ajax requests. body" But I don't know how to retrieve the other values like "service" or "datarows" Thank you for your help !. This example modifies the multiple row selection example by only allowing the selection of a single row. HTML preprocessors can make writing HTML more powerful or convenient. NET Forums / General ASP. Fork anonymous (public) fiddle? - Be sure not to include personal data - Do not include copyrighted material. This is done by checking to see if the row already has a selected class, and if so removing it, but if not then the class is removed from all other rows in the table and then applied to the row being selected. Does anyone know where I can find an example of this type of table?. I have the following code however I cannot seem to get it working right. NET Developer / Delete row From Datatable on click of Delete button Delete row From Datatable on click of Delete button [Answered] RSS 3 replies. dataSrc プロパティ内で返されるデータが DataTables の内部で使用されるため、このコンテキストでは any 型の使用は悪くありません。. Arrays and array-like objects with a length property (such as a function's arguments object) are iterated by numeric index, from 0 to length-1. In the previous page, you learnt to use the ADO. Can I refresh datatable after change row data (update, delete. It is just for easy demo purpose. DataTables Example - Customised Control Buttons - Free download as PDF File (. This is useful in order to tell the server what row is being updated - this can readily be expended to include column information as required. But alas, I can't get it to trigger right. I'm displaying a datatable that selects a number of elements from the database (IncomingsId, Type, Cost, Frequency) and I'm not sure how to delete a row when a button is clicked. In our upcoming videos we will discuss writing a generic handler that calls. For every table, we generate three actions - View, Edit and Delete. DataTables in Codeigniter ( Add Edit and Delete Buttons ) Select Multiple Rows With Checkboxes Using jQuery DataTable CodeIgniter and Jquery Ajax - Crud select insert update delete. I also display a modal on a successful delete. Live example. The following example creates a simple DataTable with two columns and ten rows. Select a row from a table of data, click a button to delete the row, and remain on the same page. Couple of issues I am facing with an inline editable DataTable with add, edit, delete cancel buttons. Specifically, i have dataset with 2 datatables in it. These rows are initially hidden and can be shown by clicking on expand/collapse control. To make use of the buttons below, you simply need to modify the aButtons initialisation option for TableTools, as shown in the example below. The first row shows columns with the following data: Cloudhub, 20%, $25,000. Take a look at the implementation of datatable:. Here is what we want to achieve: The final application. Note that the data table and the buttons make ajax requests. without any button in datatable executes well. Notice where the button is shown and under which gate/permission – for view/edit/delete. Hi, I'm trying to implement datatables in my mvc application. The Buttons extension for DataTables is used by the majority of the Editor examples to provide row selection functionality and the New, Edit and Delete buttons at the top of the table. Angular2 datatable for handling large and complex datasets in table format. Notice: Undefined index: HTTP_REFERER in /home/forge/newleafbiofuel. 9, and DataTables v1. NET Integration for GridView Previously i had been shown how to use JQuery DAtaTable for repeater and now i will show how to use it for GridView in asp. dll,减少了非常多的页面脚本 带数据库SQL文件. net which already offers part of that. Child rows can be used to show extra details that do not fit into the main table. From this video. NET Developer / Delete row From Datatable on click of Delete button Delete row From Datatable on click of Delete button [Answered] RSS 3 replies. HTML preprocessors can make writing HTML more powerful or convenient. The Buttons that Editor defines are documented below. Go ahead insert more than 20000 records. remove()) will remove the selected row from the DataTable completely, deleting the allocated memory for data and node from the browser. About HTML Preprocessors. This plugin was provided by third party vendor for DataTables, but the link provided was not working so i decided to show how to use it in this post for more examples U can refer. Angular DataTables. Delete one row in record displayed having another form. Buttons to delete, edit and compare Datatable rows. This is one more post on Codeigniter Ajax Crud using DataTables, In this part we will learn how to update or edit Mysql table data in Codeigniter Framework by using Ajax method and load data in DataTables Jquery plugin without page refresh. NET Tutorials: Populate DataGridView From DataTable In VB NET. This will remove the details rows for the current master row. The Buttons extension for DataTables is used by the majority of the Editor examples to provide row selection functionality and the New, Edit and Delete buttons at the top of the table. txt) or read online for free. Datatables print icon Datatables print icon. NET Developer / Delete row From Datatable on click of Delete button Delete row From Datatable on click of Delete button [Answered] RSS 3 replies. I am trying to have my script delete the row completely once the "locatebutton" has been pressed. Now that we have this implemented, what advantage does this approach provide? We have the ability to create custom reports using SOQL and the output uses the DataTables interface, which provides more flexibility when viewing the data such as multi sorting and instant search. jQuery Datatable is very lightweight and gives us some inbuilt functionalities like searching and sorting etc. When delete button in actions column is clicked a modal pops up, asking for delete conformation. I try to add that, there are two methods to delete/remove a row from a datatable.