delete record from 2 tables

[wence]

INstead of this, any better way to delete record from 2 tables in a faster way?


m_con = New SQLiteConnection(ConfigurationManager.ConnectionStrings("constr").ToString)
m_con.Open()
m_sqlstate = "" : m_sqlstate = "SELECT * FROM cust_userdetails"
m_da = New SQLiteDataAdapter(m_sqlstate, m_con)
m_cmdbuilder = New SQLiteCommandBuilder(m_da)
m_ds = New DataSet
m_da.Fill(m_ds)
m_ds.Tables(0).PrimaryKey = New DataColumn() {m_ds.Tables(0).Columns("member_id")}
m_dr = m_ds.Tables(0).Rows.Find(m_memberid)
If m_dr IsNot Nothing Then m_dr.Delete()
m_da.Update(m_ds)

m_sqlstate = "" : m_sqlstate = "SELECT * FROM cust_license"
m_da = New SQLiteDataAdapter(m_sqlstate, m_con)
m_cmdbuilder = New SQLiteCommandBuilder(m_da)
m_ds = New DataSet
m_da.Fill(m_ds)
m_ds.Tables(0).PrimaryKey = New DataColumn() {m_ds.Tables(0).Columns("member_id")}
m_ds.Tables(0).PrimaryKey = New DataColumn() {m_ds.Tables(0).Columns("member_id")}
m_dr = m_ds.Tables(0).Rows.Find(m_memberid)
If m_dr IsNot Nothing Then m_dr.Delete()
m_da.Update(m_ds)

[amrita]

You can write a stored procedure to delete all records from child table and then delete records from master table.

[mendhak]

Run an ExecuteNonQuery against the tables

DELETE FROM Tablename


(This is assuming you want to delete all records in the tables, which is what it seems like you're doing)