try this : DECLARE @DurationSeconds INT DECLARE @DurationDays INT SET @DurationSeconds = 62110 SET @DurationDays = @DurationSeconds /86400 Select CASE WHEN @DurationDays > 0 THEN Convert(VarChar,@DurationDays)+ ':'+ Convert(VarChar, DateAdd(S, (@DurationSeconds-(@DurationDays*86400)),0), 108) ELSE Convert(VarChar, DateAdd(S, @DurationSeconds, 0), 108) END

ahsansharjeel wrote: How do I make rounded corners for textbox, combobox and other controls They have borders, which can have a CornerRadius applied to them. "WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes. My blog | My articles | MoXAML PowerToys | Onyx

Christian has asked a fair question. What have you done so far? Before you get all shirty, you might want to consider that he has actually asked you what the starting point is? If you are just after the final couple of bits of information for an almost complete implementation, then you aren't going to want us to tell you about how to bind data into the combo box - that's a waste of your time and ours. More importantly though, there is an expectation that you have done some work for yourself so far. Code Project is predicated on the fact that you have a starting point. Nobody here has the time or inclination to tell you how to write a fairly complex control from scratch. That's what the articles are for. "WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes. My blog | My articles | MoXAML PowerToys | Onyx

The connection string is no hard coded, I have placed connection string in App.Config so that user may change that string after deployment, but the problem is that Crystal report hard code the instance name of database E.g. .\SQL2005 After deployment and during running of the application, crytal report search for that "SQL2005" So I want the SQL Express to have a user defined instance name which I first assign to All of report (under push or pull process) and then define that insance name to somewhere so that during installation of my application, tha instance name created while insallation of SQL Express, Please note that default insance name is SQLExpress but I do not need that name at all. More over, if I install SQL Express directly then it asks for instance name but while installing as a pre requisite, it create SQLExpress. Please reply asap Regards