Intersoft Community - WebGrid Enterprise - Multiple Datakey fields

Multiple Datakey fields

yudi — Wed, 29 Jul 2015 07:56:38 GMT

Sorry for the delay in sending this.

I modified BatchUpdateGuidProblem sample so it now works with batch update feature (insert, update, and delete transactions).

For more detail, please take a look OnBatchUpdate server-side event in BatchUpdateGuidProblem.aspx.cs file.

Please let me know whether this helps or not.

Multiple Datakey fields

zhuhm — Tue, 28 Jul 2015 09:17:02 GMT

Hello，Arief Handany

The Attachment is my video, please have a look about it . Thank you very much!

Multiple Datakey fields

Arief — Fri, 10 Jul 2015 06:46:55 GMT

Hi Zhu hm,

Your video is broken can you resend the video/ screenshot for the error?

Best Regards,
Arief

Multiple Datakey fields

zhuhm — Mon, 29 Jun 2015 01:13:00 GMT

Hi, Could you please help me solve the above problem? Thank you very much!

Multiple Datakey fields

zhuhm — Mon, 08 Jun 2015 03:07:28 GMT

Hello,Yudi

I ran your sample, when I add the first record, it ran normal, but when I add the second recode, it cause wrong. The attachment is my video about operation. Please have a look, and tell me why? Thank you very much!

Multiple Datakey fields

yudi — Mon, 08 Jun 2015 02:09:57 GMT

I enclosed my sample as attachment. Please have the sample evaluated on your end and let me know the result.

Multiple Datakey fields

zhuhm — Fri, 05 Jun 2015 11:09:15 GMT

Could you please provide me your sample? Thank you very much!

Multiple Datakey fields

yudi — Fri, 05 Jun 2015 08:35:25 GMT

I created a simple sample of WebGrid with the following detail:

WebGrid is bound to Tests table of DummyDb database.
Tests table has 5 columns: TestID1; TestID2; TestName; TestDescription; and TestNote.
TestID1 and TestID2 columns are primary key. The ColumnTypes are Guid.
The other columns are text.
Batch-update is enabled in WebGrid.

I use Multi primary key column, and enable batch update , it occurs the problem as above.I found this problem have not been solved at Intersoft Premier Studio 2014 R1 SP1...

I was able to reproduce the above problem, The pending changes already contain a record with key '', when adding two records.

Could you please confirm whether you have similar scenario to my sample or not? If you have any additional information to add to this case, please feel free to let me know. I can provide my simple sample to be evaluated on your end if necessary.

Look forward to hearing back from you.

Multiple Datakey fields

zhuhm — Thu, 04 Jun 2015 03:16:12 GMT

My test show WebGrid does have issue when adding new row with guid column key using BatchUpdate, However the issue is the key value of the guid is clipped so it will only get a few character of the guid not the whole guid. A bug report has been submitted to the developer.

I use Multi primary key column, and enable batch update , it occurs the problem as above.I found this problem have not been solved at Intersoft Premier Studio 2014 R1 SP1,could you tell me the time when you would solved this problem?

Multiple Datakey fields

Glayaar — Tue, 01 Sep 2009 05:12:43 GMT

Did you handle your own delete and edit method using DeleteRow and UpdateRow server side method?

If you are not using strongly typed dataset to bind data to WebGrid, you will need to set some property to the datatable, such as primary key, allownull to pass the schema to the WebGrid .

Multiple Datakey fields

Michael — Tue, 25 Aug 2009 15:39:45 GMT

I found following text in WhitePaper:

It’s important to note that WebGrid requires your tables to have at least one unique key field, which is assigned to DataKeyField property of each WebGridTable property of each WebGridTable instance. Multiple key fields’ scenario is also supported.

How can I use multiple key field?

Regards

Michael