C# Delete database records without SQL text?

Question

Hi all I need to delete rows from my db when the criteria is: older than a certain date. Can it be done without an SQL string query?? Using only a DataSet and/or DataAdapter? The regular SQL would be: DELETE FROM EventLog WHERE EL_TimeStamp But the problem is using the date in C# and Access-database. Thanks in advance Danny

Enam ulhaque · Answer

Yes you can. You have to localize the date according to your date format using Culture class.But if you are using windows data time format then you don't need to localize it(as i guess it works fine). But if you have problem with localization then do check the date using datepart() function of sqlserver.(if u r using it) Then using adapter's delete command u can update your database using dataset. e.g. SqlDataAdapter ad= new SqlDataAdapter(connectionString); ad.DeleteCommand.CommandText=Delete................(what ever you command is); now call the update method of adapter. like ad.Update(dataSetTableName); With Regards. Enam ul haque. (Correct me if i'm wrong)