How to AutoIncrement ID if adding new Row in WebGrid

Hans — Thu, 18 Oct 2012 23:07:31 GMT

Hello,

I made a simple WebGrid sample based on your information.

I bind WebGrid to access data source (Northwind.mdb database and Shippers table).

On ShipperID column, I set Visible property to False and IsAutoIncrement property to True.

And I can reproduce your issue as well.

To resolve this issue please try to modify InsertCommand and InserParameters of you DataSource control.

In my sample, I modify InsertCommand from:

InsertCommand="INSERT INTO [Shippers] ([ShipperID], [CompanyName], [Phone]) VALUES (?, ?, ?)"

To:

InsertCommand="INSERT INTO [Shippers] ([CompanyName], [Phone]) VALUES (?, ?)"

I also modify InsertParameters from:

<InsertParameters>
	<asp:Parameter Name="ShipperID" Type="Int32" />
        <asp:Parameter Name="CompanyName" Type="String" />
        <asp:Parameter Name="Phone" Type="String" />
</InsertParameters>

To:

<InsertParameters>
	<asp:Parameter Name="CompanyName" Type="String" />
        <asp:Parameter Name="Phone" Type="String" />
</InsertParameters>

If the issue still persists, could you modify my sample so that I replicate your issue on my sample?

So I can help you to investigate the issue further more.

Thank you.

Regards,

Hans.

How to AutoIncrement ID if adding new Row in WebGrid

sobikash11@googlemail.com — Thu, 18 Oct 2012 03:23:22 GMT

i have created a Webgrid with three Columns:

ID Place Name

I setted the ID Column to visible = "false", IsAutoincrement = "true". Iam working with a Oracle Database. In the Database i added Trigger for the Autoincrement of the ID.

My Problem is that if i try to add a Row in the WebGrid i getting a Error:

"ID" column does not allow nulls

but if i add a Row directly in the Database it works.

Why does the WebGrid do not an AutoIncrement?

Intersoft Community - WebGrid Enterprise - How to AutoIncrement ID if adding new Row in WebGrid

How to AutoIncrement ID if adding new Row in WebGrid

How to AutoIncrement ID if adding new Row in WebGrid