System.Data.SqlClient.SqlException: Incorrect syntax near '

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();

Hemant Kumar14y ago

Mohammed Shamsheer,

you can't write '*' for the delete Statements

string Query="delete from AU_DELETE";

Naresh Avari14y ago

Hi,

Remove '*' from your SQL Query and use

string str1 = "DELETE FROM AU_Delete";

You don't need to specify '*' for DELETE statement.