9,868,710 members (30,637 online)
Visit CodeProject.TV
Discuss CodeProject.TV
Sign in
Email
Password
Forgot your password?
Sign in using
home
articles
Chapters and Sections
>
Search
Latest Articles
Latest Tips/Tricks
Top Articles
Beginner Articles
Technical Blogs
Posting/Update Guidelines
Article Help Forum
Article Competition
Submit an article or tip
Post your Blog
quick answers
Ask a Question
View Unanswered Questions
View All Questions...
C# questions
ASP.NET questions
VB.NET questions
C#4.0 questions
C++ questions
discussions
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work & Training Issues
Design and Architecture
ASP.NET
JavaScript
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
Adobe Technologies
C#
Free Tools
Objective-C
Ruby On Rails
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
.NET Framework
Mobile
VS 11 & .NET 4.5
Sharepoint
Silverlight / WPF
Visual Basic
Web Development
Site Bugs / Suggestions
features
Component & Service Catalog
Competitions
News
The Insider Newsletter
Newsletter archive
Surveys
Product Showcase
Research Library
CodeProject Stuff
community
The Insider News
The Lounge
The Weird & The Wonderful
The Soapbox
Press Releases
Who's Who
Most Valuable Professionals
Company Listings
Non-English Language
>
General Indian Topics
General Chinese Topics
help
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
Site Map
Advertise with us
Employment Opportunities
About Us
The default search term operator is
AND
.
You can use brackets,
AND
,
OR
, and
NOT
to improve your search. For example:
C# AND NOT(VB or SQL)
A query of a single
*
will return everything, filtered by any filters.
Filter examples:
Search by Author
author:"author name"
Filter by tag
tag:C#
or
tag:(C++ or Java)
Wildcard search
use "?" or "*" eg.
gr?d
or
gr*
306 Results
Search
Everything
Articles
Technical Blogs
Tips & Tricks
Questions
Answers
Forum Messages
News Items
Catalog Items
Videos
Training Courses
Just My Stuff
My Bookmarks
Sort by
Relevance
Rating Asc
Rating Desc
Title Asc
Title Desc
Author Asc
Author Desc
Date Created Asc
Date Created Desc
Date Modified Asc
Date Modified Desc
Price Asc
Price Desc
Duration Asc
Duration Desc
Match
All Fields
Title
Description
Author(s)
Tags
Any Date
Last 12 hours
Last 24 hours
Last week
Last 2 weeks
Last month
Last 3 months
Last 6 months
Last year
January
February
March
April
May
June
July
August
September
October
November
December
Rating Range
All - Including Unrated
1.0 - 5.0
2.0 - 5.0
3.0 - 5.0
4.0 - 5.0
4.5 - 5.0
4.8 - 5.0
5.0
Advanced Filters:
Article Topics
All Topics
Desktop Development
Web Development
Mobile Development
Cloud Computing
Enterprise Systems
Database
Multimedia
Languages
Platforms, Frameworks & Libraries
General Programming
Graphics / Design
Development Lifecycle
General Reading
Third Party Products
Mentor Resources
Article License
All Licenses
CPOL
CDDL
Ms-PL
MPL
CPL
Eclipse
MIT
BSD
Apache
CC (ASA 2.5)
Zlib
Public Domain
CC (Attr 3U)
CC (ASA 3U)
LGPL3
GPL3
Forums
All Forums
Feature Forums
General Programming
Web Development
Product Lifecycle
Database & SysAdmin
General Discussions
Non-English Language
Catalog Category
All Categories
Books & Training
Charting & Graphing
Components, Controls, Libraries
Data Manipulation & Mining
Database Tools
Debugging
Documentation & Help
Financial, Math & Scientific
Frameworks & APIs
General Development Tools
GIS & Maps
Graphics & 3D Modeling
Hardware and Robotics
Hosting
IDEs
Imaging
Mobility
Multimedia
Networking
Performance and Profiling
Programming Languages
Project Life-cycle Management (ALM)
Reporting
Search
Security
Setup & Deploy
System Adminstration
Utilities
Virtualization
Web Design/Development
Catalog License
All Licenses
Commercial
Fully Function Evaluation version
Limited Functionality Trial
Limited Time Trial
Shareware
Free For Personal Use
Freeware
Page 1 of 7
Page Size:
10
·
25
·
50
Author filtered by: db7uk
[x]
How to divide the single column of a database table in two different columns? with same ID
by
db7uk
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...
General Programming
»
Uncategorised Quick Answers
»
General
ASP.NET
SQL-Server
Re: Very good
by
db7uk
Forum Message
10 May 2013
Its ok, i already had done. Good luck!
General Discussions
»
Article "Mvc Basic Site: Step 3 – Dynamic Layouts And Site Admin With: Ajax, Jqgrid, Controller Extensions, Html Helpers, And More"
Where can I learn WPF step by step
by
db7uk
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...
General Programming
»
Uncategorised Quick Answers
»
General
C#
Windows
WPF
This is good!
by
db7uk
Forum Message
6 May 2013
Thanks for sharing.
General Discussions
»
Technical Blog "Enhanced Windows Phone 8 Map Gestures"
Very good
by
db7uk
Forum Message
6 May 2013
5+
General Discussions
»
Article "Mvc Basic Site: Step 3 – Dynamic Layouts And Site Admin With: Ajax, Jqgrid, Controller Extensions, Html Helpers, And More"
Nice
by
db7uk
Forum Message
6 May 2013
Good one Tim. Nothing worse than ; being missed off the ends!!!
General Discussions
»
Article "Javascript Best Practices"
Re: Leaving a company
by
db7uk
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
General Discussions
»
The Lounge
Error in asp.net project
by
db7uk
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...
General Programming
»
Uncategorised Quick Answers
»
General
C#
C#4.0
gridview paging problem
by
db7uk
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...
General Programming
»
Uncategorised Quick Answers
»
General
paging
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:
General Discussions
»
Article "Twitterbootstrapmvc"
Re: Dont fight. Switch!
by
db7uk
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 "
General Discussions
»
The Lounge
Re: Always been involved in management and Financial apps...
by
db7uk
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
General Discussions
»
Survey "Do You Write Gaming Apps?" (29 Apr 2013)
Converting desktop permission settings to a web based application
by
db7uk
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...
General Programming
»
Uncategorised Quick Answers
»
General
ASP.NET
VB
VB.NET
Re: Always been involved in management and Financial apps...
by
db7uk
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
General Discussions
»
Survey "Do You Write Gaming Apps?" (29 Apr 2013)
Re: Walking While Working
by
db7uk
Forum Message
28 Apr 2013
It would be nice to "Sleep while working". Not found a pill for that yet :-\
General Discussions
»
The Insider News
How to write a cursor inside a stored procedure
by
db7uk
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...
General Programming
»
Uncategorised Quick Answers
»
General
C#
Pencil,Brush like tool for Asp.net
by
db7uk
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
General Programming
»
Uncategorised Quick Answers
»
General
ASP.NET
VB
VB.NET
Linq : "The return types for the following stored procedures could not be detected"
by
db7uk
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?
General Programming
»
Uncategorised Quick Answers
»
General
LINQ
Que releted to Window application ...
by
db7uk
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[^]
General Programming
»
Uncategorised Quick Answers
»
General
C#
.NET
.NET4.5
Web.config in web service
by
db7uk
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[^]
General Programming
»
Uncategorised Quick Answers
»
General
Oracle
service
Web
Just read this!
by
db7uk
Forum Message
24 Apr 2013
very good. Hope you are well. my 5+
General Discussions
»
Article "Javascript Best Practices"
Dependency Injection -- Some simpler real life example needed
by
db7uk
Answer
23 Apr 2013
license:
CPOL
Try:http://en.wikipedia.or...
General Programming
»
Uncategorised Quick Answers
»
General
Patterns
Grid Control for ASP.NET MVC
by
db7uk
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....
General Programming
»
Uncategorised Quick Answers
»
General
grid
MVC4
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+
General Discussions
»
Article "D3.Js Crash Course - Part2"
Please help me to solve this once and foe all
by
db7uk
Answer
22 Apr 2013
license:
CPOL
What is the :SELECT '','------------'doing in the query?
General Programming
»
Uncategorised Quick Answers
»
General
SQL-Server
SQL2008
how to get images from ApiControler
by
db7uk
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...
General Programming
»
Uncategorised Quick Answers
»
General
ASP.NET
image
webapi
Please I want to get the sum of total assets of these tables
by
db7uk
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.
General Programming
»
Uncategorised Quick Answers
»
General
SQL-Server
SQL2008
Filter query results with values from datepicker
by
db7uk
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...
General Programming
»
Uncategorised Quick Answers
»
General
C#
WPF
MySQL
DataGrid
query
Help
Use sql function in condition
by
db7uk
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
General Programming
»
Uncategorised Quick Answers
»
General
SQL-Server
Total Assets always show null. Can any one help me get the right value
by
db7uk
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))
General Programming
»
Uncategorised Quick Answers
»
General
SQL-Server
SQL2008
bind Static property in Xaml WPF
by
db7uk
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.
General Programming
»
Uncategorised Quick Answers
»
General
C#
.NET
WPF
C#
.NET
C#4.0
.NET4
Re: Fancy a re-location?
by
db7uk
Forum Message
18 Apr 2013
Excellent picture. How long did that take? who needs photoshop. :thumbsup:
General Discussions
»
The Lounge
How can I create CmdExec SSIS Job to check if file exists in a folder
by
db7uk
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...
General Programming
»
Uncategorised Quick Answers
»
General
SSIS
Re: Fancy a re-location?
by
db7uk
Forum Message
18 Apr 2013
ha, and then send all the crims there too...
General Discussions
»
The Lounge
Fancy a re-location?
by
db7uk
Forum Message
18 Apr 2013
Very exciting news for those that want to get away! http://www.bbc.co.uk/news/science-environment-22146456[
General Discussions
»
The Lounge
Outlook 2003 Interop - Save .msg file as html.
by
db7uk
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[^]
General Programming
»
Uncategorised Quick Answers
»
General
C#
Outlook
Interop
Re: Netflix Moving from Silverlight to HTML5
by
db7uk
Forum Message
16 Apr 2013
alas, I am the lowest form of wit!
General Discussions
»
The Insider News
Re: Netflix Moving from Silverlight to HTML5
by
db7uk
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
General Discussions
»
The Insider News
Re: Netflix Moving from Silverlight to HTML5
by
db7uk
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
General Discussions
»
The Insider News
Re: Netflix Moving from Silverlight to HTML5
by
db7uk
Forum Message
16 Apr 2013
Hhhhmmmmmm... another nail in the coffin.
General Discussions
»
The Insider News
[My vote of 1] Sorry
by
db7uk
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
General Discussions
»
Tip/Trick "Basic Sample For Mvc + Wcf + Ioc + Repository Pattern"
SQL CONSOLE APPLICATION, OPTIMIZATION
by
db7uk
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...
General Programming
»
Uncategorised Quick Answers
»
General
C#
SQL
Threading
optimization
insert
SQL CONSOLE APPLICATION, OPTIMIZATION
by
db7uk
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...
General Programming
»
Uncategorised Quick Answers
»
General
C#
SQL
Threading
optimization
insert
ASP.NET MVC4 Application
by
db7uk
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?
General Programming
»
Uncategorised Quick Answers
»
General
ASP.NET
Getting Wireless Signal Strength
by
db7uk
Answer
14 Apr 2013
license:
CPOL
Use WMI.http://social.msdn.microsoft.com/Forums/en-US/netfxnetcom/thread/34a66ee5-34f8-473d-b6f2-830a14e2300b/[^]
General Programming
»
Uncategorised Quick Answers
»
General
C#
why object session is not available in a ASHX handler ?
by
db7uk
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
General Programming
»
Uncategorised Quick Answers
»
General
C#
ASP.NET
ASHX
Why am I getting an exception (TCP error code 10061) when attempting to communicate between 2 applications using WCF?
by
db7uk
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...
General Programming
»
Uncategorised Quick Answers
»
General
C#
.NET
WCF
IPC
Is there a quick way to select from sqldatabase using multiple dropdownlist selected values?
by
db7uk
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...
General Programming
»
Uncategorised Quick Answers
»
General
VB
ASP.NET
WPF as a library - "Application Definition" problem
by
db7uk
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...
General Programming
»
Uncategorised Quick Answers
»
General
C#
WPF
VisualStudio2012
Its not a poll option but could help someone.
by
db7uk
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 :^)
General Discussions
»
Survey "What Browsers Do You Support With Your Web Applications" (01 Apr 2013)
Page 1 of 7
1
2
3
4
5
6
7
First
·
Prev
·
Next
·
Last
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