Hi Experts I have a query which needs to return the second in Day, Hour, Minute, Second format. The below code works fine when its less than a day, but does not work, when the value in second is greater than a day PRINT Convert(VarChar, DateAdd(S, 86400, 0), 108) 86400 is exactly a day and it returns 00:00:00 Can someone modify it and show me the result something like this 1:00:00:00. Thanks

If you don't know the answer, then do not reply. its the best way, I just started WPF few days back, I have lot of questions. I have live projects which have to be written in WPF, I will ask forums, no one reply me like this. I help lot of peoples around me for .NET 2.0, SQL Server, Designing and other things, I never discourage any one. If you don't know, just stop replying, no one like this type of answers.

I am using Infragistics XamOutlookBar bar, my form's layout is rounded from the left and right, on the left I placed that Outlook bar control and on the right I placed Infragistics XamDockManager control. I load the forms on the right area through XamOutlookBar, since my form is in rounded shape from left and right, so please advice me how I give curve on the right for a particular control.

How do I make rounded corners for textbox, combobox and other controls

[Message Deleted]

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

Hi All I have developed an application in which I use SQL Express 2005 All of my reports in the application are linked to database via instance name [MachineName]\OPMS Now I want his SQL Express 2005, so that while deployment of the application, SQL Express 2005 create an instance name "OPMS" instead of SQLExpress which is infact default instance name. Can any one please help me because I am in trouble Regards Muhammad Sharjeel Ahsan