thanks for this. Well done.

This is super and works well. But how could this be used to just refresh the gridview but not actually submit to the database until the submit button for the page is pressed?

Thanks for this,

Have a question though, I'm trying to modify your solution so that I can pass a connectstring to it instead of having it hardcoded. Any ideas on how to do this?

This was great -- THANKS!!

One thing... I'm using a combination of BAL/DAL, and am typically binding my ObjectDataSource to methods that accept whole, populated objects, not individual parameters for each column being saved. Your code describes assigning the InputParameters right before the insertion, but this doesn't seem to work for whole objects.

I've modified your code a bit as follows, in case someone else has the same issue...

protected void GridViewMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
// handle the save button on the footer row
if (e.CommandName.ToLower() == "save")
{
LocationData newObj = new LocationData();
newObj.LocationCode =
((TextBox)GridViewMain.FooterRow.FindControl("TextBoxCode")).Text;
newObj.LocationDescription =
((TextBox)GridViewMain.FooterRow.FindControl("TextBoxDescription")).Text;
newObj.LocationIsActive =
((CheckBox)GridViewMain.FooterRow.FindControl("CheckBoxIsActive")).Text;

try
{
newObj.InsertLocationData(newObj);
}
catch(System.Data.SqlClient.SqlException se)
{
// perhaps primary key violation?, display error to user

Server.ClearError();
}
catch(Exception ex)
{
throw ex;
}

GridViewMain.DataBind(); //rebind to show the insertion
}
}

{also, no longer need the ObjectDataSourceMain_Inserting() method, or references to the "Insert..." attributes on the ObjectDataSource object}