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)