'id'
connection = Properties.Settings.Default.cvmanagerConnectionString;
sql = "delete from apps, contacts, dept using apps join contacts, join dept where apps.FileLoc = contacts.FileLoc AND apps.FileLoc = dept.FileLoc AND apps.FileLoc = '" + id + "'"; try { SqlConnection conn = new SqlConnection(connection); SqlCommand cmd = new SqlCommand(sql, conn); conn.Open(); cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); }
using apps join contacts join dept where
JOIN
WHERE
ON
delete from apps, contacts, dept using apps join contacts on apps.FileLoc = contacts.FileLoc join dept on apps.FileLoc = dept.FileLoc where apps.FileLoc = '" + id + "'"
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)