Hi,
I have an idea to solve your problem
your table has columns like id,name,addr,phno...
And you filtered these table data into some table right.
And you can loop that dataview control after filtering .And collect that ids present in filtered data table.
Then write sql command to delete all rows which are present in that array
string strrono="";
for(int i=0;i<dataview.items.count;i++)>
{
if(strrno.Length>0)
{
strrno+=","+dataview.rows[i][0].tosting();
}
else
{
strrno+=dataview.rows[i][0].tosting();
}
}
string query="delete from tablename where id in("+strrno+")";
I hope you got an idea how to do that
All the Best