Intersoft Community - WebGrid Enterprise - WebGrid: Can you have more than one DataKeyField?

WebGrid: Can you have more than one DataKeyField?

andi@intersoftpt.com — Tue, 02 Mar 2010 23:38:12 GMT

Hi Rob,

I am a bit confused on "Primary key with multiple column". Does it mean that you have more than one of Primary Key? I believe in every table of multiple columns must be have one PrimaryKey.

Here, I attached you a sample with Northwind database, I leave the DataKeyField blank as well and it runs just fine. I hope it helps. Thank you and have a nice day.

Best Regards,

Andi Santoso

WebGrid: Can you have more than one DataKeyField?

rdelloro — Tue, 02 Mar 2010 11:57:19 GMT

Hi all,

If I leave DataKeyField Blank and i define a in the dataset a Primary key with multiple colum, Webgrid not recognized automatically the perimary key.

How can I solve this issue?

thanks

WebGrid: Can you have more than one DataKeyField?

julia — Tue, 15 Dec 2009 21:45:42 GMT

Hi Jocelyn,

As Andi said, if you have another PrimaryKey, you don't have to write it in DataKeyField. You just need to define the key in DataSet and WebGrid will be recognized automatically.

Regards,

Julia

WebGrid: Can you have more than one DataKeyField?

jcrendulic — Tue, 15 Dec 2009 17:35:50 GMT

I am not sure how to do this? We are binding to the Grid from a Dataset in the code behind page. What property would be set? I do not see ForeignKey as a property in the <RootTable >.

WebGrid: Can you have more than one DataKeyField?

andi@intersoftpt.com — Thu, 10 Dec 2009 22:55:27 GMT

Hi Joycelyn,

Actually DataKeyField is based on your Primary Key on database. You can add another key, but it will be stated as a ForeignKey. In DataKeyField, you just need to leave it blank, by default, it will be configured by it self.
I hope it helps and please do not hesitate to ask if you have any other questions.

Thank you,
Andi Santoso

WebGrid: Can you have more than one DataKeyField?

jcrendulic — Thu, 10 Dec 2009 17:07:24 GMT

Can you specify more than 1 DataKeyField in the RootTable tag? I need to key off 2 values for this grid to make it unique.