Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > .NET General

Vista - Cannnot add new record to a datatable after sorting

Reply
 
Old 08-17-2009   #1 (permalink)
Young


 
 

Cannnot add new record to a datatable after sorting

I got a table with just 1 primary key (a short integer field).

If I sort the datatable, I cannot add a new record anymore. I keep getting
an error saying that the record is a duplicate (the primary key is unique
and definitely not a duplicate).

If I don't sort the datatable, then I can add without any problem.

I sort the datatable using these codes:

myTable.DefaultView.Sort = "MYKEY"
myTable = myTable.DefaultView.ToTable.

Can someone please help?

TIA
YL




My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
How to extract data from a Datatable into another DataTable or dat .NET General
Cannnot copy iso files over my network Vista file management
Can't record stereo mix, and it isn't disabled... can't record line either? Vista General
How to fix A DataTable named 'Tag2' already belongs to this DataSet.(XML/Datatable) .NET General
cannnot delete a message in my out box Vista mail


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46