Intersoft Community - WebGrid Enterprise - How to get auto-increment column value back into webgrid after insert?

How to get auto-increment column value back into webgrid after insert?

bernard — Tue, 16 Oct 2012 21:58:56 GMT

Hi TJ,

I think you must handle the select and insert method besides adding ref value on your parameter. I've search for the sample of KB. In that sample, you can find dsNorthwind.cs that describe you how to handle identity value. I attach the sample here. Please let me know if there's misconfiguration in that sample. Hope this helps.

Regards,
Bernard

How to get auto-increment column value back into webgrid after insert?

throstur62 — Tue, 16 Oct 2012 05:08:15 GMT

Hi Bernard,
I read your article. Unfortunately the attached code-sample is not accessible any more. However from that article I read that the only thing I had to do was to change the first parameter of my Insert method to be a ref-value:

[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Insert, true)]
public object IsDsInsertComment(ref int idComment, string userId, int idPointGroup,....)
{
     :
     idComment = Convert.ToInt32(cmd.ExecuteScalar());
     :
     return idComment;
}

The insert to the database works fine as before, however the new value of idComment does not appear in the WebGrid. You can se the webgrid table column defination above.
Here is the ISDataSource defination:

 <ISDataSource:ISDataSourceTable 
  ConflictDetection="OverwriteChanges" 
  ParameterOption="FromFields"
  SelectMethod="IsDsGetComments" 
  UpdateMethod="IsDsUpdateComment" 
  InsertMethod="IsDsInsertComment" 
  DeleteMethod="IsDsDeleteComment" 
  TableName="tblComments" 
  TypeName="C2Net.Common.Lbo.LboComment"
  OldValuesParameterFormatString="original_{0}">
  <SelectParameters>
	<asp:Parameter Name="idPointGroup" Type="Int32" DefaultValue="-1" />
	<asp:Parameter Name="idBuilding" Type="Int32" DefaultValue = "-1"/>
	<asp:Parameter Name="idOpcGroup" Type="Int32" DefaultValue="-1" />
	<asp:Parameter Name="from" Type="DateTime" />
	<asp:Parameter Name="to" Type="DateTime" />
  </SelectParameters>
</ISDataSource:ISDataSourceTable>

Regards
TJ

How to get auto-increment column value back into webgrid after insert?

bernard — Mon, 15 Oct 2012 22:28:50 GMT

Hi TJ,

Could I look for your selecting method in ISDataSource? You must handle selection and insertion method if you have identity column in you database. This Knowledge Base maybe will help you to handle retrieving identity value:

http://www.intersoftpt.com/Support/WebGrid/KB/Retrieving-Identity-(Auto-generated-values)-during-Insert-operation-in-WebGrid-Hierarchical-Load-on-Demand-Scenario-using-ISDataSource-NET/

Hope this helps.

Regards,
Bernard

How to get auto-increment column value back into webgrid after insert?

throstur62 — Mon, 15 Oct 2012 06:24:31 GMT

Hi,

WebUI Studio 2009 R2

I have a webgrid bound to a ISDataSource (ISD). The ISD has SchemaType="CustomObject" and InsertMethod="InsertComment". That inserts into a database table called "commnts" with it's primary key as id_comment as autoincrement.

The InsertComment method calls a Stored Procedure in the database that inserts a comment record and returnes the newly inserted id_comment.

Now I have to somehow get that returned id_comment into the new webgrid row. So I tried setting the oninserted="ISDataSource1_Inserted" for the ISD:

 protected void ISDataSource1_Inserted(object sender,
                                       ISNet.WebUI.DataSource.ISDataSourceStatusEventArgs e)
{

   c_webGrid.RootTable.UpdateRowIdentity("idComment", "-1", e.ReturnValue);
}

I notice that "e.ReturnValue" is returning the correct newly inserted id_comment, but this call does unfortunately not update the column of the new row in the grid.
I have also tried using the "DataMember" instead:

c_webGrid.RootTable.UpdateRowIdentity("id_comment", "-1", e.ReturnValue);

But that does not help either.

Where can I put in the returned auto-increment id_comment to the web grid column of the newly inserted row, after insert?

If it helps the SelectMethod of the ISD returns a DataTable from the custom object, one of the columns of the DataTable is id_comment and I have tried to play with all that stuff:

var c = tbl.Columns.Add(Consts.Columns.IdComment, typeof (int));
/*c.AutoIncrement = true;
c.AutoIncrementSeed = 0;
c.AutoIncrementStep = 1;
c.AllowDBNull = false;*/
c.Unique = true;
DataColumn[] pk = new DataColumn[1];
pk[0] = c;
tbl.PrimaryKey = pk;

But it did not help.

In the webgrid I specify:

<RootTable Caption="tblComments" DataKeyField="id_comment">                         
  <Columns>
    <ISWebGrid:WebGridColumn Caption="ID" 
     DataMember="id_comment" 
     DataType="System.Int32" 
     Name="idComment" 
     EditType="NoEdit" 
     IsAutoIncrement="true" 
     Visible="true" >
     <HeaderStyle HorizontalAlign="Center" />
     <CellStyle HorizontalAlign="Right" />
   </ISWebGrid:WebGridColumn>
   ...

Regards