Thank to you all guys,

Maybe i must install latest service pack first (i using sql server 2005)

for temporary i used this command:

CAST

(year

It's working when run from stor procedure by try this one:

right click on the table and choise open table

put the code and run.....????  or create dataadapter on c# put the...

Thank's to you all, especially to Peter Larsson (journeyMan) and DavidsBurrows (SSC Ommited), it's work and base on that i make my own style too, which make me understood more...

Thank for your advice wayne

Do you mean, i must change this code:

// Insert parent new record

         myAtomCmd.CommandText = string.Format("insert into TESTPARENT (customer) values...