Delete row from datatable

Hi there, if you're using a DataContext of some sort you can use the following. Substitute 'DataContext' with the name of your data context, and 'TableName' with the name of the table you're deleting from.

using System.Linq;

using (DataContext dc = new DataContext())
{
   // Retrieve the customer from the database using the ID
   var deletedCustomer = (from c in dc.TableName
                          where c.customer_id == CustID
                          select c).Single();

   try
   {
      // Sets the deletion of that customer to pending
      dc.TableName.DeleteOnSubmit(deletedCustomer);

      // Attempts to commit the change.
      dc.SubmitChanges();
   }
   catch (Exception ex)
   {
      // Your error handling
   }
}