Intersoft Community - WebGrid Enterprise - bind two keys to webgrid

bind two keys to webgrid

handy@intersoftpt.com — Wed, 26 Jan 2011 05:31:57 GMT

Hello,

Unfortunately, I could not downgrade sql in here. You can try to create a simple dummy database such as the structure and run it. It does not cost big effort since it is only a simple table.

Regards,
Handy

bind two keys to webgrid

qq397472251 — Wed, 26 Jan 2011 03:41:17 GMT

I am sorry ,I can not use your database.Could you please give a sql2000(or sql2005) database.
Please see the picture!

My sql is:sql2005

bind two keys to webgrid

handy@intersoftpt.com — Tue, 25 Jan 2011 22:05:16 GMT

Hello,

It should be no problem when have 2 primary keys in your table. When bind with 2 primary keys/composite keys, WebGrid would automatically detect it. You would not need to specify DataKeyField properties.
Please see my attached sample. It should work fine. For Add,Update and Delete scenario, you should use Optimistic Concurency in your SQLDataSource.

Regards,
Handy

bind two keys to webgrid

yudi — Mon, 24 Jan 2011 11:57:09 GMT

In order to support multiple-key field scenario you don’t need to set the DataKeyField property in the WebGrid table. A sample, HierarchicalGrid.aspx, in WebGridSamples project shows that the OrderDetails table has multiple-key – OrderID and ProductID –, so in the OrderDetails WebGrid definition no DataKeyField property is assigned.

<ISWebGrid:WebGridTable Caption="Order Details" DataMember="Order Details">

On the other hand, the Order table which has the primary key OrderID will have to be assigned the DataKeyField property.

<ISWebGrid:WebGridTable Caption="Orders" DataKeyField="OrderID" DataMember="Orders">

This should helps.

bind two keys to webgrid

qq397472251 — Mon, 24 Jan 2011 10:30:02 GMT

If I have a table "login",its primary keys are column "Id" and column "Name",How can I bind the table "login" to webgrid( it must Use add,update,delete by grid's way ).How ever the grid's datakeyfield can not to fill with "Id, Name".
Please see the picture below!

what shoud I do?Anyone can Help me?