Hello Easwar,
I have a solution for you. Just try it out. It may be helpful to you. I hope you don't have any problems with loading tables from database to datagrid. After loading table to datagrid, for example, consider you have loaded employee table from database to your datagrid, after that, you can proceed with editing in datagrid, you can do whatever opration you want to do, and use the following function to save your updated, deleted, newly inserted data to database.
Hope you are using SqlDataAdapter to get table from database. Use this in save function.
SqlCommandBuilder objBuilder = new SqlCommandBuilder(objSqlDataAdapter);
objBuilder.GetInsertCommand();
objBuilder.GetDeleteCommand();
objBuilder.GetUpdateCommand();
objAdap.Update(objTable);
Above code takes care of insert, update, delete operations, you don't need to write code for these operations. And make sure that you have one key column(Primary key) in each table in your database, beacuse which will act as reference key column when Delete operation occurs.