Click here to Skip to main content
Page 1 of 7
Page Size: 10 · 25 · 50


Author filtered by: db7uk [x]
Answer 13 May 2013   license: CPOL
You need to either understand PIVOT / UNPIVOThttp://msdn.microsoft.com/en-us/library/ms177410(v=sql.105).aspx[^]orCreate two select statements and use them as derived tables. Then you can join on ID and get your output.i.e.Select a.Id, a.Time InTime, b.Time...
Answer 7 May 2013   license: CPOL
You need not look any further than Code Project. Especially articles like:WPF: A Beginner's Guide - Part 1 of n[^]WPF: A Beginner's Guide: Part 2 of n[^]WPF: A Beginner's guide: Part 3 of n[^]WPF: A Beginner's Guide - Part 4 of n[^]WPF: A Beginner's Guide - Part 5 of n[^]WPF: A...
This is good! by db7uk
Forum Message 6 May 2013  
Thanks for sharing.
Nice by db7uk
Forum Message 6 May 2013  
Good one Tim. Nothing worse than ; being missed off the ends!!!
Forum Message 6 May 2013  
Chin up. You can only do so much. At the end of the day (well week in your case), it is not going to matter one bit. I know the pain you feel and have my thoughts... There is nothing worse than workin
Answer 6 May 2013   license: CPOL
Well, Im going to put my head out there and say that it is some permissions issue no???? :)Come on, without any code this is really not a question at all..However, look at...
Answer 6 May 2013   license: CPOL
Ok, try:protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (Page.RouteData.Values["Id"] != null /*&& Page.RouteData.Values["index"] != null*/) { int id; if...
Nice by db7uk
Forum Message 3 May 2013  
I use bootstrap in a few MVC projects (because I can't design css/html for toffee). Will try this out!!! thanks 5+ :thumbsup:
Forum Message 30 Apr 2013  
Mmmmm well actually strange but I got my 920 yesterday. Personally I love the device so far, but then it is only a day old. Looking at other devices, I could not see one better. If one were to quote "
Forum Message 29 Apr 2013  
Yeah too true, too true. The financial down turn this last year or so has really made companies look at "cost saving". So all those little modules of excellence developed to help with that have kep
Answer 29 Apr 2013   license: CPOL
Nothing changes. Because your ASP.net application will have server side code, nothing really changes. What by way of authentication and knowing what the user is does your current application know what user has which role?? Surly this can easily be ported to something like the asp.net membership...
Forum Message 28 Apr 2013  
Same here. Would love to have a stab at games but it just gets left at the bottom of my "list of things to do". Normally due to my kids demanding that they want to bundle me or work demanding I creat
Forum Message 28 Apr 2013  
It would be nice to "Sleep while working". Not found a pill for that yet :-\
Answer 27 Apr 2013   license: CPOL
As Sandeep sugested. There are many examples on the web for this. however, with cursors they can be slow. There are many uses for them but the majority of instances you can use normal looks, set based queries or use RANK / DENSE_RANK functions for ordering so that you can insert / update based...
C#
Answer 27 Apr 2013   license: CPOL
You could try :annotorious[^]not used it myself but looks like it could do more than just line drawing.If not look for js libraries on image annotation.On the other hand, you could look at the HTML 5 canvas route.thanks
Answer 27 Apr 2013   license: CPOL
I encountered this problem before. I take it this is Linq to SQL? I blogged about it here:http://developwith.net/2012/07/16/unknown-return-type-linq-to-sql/[^]Let me know if it helps?
Answer 25 Apr 2013   license: CPOL
You can install SQL server express on other systems. You can install it locally. Either way you need to use a connection string to connect to the database. a good beginners example is found below:http://www.youtube.com/watch?v=wReLvTh9QY4[^]
Answer 25 Apr 2013   license: CPOL
Not sure what you are trying to do there but I would change the oracle.dataaccess.client to appSettings. Then call ConfigurationManager.AppSettings["Key of setting"]http://msdn.microsoft.com/en-us/library/system.configuration.configurationmanager.appsettings.aspx[^]
Just read this! by db7uk
Forum Message 24 Apr 2013  
very good. Hope you are well. my 5+
Answer 23 Apr 2013   license: CPOL
Have you tried AJAX based CRUD tables using ASP.NET MVC 3 and jTable jQuery plug-in[^]There are others but that is the one I have used. Problem is, it looks like Infragistics / Telerik companies do the best ones but they are pay for controls....
Very good indeed by db7uk
Forum Message 23 Apr 2013  
Excellent. I liked both your articles. We are currently considering charting and d3.js. Your article has really helped! thanks 5+
Answer 22 Apr 2013   license: CPOL
What is the :SELECT '','------------'doing in the query?
Answer 22 Apr 2013   license: CPOL
You should try using ajax to call images from controller:http://stackoverflow.com/questions/11215303/retrieve-images-from-database-through-a-jquery-ajax-call[^]simply put, use $.ajax to get your image(s) and update your page.That is what you should do but as you have not posted any...
Answer 22 Apr 2013   license: CPOL
The problem you are probably having is that when you +/- your credit or debit, one of those values could be null. If it is then the result will be null. try in your queries:SUM(ISNULL(Debit, 0) - ISNULL(Credit, 0))p.s. Try not to double post. This I answered in the newer post.
Answer 22 Apr 2013   license: CPOL
Have you tried setting the date as a formatted date?http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function%5Fstr-to-date[^]MySqlDataAdapter da = new MySqlDataAdapter("Select * from Transactions WHERE date BETWEEN STR_TO_DATE('"+datePicker1.Text +"','%d,%m,%Y') AND...
Answer 22 Apr 2013   license: CPOL
You cant do that. You need to create a subquery, temp table or CTE. Please see below:;WITH CTEAS( SELECT *, RANK() OVER (ORDER BY td.NameRss) as myrank FROM tblData td left join tblRss tr on td.NameRss=tr.RssAdress)Select *FROM CTEwhere CTE.myrank
Answer 22 Apr 2013   license: CPOL
The problem you are probably having is that when you +/- your credit or debit, one of those values could be null. If it is then the result will be null.try in your queries:SUM(ISNULL(Debit, 0) - ISNULL(Credit, 0))
Answer 18 Apr 2013   license: CPOL
take a look at : http://stackoverflow.com/questions/936304/binding-to-static-property[^]I take it this is one way binding? To bind to statics you can use the x:Static binding expression.
Forum Message 18 Apr 2013  
Excellent picture. How long did that take? who needs photoshop. :thumbsup:
Answer 18 Apr 2013   license: CPOL
ok, with ssis you are going to have to have some sort of monitor that fires an event which could then execute the ssis package.This is really not what SSIS is designed for.What you really need to do is create a windows service. In this service I would recommend you implement the...
Forum Message 18 Apr 2013  
ha, and then send all the crims there too...
Forum Message 18 Apr 2013  
Very exciting news for those that want to get away! http://www.bbc.co.uk/news/science-environment-22146456[
Answer 16 Apr 2013   license: CPOL
You could just ready the outlook message body and write a html doc out of it. Have you also tried Redmeption?http://www.dimastr.com/redemption/home.htm[^]
Forum Message 16 Apr 2013  
alas, I am the lowest form of wit!
Forum Message 16 Apr 2013  
Nice. I look forward to it. you did say initially that creating the addin for 2010 was not pleasant. But you did. I would hope 2012 would have been better but I am sure you will succeed. Cloud
Forum Message 16 Apr 2013  
I am still amazed by their brazen ways. I really feel in limbo land. Not that HTML 5 with the JS libraries are anything bad, in fact I quite like angular, node etc but, its just when have had the tast
Forum Message 16 Apr 2013  
Hhhhmmmmmm... another nail in the coffin.
Forum Message 16 Apr 2013  
This does not tell me anything. You have not described anything nor have you supplied any code to download. First, what versions of are you using? MVC what. What MVC detail do you have.... What .N
Answer 15 Apr 2013   license: CPOL
Hi me again.I am interested to find out what went wrong with bulk inserts.Have you also looked at:1) Generate your chunk files as explained in solution 1. Instead of inserting into a database directly consider writing the file(s) to a folder/directory.2) Using SSIS to read the...
Answer 15 Apr 2013   license: CPOL
Hi,I think I like where this is going. Your speed will be down to the inserts into SQL as we all probably know. One way to really improve performance is bulk inserts but you mention that you have tried this before but no luck.You have not mentioned what .Net framework version you are...
Answer 14 Apr 2013   license: CPOL
what have your tried? have you looked at: http://www.asp.net/mvc/tutorials/mvc-4. Have you looked online?
Answer 14 Apr 2013   license: CPOL
Use WMI.http://social.msdn.microsoft.com/Forums/en-US/netfxnetcom/thread/34a66ee5-34f8-473d-b6f2-830a14e2300b/[^]
C#
Answer 14 Apr 2013   license: CPOL
Generic handlers must implement the IReadOnlySessionState interface to access session variables. If you also need to write session variables, implement IRequiresSessionState.i.e. somthing like:public class MemberHandler:IHttpHandler,IRequiresSessionState
Answer 14 Apr 2013   license: CPOL
Basically You need to look into the publish subscribe pattern. An excellent example is: http://www.idesign.net/Downloads#InstanceManagement. Take a look at the Publish subscribe framework.Basically, host your service (publisher) somewhere (app 1 or a dedicated service) and the have your apps...
Answer 13 Apr 2013   license: CPOL
One way would be to create a stored procedure like:ALTER PROCEDURE dbo.usp_SomeProc @TrxStartDate DATETIME, @TrxEndDate DATETIME, @PersonValue VARCHAR(10) = '', @ExpenseValue VARCHAR(10) = '', @UnitValue VARCHAR(10) = ''ASBEGIN SET NOCOUNT ON; DECLARE @Sql...
Answer 3 Apr 2013   license: CPOL
You should not have the app.xaml in a user control lib. get rid of that.The problem you have is that the user control lib is really for UIelements that are effectively told what resources to use by the application that references the user control lib. The way around this is to create a...
Forum Message 3 Apr 2013  
I saw this today and looks very promising!!!! Browser checking, download vms for local testing on all major browsers..... Also many references to IE10 :^)

Page 1 of 7
1 2 3 4 5 6 7


Advertise | Privacy | Mobile
Web03 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid