A program cannot behave like this….Better you review your code. You can also post your code snippets for getting better suggestions from the forum. Thanks Md. Marufuzzaman Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you. I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

I think these might help: Persian Calendar [^] Persian Calendar Members[^] The references refer to a type that is specifically designed for handling Persian dates as the month lengths are incompatable with Gregorian dates (ie xxxx/02/31 is valid). You will most probably need to convert to a standard DateTime (there is a ToDateTime method) when saving to database, otherwise you are in for a world of pain trying to get it to work. CCC solved so far: 2 (including a Hard One!) 37!?!! - Randall, Clerks

thank u both of my friends for ur answer,both of the answered gave me a pointer,but how can i relate copying data to a progress bar?

dudes i found the ways to access those fields in datareader,so my last question is solved,but iv got a new problem,and that is i have a large amount of records in my database tables,so it would take a very long time for selecting and inserting into destination table row by row.how can i do that by copying the whole table at once,and insert it at once too.i might user dataset and its datatables,but it doesn't work,can anybody give me an example of filling a datatable of a dataset from connection 1,and insert that datatable into connection 2 database? thank u.

Not possible. Kind of the whole point of a framework... Me fail English? That's unpossible!