HELP!!!Question on Chap18 Database update

halifaxdal · May 8th, 2004, 09:37 PM

Hi all, a question from a new starter:

I import the northwind database, but how to import the prime key and foreign key? 'cause I couldn't get a relationship graph like Fig18-10.

I also couldn't update the database, error like the following:
an unprocessed "System.InvalidOperationException" occured in system.data.dll.

Other information: when transport DataRow set with revised rows, update need a valid UpdateCommandÂ¡Â£

Thanks.

melvik · May 8th, 2004, 11:15 PM

How did u import DB & from where?! I guess u selected Copy Tables instead of Copy Objects if u r talking about MS-SQL Server?!
Update error might be bc of that missing Primary-keys & Foreign-Keys.

Keep in touch.

Always:),
Hovik Melkomian.

halifaxdal · May 9th, 2004, 04:36 PM

Hi, thanks for reply.

actually I was just following the book appendix B, imported the database "nwind" exactly step by step as the book says.

Yes, I copied tables instead of object, but there is no option to copy object. (the option cannot be clicked on)

The database "nwind" is in ACCESS.

Where r u?:)

halifaxdal · May 9th, 2004, 04:44 PM

I know where r u? Tehran? Persian? I am in Canada.

Persian carpet is very famous. :D

Could you tell me how did you import the so called nwind which is used in all the example codes of the book. detailed please, I am a new starter, but I promised I am a faster starter.

halifaxdal · May 9th, 2004, 04:58 PM

Hi, melvik, I jsut found out the book what I am reading is actually another book: beginning c#,
not beginning visual c#
and the book is not shown on this website!

halifaxdal · May 9th, 2004, 05:50 PM

Crazy!!!

I tried lots of effort to find out a "Beginning Visual C#", it's same as the "Beginning C#"

:(