I have datagridview filled from database through datadapter. The problem is that I cant use generated Fill, Update and Delete commands since in my SELECT query there are two joined tables. I need some direction how to achieve this. I will like to update changes in CellEndEdit procedure. Should I fill datagridview with two SELECT statements without joined tables? Or is there some simplest way to do it?