simply use:
SqlCommandBuilder build = new SqlCommandBuilder(adapter);
for building the update query and on save record button click event write the below line:
adapter.Update(dt);
here adapter is a object of SqlDataAdapter and dt is object of DataTable. And make sure your table contains Primary key
refer this to learn more:
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommandbuilder.aspx?ppud=4[
^]
hope this helps :)
for further queries comment here!!