Have an Update/Insert button. In the click event, loop through the datagrid items. Pull each value you need and construct an Insert statement. Then execute the sql statement for each pass of the loop.
Are you using 2.0 or 1.1? The gridview can be made updatable. You can use SqlDataSource.Update()