iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
Hi
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?
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>
<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.
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname