Intersoft Community - WebGrid Enterprise - Autonumber in a webgrid

Autonumber in a webgrid

Glayaar — Thu, 07 Jan 2010 21:36:07 GMT

You could try handling all the database operation manually as shown in a sample, DatabaseUpdates.aspx, in the provided WebGrid tutorial. However, you need to use the InitializeDataSource server side client to bind the data.

The DatabasesUpdates.aspx tutorial is under the V3.1 folder.

Autonumber in a webgrid

hohenbergerc — Thu, 07 Jan 2010 14:12:45 GMT

I spoke to soon. I forgot to disable my trigger and it was supplying the data. The InitializeRow event is writing the row number to the grid, but not setting the bind variable for the Insert, thus it fails with a cannot insert null.

Here is my datasource:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DHOUSE %>" ProviderName="Oracle.DataAccess.Client" SelectCommand="SELECT HARDWARE_SCHED_CODE, HARDWARE_SCHED_DESCR FROM HARDWARE_SCHEDULE2 WHERE (M2O_ID = :M2O_ID)" InsertCommand="INSERT INTO HARDWARE_SCHEDULE2(HARDWARE_SCHED_CODE, HARDWARE_SCHED_DESCR,M2O_ID) VALUES (:hardware_sched_code,:hardware_sched_descr,:M2O_ID)" <SelectParameters> <asp:SessionParameter Name="M2O_ID" SessionField="m2o_Id" DbType="Int32" /> </SelectParameters> <InsertParameters> <asp:Parameter Name="hardware_sched_code" DbType="Int32" /> <asp:Parameter Name="hardware_sched_descr" DbType="String" /> <asp:SessionParameter Name="M2O_ID" SessionField="m2o_Id" DbType="Int32" /> </InsertParameters>

</SqlDataSource>

Is there another way to accomplish this? Should my parameter name be assigned differently?

Thanks,

Conrad

Autonumber in a webgrid

Glayaar — Wed, 23 Dec 2009 21:35:04 GMT

If you wish to do it in the client side, my suggestion is to use the WebGrid initialize event handler to set the row position property of each row to the RowNumber cell. Here is the snippet for such scenario, in this case the RownNumber cell is the first column in the WebGrid:

function WebGrid1_OnInitialize() {
    var grid = ISGetObject("WebGrid1");

    var rows = grid.RootTable.GetElement(WG40.BODY, WG40.HTMLTABLE).getElementsByTagName("tr");
    
    for (var i = 0; i < rows.length; i++) {

        rows[i].getElementsByTagName("td")[1].innerText = grid.GetRowByElement(rows[i]).Position + 1;
    }
}

On the other hand, the method will be similar for server side as well, however you will need to use the InitializeRow event handler:

protected void WebGrid1_InitializeRow(object sender, ISNet.WebUI.WebGrid.RowEventArgs e)
{
    if (e.Row.Type == ISNet.WebUI.WebGrid.RowType.Record)
    {
        e.Row.Cells[0].Value = e.Row.Position + 1;
        e.Row.Cells[0].Text = (e.Row.Position + 1).ToString();
    }
}

Autonumber in a webgrid

hohenbergerc — Wed, 23 Dec 2009 09:47:38 GMT

I have a 2 column table and I need to be able to autonumber rows as they are added to the grid. I need to do this on the client-side so that the rownumbers are visible to the user. Anybody have any ingenious ways to do this?

Thanks,

Conrad