[RESOLVED] ERR: DELETE record syntax in C#

[dr_aybyd]

What is missing with my codes?
It doesn't execute delete record.
It takes no effect when execute.

        {
            con = new SqlConnection();
            con.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\MyRecords\\pData.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
            con.Open();
            string sql = "DELETE * FROM tblClients WHERE surName='Yong'";
            da = new SqlDataAdapter(sql, con);
            con.Close();
        }

I want to delete specific record from my database.
And also Edit record by using Primary Key. Without using Dataset.

[dr_aybyd]

Woaa... I got it now...
After reading some manuals on SQL commands
Here is my working codes.

            con = new SqlConnection();
            con.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\MyRecords \\pData.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
            SqlCommand nonqueryCommand = con.CreateCommand();
            con.Open();
            nonqueryCommand.CommandText = "DELETE FROM tblClients WHERE surName='Yong'";
            nonqueryCommand.ExecuteNonQuery();
            con.Close();