How to delete data by date range

Am having a problem in my c sharp application. I want to delete data inside database (am using MSSQL server 2012) between two selected date. But my propblem is, after I click on delete button messageBox shows deleted successfully but when I view the data inside database I still see them which means the data is not deleted. please I need someone to help me. this is my code so far.

string query = "DELETE FROM TABLE_SALES WHERE DATE >= '" + DateTimee.Value.Date.ToString() + "' AND DATE <= '" + DateTimee2.Value.Date.ToString() + "'";

dt = new DataTable();

sda = new SqlDataAdapter(query, con);

sda.Fill(dt);

dataGridView1.DataSource = dt;

con.Close();

MessageBox.Show("SALES DELETED SUCCESSFULLY", "MESSAGE", MessageBoxButtons.OK, MessageBoxIcon.Information);

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Saravanan Ponnusamy9y ago
Accepted answer
try this..

SqlCommand Cmd = new SqlCommand ( Query, Con )
Cmd.ExecuteNonQuery ()
Catcher Wong9y ago
@Hezekiah

You should use the ExecuteNonQuery method to execute your delete sql !!