Just a quick verification. Is this the correct syntax to delete a record from a dataset?
Code:Dim sqlDelete As New SqlClient.SqlCommand("DELETE FROM TIMECARDS WHERE [HOURS] = 0 AND [HOURS2] = 0 AND [HOURS3] = 0 AND [HOURS4] = 0 AND [HOURS5] = 0") cnxn.Open() sqlDelete.Connection = cnxn sqlDelete.ExecuteNonQuery() sqlDelete.Dispose() cnxn.Close() cnxn.Dispose()




Reply With Quote