[RESOLVED] ERR: DELETE record syntax in C#
What is missing with my codes?
It doesn't execute delete record.
It takes no effect when execute.
Code:
{
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.
Re: ERR: DELETE record syntax in C#
Woaa... I got it now...
After reading some manuals on SQL commands
Here is my working codes.
Code:
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();