0
When You are deleting records,
You can write query as
delete table AU_Delete
or
delete from table au_Delete.
you have to use * only in select queries.
try this
SqlConnection con = new SqlConnection("Data Source=APPLE;Initial Catalog=sam;Integrated Security=True");
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
con.Open();
string str1 = "DELETE AU_Delete";
cmd.CommandText = str1;
cmd.ExecuteNonQuery();
con.Close();
0
Mohammed Shamsheer,
you can't write '*' for the delete Statements
string Query="delete from AU_DELETE";
0
Hi,
Remove '*' from your SQL Query and use
string str1 = "DELETE FROM AU_Delete";
You don't need to specify '*' for DELETE statement.