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}

This is exactly what I'm looking for, but I'm using ASP.NET-VB, so I have a problem when placing LocationData.cs & SqlData.ca in the App_Code folder. I tried creating an App_LocalResources folder within the "time" folder where I'm testing this -> my plan is to use the grid for an online timesheet.

Any suggestions on how I can alter the setup to use your solution? I'm afraid I don't yet know enough to debug myself.

Thanks.

Janice

I am also looking for this handling for a long time. But I am using ASP.NET -VB and datasource is SQLDatatsource. Can I stick with SQLDatabase, not changing to ObjectDataSource. It is great that if
you can create another version using SQLDataSource and VB.NET

Thanks in advance

Simon