But there is no direct way to get the date in the desired format Regards Aman Bhullar www.arlivesupport.com[^]

hey guys , just passed final exam of mcse 2003 and Iam now MCSE 2003 Certified . went through months of studies , used certarea.com exams , MOC books . certarea.com questions were right on money . Even though they do not provide real exam questions , their questions are harder then real exams , so it makes it easy to understand concepts . now am looking forward to moving to cisco track

You may, for instance, use the the escape sequence \xhhhh in the control definition (inside the rc script), e.g. LTEXT L"Omega: \x03A9",IDC_STATIC,10,96,300,8 :) If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile. This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke [My articles]

Hi, I really cannot understand your requirement. What you are trying to achieve, is not at all clear in the statement presented here. I fully agree with Abhishek. However, if you invoke the statement "update tale1 set substring(orderno,6,2) = 'tt'" you will get the following error "Msg 102, Level 15, State 1, Line 1 Incorrect syntax near ','." Now, I have a table say tblOrder with the following records. OrderNo 123456789 234567891 345678912 45678123 67 78 89 My goal is to update those orderno's that will satisfy the condition substring(orderno,6,2). Means, if the order no is 987623456 , then substring('987623456',6,2) will yield me 34. So if any OrderNo 34 is present, that will be updated. The query is update tblOrder set OrderNo = 'tt' where OrderNo in( select substring(OrderNo,6,2) from tblOrder) The output is OrderNo 123456789 234567891 345678912 45678123 tt tt tt Hope this helps :) Niladri Biswas

try this... if((bool)ugrRow.Cells["Add to device "].Value || (bool)ugrRow.Cells["Disgard"].Value) { //Perform Logic Here } Life goes very fast. Tomorrow, today is already yesterday.

Hi, Do you have any backup files of your database? Don't know if your recycle bin contains a copy of the old file (does this work when replacing files?). Regards Sebastian It's not a bug, it's a feature! Check out my CodeProject article Permission-by-aspect. Me in Softwareland.

I gave an indication of how to do this in my reply here[^]. "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

ghumman63 wrote: it means i will have to create some other classes for handling this scenario , is not that extra coding ? Yes. Alternatively, you return the full data and then pull out the subset you need - the choice is yours. "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

thanks, i actually have done like the link u sent , but i am looking that if there is any linq native case syntex. Tauseef A Khan MCP Dotnet framework 2.0.

When the Linq classes are generated, they are in separate classes - the issue you have is that they are in one file. Fortunately, these classes are partial classes so you can place your custom implication in a separate file, as just another part of the partial class. "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

you can't predict...you catch.

I would use and else to trap the 2, -2 values Never underestimate the power of human stupidity RAH

If there is primarykey-foreign key relation in tables u hv to insert primarykey tables first after that u can insert in foreign key tables means in child tables. Thanks and Regards Sujit Kr. Mandal

yes , it is , but there are no primary keys in that particular table , can that be an issue? Tauseef A Khan MCP Dotnet framework 2.0.

If you're getting junk characters when you're supposed to be getting nice looking text, you've most likely got the communication parameters wrong, like baud rate, stop bits, data bits, parity, handshaking, yada, yada, yada, ... A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

You are welcome. I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.

Hi, I have started integrating the Hitachi 902 Automatic Analayzer. i think u have allready completed the interfacing can u help me in doing that? Thanks Bala