deleting a row from a mssql database
how do i do this in asp.net? i am quite new to SQL programming so i dont really know how to do it...in C# i've tried this just for testing purposes..:
Code:
SqlConnection connection = new SqlConnection(CONNECTION_STRING);
connection.Open();
SqlCommand command = connection.CreateCommand();
command.CommandText = "DELETE * FROM DailyDev";
int res = command.ExecuteNonQuery();
connection.Close();
but i am gettin a "System Error"
what am i doing wrong? also how is the fastest way to access the database and delete the records..i am doing in a way its too slower?
feedback appreciated!