----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Sitaraman Message 4 in Discussion Hi Agree with Manoj that the Delete method marks it for deletion and the Remove method entirely removes the row. The Catch and is "where does it delete from". Does remove delete it from the underlying datasource???Does it instruct the dataadapter to delete it from the actual datasource. It doesnt. Pls refer to the snippet below <msdn_snip> When using a DataSet or DataTable in conjunction with a DataAdapter and a relational data source, use the Delete method of the DataRow to remove the row. The Delete method marks the row as Deleted in the DataSet or DataTable but does not remove it. Instead, when the DataAdapter encounters a row marked as Deleted, it executes its DeleteCommand to delete the row at the data source. The row can then be permanently removed using the AcceptChanges method. If you use Remove to delete the row, the row will be removed entirely from the table but the DataAdapter will not delete the row at the data source. </msdn_snip> The complete article is available at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpcondeletingdatarowfromdatatable.asp and explains clearly the exact difference between the Remove and the Delete method regards, sr ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
