thanks for your rply.

Actually i am working in visual studion 2010 and SQL Express server 2008. i created my database through SQL Express server 2008.

Now i have i have a table in which i have three coulmns.

StartDate EndDate Class

and i have an another table name as "DateTabe" which has also three coulmns

Date Class Time

i want that the date selected between StartDate and EndDate is made available in 'Date' coulmn which is in DateTable with class in 'class' coulmn.

StartDateEndDateclass

10/1/1213/1/12 A

14/1/1217/1/12 B

Then these can be show as in DateTable as

Date class Time

10/1/12 A

11/1/12 A

12/1/12 A

13/1/12 A

14/1/12 B

15/1/12 B

16/1/12 B

17/1/12 B

Please explain in such way so that i can implement it in visual studio 2010.

Thanks in advance