How to add a new row in sql from datagrid and update sql row from same datagrid? -

how can add new row in sql datagrid, using textboxes in footer , update sql row same datagrid, using edit of row?

this article on codeproject nice (thorough) job of demonstrating asking. comes demo code. http://www.codeproject.com/articles/37430/datagrid-editing-updating-cancel-selecting-rows