Comments by shukla dhaval (Top 7 by date)

Give details about third party control first. You can make try with creating relationship in you data set and test with that.

Can you just provide some more details about your scenario? If you can provide information that where you store your file in your database or on hard drive, are you store information that particular file is encrypted etc etc.

If you provide this kind of information my be i can share something with you.

You don't need to change database field type at all. You just need to convert your nvarchar data into datetime format.

For Example. Select BirthDate from Table1 returns '20091002'
Now when you want to convert that nvarchar result into datetime then you need to change it like

Select Convert(datetime,left(birthdate,8)) from table1 it gives you result like 2009-10-02 (2nd -Oct -2009)

I hope it solve your issue.

Yes it's sql server.