PC Review


Reply
Thread Tools Rate Thread

DataRelation in DataGrid

 
 
Patrick
Guest
Posts: n/a
 
      27th Jan 2005
Hi,

I'm using a Dataset containing two tables, e.g. Person, Customer.
Table Person has some Fields like PersonId, LastName, FirstName, Adress,
etc. My Table Customer has two fields fk_person and CustomerNo. I have
an DataRelation with these tables between field PersonId and fk_person.
Further, I have added the columns LastName and FirstName to my DataTable
Customer, which is connected to the DataRelation.
All I want to do know, is to display the Customer table with the fields
of the person table in a datagrid. When I bind this DataTable to a
dataGrid instance, I can see all the fields I want to see, but I can't
edit the fields of the person table, e.g. LastName. Now, I know that
binding to a DataRelation is somehow like binding to a dataview. But
how can I make my person tables's field writeable anyway ? Any idea, or
is it impossible to edit these fields ? Is there another way to connect
these two tables in the Dataset ? I don't want to join these two tables
in database, because I want to use the command builder functionality of
the dataadapter, which only can be used when data comes from not more of
one table.

Any tips or other ways to go ?

Thanks in advance,

Patrick
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Win2000 / Bug DataGrid with DataRelation =?Utf-8?B?Wm9yZ2x1Yg==?= Microsoft C# .NET 0 24th Apr 2006 02:49 PM
Datagrid datarelation lekhacnair@gmail.com Microsoft Dot NET 7 14th Apr 2006 12:37 AM
Datagrid -with datarelation Agnes Microsoft VB .NET 0 15th Aug 2004 02:42 PM
RE: DataRelation and populating datagrid =?Utf-8?B?UGF1bA==?= Microsoft ADO .NET 0 11th Feb 2004 08:41 PM
Re: DataRelation and populating datagrid William Ryan eMVP Microsoft ADO .NET 0 11th Feb 2004 08:33 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:52 AM.