Quick question regarding ODS and Gridview using a BLL. I have my class and function setup to add a new record to the table. I've configured the source to the method, class and everything. (all Insert parameters of the ODS were assigned in this process automatically)

Now, I can't remember for the life of me if I need to set the CommandName of the submit button to "Insert". I tried this and it's expecting me to have an InsertMethod for the GridView. Anyone know what I am doing wrong with the Gridview?

I get the following error after pressing the "submit" button which I would like to trigger the INSERT method of my BLL: TargetInvocationException was unhandled by user code: Exception has been thrown by the target of an invocation.

Thanks in advance

Write code like this in html
<asp:Button ID="btnInsert" runat="server"
                Text="Insert" CommandName="Add" />


And this in code behind

protected void GridView1_RowCommand
(object sender, GridViewCommandEventArgs e)
{
  if (e.CommandName == "Add")
  {
   string strFirstName = ((TextBox)
   GridView1.FooterRow.FindControl("txtFname")).Text;


refer this for more info and this for ObjectDataSource

I understand that. I thought the whole point of having a BLL was that the ODS could call the function written in the class and supply it the parameters. In my case, I "configured" the data source which added <insertparameters> for me automatically. Why do I still need to programmatically declare the parameters? Isn't this doubling the work?

you have to because u can't use Bind method for inserting and gridview is not actually for inserting records

I actually made a typo in the title, I meant FormView. :)

Hi AaronW1981,

AaronW1981's source code is fine. You have to validate the command name within ItemCommand method to implement insert function. In FormView, there's no direct way to call the insert method, which is different from DetailsView. Here's a sample of FormView with insert function:

http://knowlegezone.com/documents/70/ASPNET-Formview--GridView-Coltrol-Insert-Update-Paging-And-Delete/

Thanks.