Onrowcreated

Hi,
Is there one working example for the captioned event for one gridview as I'm with the following error using the event below.
Stackoverflowexception

        protected void gv_ins(object sender, GridViewRowEventArgs e)
        {
            gv1.DataBind();
        }

I do expect to be able to create one new record there

Re: Onrowcreated

hi,

why are calling gv1.DataBind(); in row_created event, i think it will end up indefinite recurisve calling of the row_created event,

i.e in row_created event you are calling gv1.DataBind(); that means it will repeatedly call the row_created event without end

Re: Onrowcreated

Hi,
Seems like your code runs numerous times, and the stack keeps filling up since you are not releasing the resources.

Since your are creating row in one fo the gridview event, can you tell me on which event you are inserting record.

I guess following event gets called numerous times..

protected void gv_ins(object sender, GridViewRowEventArgs e)
        {
            gv1.DataBind();
        }

Re: Onrowcreated

Thanks. After I've changed the event to be this, I'm still with the following error
        protected void gv_ins(object sender, GridViewRowEventArgs e)
        {
            int tot = gv1.Rows.Count;
            for (int r = 0; r < tot; r++)
            {
                if (gv1.DataKeys[r].Values[1].ToString() == "")
                {
                    gv1.EditIndex = r;
                    break;
                }
            }
        }

Argumentoutofrangeexception was unhandled by user code

Re: Onrowcreated

Hi,

Do you have 2 DataKeyNames?

If you only have ONE DataKeyName, then it should be gv1.DataKeys[r].Values[0].ToString()

Index always start from Zero.

Seem like you are trying to do Insert using GridView.

I would suggest place the new inserted row at first row.

Hope it help

Re: Onrowcreated

to access datakey value can you try like below

this

.grvManualSchedule.DataKeys[index]["DMPS_FD_Code"].ToString();

and also check the highlighted index

gv1.DataKeys[r].Values[1].ToString()

Re: Onrowcreated

Sorry for that I've posted something wrongly.

Here is the event
        protected void gv_ins(object sender, GridViewRowEventArgs e)
        {
            int tot = gv1.Rows.Count;
            for (int r = 0; r < tot; r++)
            {
                if (gv1.DataKeys[r].Values[0].ToString() == "")
                {
                    gv1.EditIndex = r;
                    break;
                }
            }
        }

but I'm with this error for line in bold above
Argumentoutofrangeexception was unhandled by user code

Re: Onrowcreated

Any advice?

Re: Onrowcreated

Hi,

Do you set your GridView's DataKeyNames property?

Re: Onrowcreated

Thanks. How to set that?

Re: Onrowcreated

Hi,

Sample code:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="au_id" DataSourceID="SqlDataSource1">

If you have composite key columns, you can set which comma, like DataKeyNames="au_id, book_id"

Hope it help

Re: Onrowcreated

Many thanks. I've put this shown below and the key name is based on the item also shown below but I've got the following error (in italic)
DataKeyNames="itm_start_dt"

    <asp:TemplateField HeaderText="Start Date" HeaderStyle-HorizontalAlign="Left" >
    <ItemTemplate>
    <asp:TextBox runat="server" ID="itm_start_dt" HtmlEncode="False" ForeColor="DarkBlue" BackColor="AntiqueWhite" BorderStyle="None"
    ReadOnly="true" Width="65px" Text='<%# Eval("start_dt") %>'/>
    </ItemTemplate>
    <EditItemTemplate>
    <asp:TextBox runat="server" ID="edi_start_dt" HtmlEncode="False"
    Enabled="true" Width="65px" Text='<%# Eval("start_dt") %>' />
    </EditItemTemplate>
    </asp:TemplateField>

Server Error in '/' Application.
--------------------------------------------------------------------------------

DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'chk_start_dt2'.

Re: Onrowcreated

Hi,

From the error message, looks like you are trying to bind the datasource of column named chk_start_dt2 which does not exists.

Please check your SQL and also control that bind to chk_start_dt2.

Re: Onrowcreated

Many thanks. I used one existing column name from that Selectcommand and now there're no problem. But the issue is nothing will happen when I click the 'New' button which is with this event
        protected void gv_ins(object sender, GridViewRowEventArgs e)
        {
            int tot = gv1.Rows.Count;
            for (int r = 0; r < tot; r++)
            {
                if (gv1.DataKeys[r].Values[0].ToString() == "")
                {
                    gv1.EditIndex = r;
                    break;
                }
            }
        }

Re: Onrowcreated

Hi,

When you debug, will it step into gv.EditIndex = r; ?

So far I know, GridView has no Insert command built on it.

I think you should use RowCommand event handler to handle your custom Insert command.

Not sure link below is what you look for
http://www.aspdotnetfaq.com/Faq/How-to-insert-row-in-GridView-with-SqlDataSource.aspx

Hope it help

Re: Onrowcreated

Many thanks. I did click the 'New' button of the gridview to insert one new record. How to use rowcommand event handler to handle the custom insert command?

Re: Onrowcreated

Hi,

I cut some code from the link I posted previously

protected void Customers_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "InsertNew")
        {
            TextBox FirstName = Customers.FooterRow.FindControl("InsertFirstName") as TextBox;
            TextBox LastName = Customers.FooterRow.FindControl("InsertLastName") as TextBox;


            SqlParameter fName = new SqlParameter("@FirstName", SqlDbType.VarChar, 30);
            fName.Direction = ParameterDirection.Input;
            fName.Value = FirstName.Text;
            insertParameters.Add(fName);


            SqlParameter lName = new SqlParameter("@LastName", SqlDbType.VarChar, 30);
            lName.Direction = ParameterDirection.Input;
            lName.Value = LastName.Text;
           insertParameters.Add(lName);
            CustomersSqlDataSource.Insert();
        }
    }

Take note on e.CommandName == "InsertNew". The CommandName is what you set for the button.
E.g.
<asp:Button Id="btnNew" runat="server" CommandName="InsertNew" />

Hope it help.

Re: Onrowcreated

Many thanks Kpyap. I have changed the event to be
        protected void gv_ins(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "InsertNew")
                ds_rec_det.Insert();
        }

where ds_rec_det is the data source name of the gridview

I've also removed this in the Markup
Onrowcreated="gv_ins"

but nothing will happen when I've clicked the 'New' button of the gridview

Re: Onrowcreated

Hi,

When debug, is the event handler been executed?

Has you bind the event?
E.g.
<asp:gridview id="gv" datasourceid="ds_rec" onrowcommand="gv_ins" runat="server">

Hope it help.

Re: Onrowcreated

Many many thanks. Yes, I've put this

OnRowCommand="gv_ins"

The event was fired but the condition can't be satisfied
if (e.CommandName == "InsertNew")