Thanx :)

You should convert your image to raw format or binary format then you can save it in table. If you can think then I Can.

Saving the image in your database isn't recommended. It will only make the database grow fast. Better way would be to save the path to the image. If you have a multi-user environment (with network) you'll best copy the image to a network share and save the network share path in the database. Be sure to use the correct name of the network share, so: '\\servername\sharename\...' and NOT 'Z:\' In the last case Z: is a network drive pointing to: '\\servername\sharename\' If you use that ALL your users need to have the same Z: pointing tot the sharename and it can never change, so using the full path (\\servername\sharenama\...') is safer. If you would still like to actually store the image in the database, google gives you plenty of help: goolge your friend[^]

As Dave said, either convert it yourself (lots of means available) or just add a reference to it in your code and use it. You might have read "interoperability" as advantages of .Net framework, you can make use of that now. 50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

you can use 1> DTS Export/Import utility for that please go thru http://support.microsoft.com/kb/319951[^] 2>exec master..xp_cmdshell but for that you need to enable from surface area configuration 3> BCP utility 4> you can use linked server for excel file to sql table. INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=\\servername\e$\inetpub\wwwroot\game\myexcelfile.xls;', 'SELECT * FROM [scores]') select * from LinkedServerName.DBname.tbl_Stats 5> SSIS package to transfer data from a table in a SQL Server 2005 database to a Microsoft Excel spreadsheet Reasons are not Important but Results are Important. Swati Tripathi

You probably won't get a response to your question here. Your bestter bet would be to ask in a forum dedicated to XtraReport, like the forums at DevExpress[^]. You know, the people who actually wrote XtraReport... A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008 But no longer in 2009...

you can use datediff also but timespan is better option depends on the your desired results try to look at cheat sheets also just for a quick reference , u can also Google cheat sheets here is one of the reference http://www.addedbytes.com/cheat-sheets/sql-server-cheat-sheet[^] T = DateDiff("n", (T1), (T2)) T = TimeSpan.Compare(t1, t2) Best Of Regards, SOFTDEV Sad like books with torn pages, sad like unfinished stories ...

Have you searched the CodeProject articles? Here[^] is a popular one; I haven't used it myself, but I have seen many people referring to it. :) Luc Pattyn :badger: :jig: :badger: Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you. :jig: :badger: :jig:

Permission granted! Or did you have a question about a problem you were having?? A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008 But no longer in 2009...

If you bought a charting package, read the docs or ask them for help Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Tell me you are NOT saving your dates as strings (varchar()). A date should be saved as a DATETIME datatype, NEVER, EVER, EVER use text datatypes to save your dates. If you store your date as Datetime then the format you DISPLAY the data is up to you, look at the datetime type. Never underestimate the power of human stupidity RAH

Hi, You Can try This.... http://www.vbforums.com/showthread.php?t=538427[^] http://www.programmersheaven.com/mb/VBNET/217962/217962/how-to-convert-string-type-to-control-type--/[^] hope this helps Anoop Brijmohun