9,869,444 members (43,369 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*
213 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 5
Page Size:
10
·
25
·
50
Author filtered by: Tharaka MTR
[x]
My Vote 5
by
Tharaka MTR
Forum Message
12 May 2013
Nice !! Tharaka Ragith Kumara Eyepax IT Consulting (Pvt) Ltd. Visit my blog
General Discussions
»
Article "How To Get Database Connection String"
Resources on patterns & practices
by
Tharaka MTR
Answer
23 Apr 2013
license:
CPOL
http://msdn.microsoft.com/en-u...
General Programming
»
Uncategorised Quick Answers
»
General
.NET
SQL SERVER 2008 R2
by
Tharaka MTR
Answer
23 Apr 2013
license:
CPOL
No, you can't have two identity columns.
General Programming
»
Uncategorised Quick Answers
»
General
SQL2008R2
Re: My vote of 5
by
Tharaka MTR
Forum Message
18 Apr 2013
Thanks for the v5. Tharaka Ragith Kumara Eyepax IT Consulting (Pvt) Ltd. Visit my blog
General Discussions
»
Tip/Trick "Validate Credit Card Number With Mod 10 Algorithm"
QR Code using vb.net in visual studio 2012
by
Tharaka MTR
Answer
12 Mar 2013
license:
CPOL
Check following URLhttp://qrcodenet.codeplex.com/[^]Just launched new open source project QrCode.Net at http://qrcodenet.codeplex.com[^]
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
Code
VisualStudio2012
How To Make Relationship one To many In The Same Talbe
by
Tharaka MTR
Answer
10 Mar 2013
license:
CPOL
check thishttp://stackoverflow.com/questions/4116416/parent-child-in-same-table[^]http://stackoverflow.com/questions/2763860/how-to-query-with-child-relations-to-same-table-and-order-this-correctly[^]
General Programming
»
Uncategorised Quick Answers
»
General
Relationship
generate XML tags from SQL table
by
Tharaka MTR
Answer
8 Mar 2013
license:
CPOL
Check thishttp://stackoverflow.com/questions/13984925/self-closing-tags-in-xml-in-sql-server[^]
General Programming
»
Uncategorised Quick Answers
»
General
XML
SQL-Server
Column count doesn't match value count at row 1
by
Tharaka MTR
Answer
7 Mar 2013
license:
CPOL
Check your no. of fields and no. of values. Both fields and values should be equal.
General Programming
»
Uncategorised Quick Answers
»
General
C#
.NET
MySQL
How to print only selected(specified) columns in gridview using javascript
by
Tharaka MTR
Answer
7 Mar 2013
license:
CPOL
When printing the page, first hide the unwanted columns then call the print() function and then show previously hide columnsHide grid view column using...
General Programming
»
Uncategorised Quick Answers
»
General
C#
Javascript
Gridview
Create Monthly Attendance Report
by
Tharaka MTR
Answer
5 Mar 2013
license:
CPOL
for this I recommend you to use the CROSSTAB query. In SQL PIVOT table.http://blogs.msdn.com/b/spike/archive/2009/03/03/pivot-tables-in-sql-server-a-simple-sample.aspx[^]http://msdn.microsoft.com/en-us/library/ms177410(v=sql.105).aspx[^]try your self. If you have any question feel free...
General Programming
»
Uncategorised Quick Answers
»
General
ASP.NET
SQL
DataTable
RDLC
How to stop Ajax Timer Control
by
Tharaka MTR
Answer
5 Mar 2013
license:
CPOL
you have to use the Ajax control.and put your label inside that.please check the following as a guidehttp://www.c-sharpcorner.com/UploadFile/364074/timercontrol-with-updatepanel-in-ajax-using-Asp-Net/[^]
General Programming
»
Uncategorised Quick Answers
»
General
ASP.NET
decimal string split
by
Tharaka MTR
Answer
5 Mar 2013
license:
CPOL
you complete code seems wrong. It should modify as follows.Dim d As Double = 13.23Dim s As String = Convert.ToString(d)Dim strArray() As String = s.Split("."C)Dim beforeDecimalPoint As String = strArray(0)Dim afterDecimalPoint As String = strArray(1)
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
Bind observerbaleCollection to wpf combo box
by
Tharaka MTR
Answer
4 Mar 2013
license:
CPOL
Basically, you have to use "ItemSource", "SelectedValuePath", "DisplayMemberPath" property with respective binding. SelectedValuePath="[your selected value path]" DisplayMemberPath="[your display member path]" />
General Programming
»
Uncategorised Quick Answers
»
General
WCF
WPF
create a function that give comma separated value from a string
by
Tharaka MTR
Answer
4 Mar 2013
license:
CPOL
Check my article, you will get the idea how to do that your self.Generating and splitting a delimited string column[^]If you have any question feel free to ask
General Programming
»
Uncategorised Quick Answers
»
General
SQL
'Maximum request length exceeded' error message while trying to export data to excel.
by
Tharaka MTR
Answer
4 Mar 2013
license:
CPOL
Please check followinghttp://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/0da08501-4655-4012-ad0e-60a81ebf55e8[^]
General Programming
»
Uncategorised Quick Answers
»
General
C#3.0
ASP.NET
C#
Re: sometimes questions are not displayed
by
Tharaka MTR
Forum Message
4 Mar 2013
seems you are true.. but still the same issue there... :( Tharaka Ragith Kumara Eyepax IT Consulting (Pvt) Ltd.
General Discussions
»
Site Bugs / Suggestions
sometimes questions are not displayed
by
Tharaka MTR
Forum Message
2 Mar 2013
Most of the time when I click Quick Answer -> All Unanswered It displays a message "Sorry No Entries were found" I tried Quick Answer -> All Questions But same message displayed most of the
General Discussions
»
Site Bugs / Suggestions
Session got null (some time) when call to Web services
by
Tharaka MTR
Answer
24 Feb 2013
license:
CPOL
Im agreed with ryanb31 answer. First you have to enable the session in your web service.you can do that by adding following line to your web service[WebMethod(EnableSession =...
General Programming
»
Uncategorised Quick Answers
»
General
ASP.NET
Javascript
WebService
[c#] Print specific page
by
Tharaka MTR
Answer
24 Feb 2013
license:
CPOL
Check the following articlehttp://www.c-sharpcorner.com/UploadFile/dbeniwal321/printing-multiple-pages-in-C-Sharp/[^]http://www.dreamincode.net/forums/topic/44330-printing-in-c%23/[^]
General Programming
»
Uncategorised Quick Answers
»
General
C#
printing
Special read from a text file
by
Tharaka MTR
Answer
23 Feb 2013
license:
CPOL
you can use regular expression for this.try followingusing System.IO;using System.Text.RegularExpressions;private void ProcessSubTitleFile(string pathToFile){Regex regex = new...
General Programming
»
Uncategorised Quick Answers
»
General
VB
VB.NET
Sql connection security
by
Tharaka MTR
Answer
23 Feb 2013
license:
CPOL
you can encrypt your connection stringCheck followinghttp://msdn.microsoft.com/en-us/library/89211k9b(v=vs.80).aspx[^]Encrypting the app.config File for Windows Forms Applications[^]
General Programming
»
Uncategorised Quick Answers
»
General
C#
SQL
.NET
SQL-Server
WinForm
How to maintain Individual user sessions in asp.net
by
Tharaka MTR
Answer
22 Feb 2013
license:
CPOL
It is automatically maintained. your question is not clear.do you want to add individual data to session? or do you want to store authentication information in session?check these articleExploring Session in...
General Programming
»
Uncategorised Quick Answers
»
General
ASP.NET
kill session asp.net
by
Tharaka MTR
Answer
22 Feb 2013
license:
CPOL
check thishttp://stackoverflow.com/questions/6695693/auto-logout-on-disconnect[^]
General Programming
»
Uncategorised Quick Answers
»
General
ASP.NET
How to analyze code with a parser?
by
Tharaka MTR
Answer
22 Feb 2013
license:
CPOL
check this http://stackoverflow.com/questions/4744105/parse-and-execute-js-by-c-sharp[^]
General Programming
»
Uncategorised Quick Answers
»
General
C#
How to run commands in a Admin Command Prompt in C#?
by
Tharaka MTR
Answer
22 Feb 2013
license:
CPOL
http://blog.bartwolff.com/post/2012/06/19/Running-with-elevated-privileges-from-C.aspx[^]http://jpassing.com/2007/12/08/launch-elevated-processes-from-the-command-line/[^]
General Programming
»
Uncategorised Quick Answers
»
General
C#
Hexa Decimal to Ascii value
by
Tharaka MTR
Answer
22 Feb 2013
license:
CPOL
private string HexString2Ascii(string hexString){StringBuilder sb = new StringBuilder();for (int i = 0; i
General Programming
»
Uncategorised Quick Answers
»
General
C#
C#4.0
Confusin in Response.ContentType
by
Tharaka MTR
Answer
19 Feb 2013
license:
CPOL
Please check the followinghttp://msdn.microsoft.com/en-us/library/ms775147.aspx[^]
General Programming
»
Uncategorised Quick Answers
»
General
VB
ASP.NET
How to compresse image in VB.Net
by
Tharaka MTR
Answer
19 Feb 2013
license:
CPOL
Check followingshttp://stackoverflow.com/questions/11244752/resizing-compressing-and-smoothing-images-with-vb-net[^]http://msdn.microsoft.com/en-us/library/bb882583.aspx[^]
General Programming
»
Uncategorised Quick Answers
»
General
VB
MySQL
VB.NET
why i can not use static constructor in struct ?
by
Tharaka MTR
Answer
18 Feb 2013
license:
CPOL
It definitely access static constructor. But only for first time when the "Employ" strut instance is created. if you trying to create new instance second time it will not access. A static constructor is used to initialize any static data, or to perform a particular action that needs performed...
General Programming
»
Uncategorised Quick Answers
»
General
C#
in combobox how to store values manually using csharp
by
Tharaka MTR
Answer
18 Feb 2013
license:
CPOL
Have you tried anything?Please see below links. http://www.dotnetperls.com/combobox[^]http://msdn.microsoft.com/en-us/library/system.windows.forms.combobox.aspx[^]
General Programming
»
Uncategorised Quick Answers
»
General
C#
Counting Consecutive Dates Using SQL
by
Tharaka MTR
Technical Blog
17 Feb 2013
license:
CPOL
Recently I have answered one of the SQL based question in the CodeProject. Thanks for the participant that question wake up me to write this blog post. Question: He has a table (tblLeave) with the data like below. And he wants to output the data as below Condition: If same type of leave taken contin
Database
»
Database
»
General
SQL2005
SQL
SQL-Server
DBA
SQL-Server
SQL2008
SQL2012
To retrieve column values from an xmlstring using for xml clause
by
Tharaka MTR
Answer
6 Feb 2013
license:
CPOL
Suppose you table is MyXMLData and the column name is XmlDataColumnSELECT [XmlDataColumn].query('.//InstalledDate').value('.','VARCHAR(MAX)')FROM [MyXMLData]With regarding your comments, please check following querySELECT [XmlDataColumn].value('(//ID)[1]', 'VARCHAR(MAX)') AS ID,...
General Programming
»
Uncategorised Quick Answers
»
General
C#
WPF
SQL Database Partitioning
by
Tharaka MTR
Answer
5 Feb 2013
license:
CPOL
Check following URLs.1. SQL SERVER – 2005 – Database Table Partitioning Tutorial – How to Horizontal Partition Database Table[^].2. Partitioning[^].
General Programming
»
Uncategorised Quick Answers
»
General
SQL-Server
How to convert usa phonenumber format?
by
Tharaka MTR
Answer
5 Feb 2013
license:
CPOL
My recommendation to use mask text box for your purposehttp://www.asp.net/ajaxLibrary/AjaxControlToolkitSampleSite/MaskedEdit/MaskedEdit.aspx[^]and there is a JQuery plugin for thishttp://archive.plugins.jquery.com/project/numberformatter[^]and finally please check...
General Programming
»
Uncategorised Quick Answers
»
General
ASP.NET
Two sections in the same page
by
Tharaka MTR
Answer
31 Jan 2013
license:
CPOL
I think you can use ASP.NET Ajax enabled masterpage with two content panelPlease check following pages.http://www.asp.net/web-forms/tutorials/master-pages/master-pages-and-asp-net-ajax-cs[^]http://www.asp.net/ajax/documentation/live/tutorials/UsingUpdatePanelMasterPages.aspx[^]
General Programming
»
Uncategorised Quick Answers
»
General
ASP.NET
how to write the query using 'in' cause in stroed procedures
by
Tharaka MTR
Answer
30 Jan 2013
license:
CPOL
you can pass the clientname as comma seperated string as follows'AA,BBB,CCC'split that as a table and use to the IN query.You can use following table function to split and create the table from your comma separated stringCREATE FUNCTION [dbo].[FT_CSVToTable] (@CSVList...
General Programming
»
Uncategorised Quick Answers
»
General
SQL
SQL-Server
can we communicate between systems in hetregeneous networks using WCF
by
Tharaka MTR
Answer
30 Jan 2013
license:
CPOL
Pls refer following articles and slideshttp://www.slideshare.net/jthelin/interoperability-and-wcf-overview-presentation[^]http://msdn.microsoft.com/en-us/library/aa702565(v=vs.90).aspx[^]WCF Service with custom username password authentication[^]
General Programming
»
Uncategorised Quick Answers
»
General
C#
How to return Anonymous Type in linq
by
Tharaka MTR
Answer
28 Jan 2013
license:
CPOL
Check this article,http://blogs.msdn.com/b/swiss_dpe_team/archive/2008/01/25/using-your-own-defined-type-in-a-linq-query-expression.aspx[^]
General Programming
»
Uncategorised Quick Answers
»
General
ASP.NET
Alternative of FOR XML PATH in SQL Server 2000
by
Tharaka MTR
Answer
28 Jan 2013
license:
CPOL
See my article below, I have explained most of the possibilities.Generating and splitting a delimited string column[^]
General Programming
»
Uncategorised Quick Answers
»
General
SQL2000
SQL-Server
SQL-Server
Clear browers Javascript and CSS
by
Tharaka MTR
Answer
28 Jan 2013
license:
CPOL
You can't clear browser cache using Javscript But you can clear the application cache pragmatically.$('.button').click(function() { $.ajax({ url: "", context: document.body, success: function(s,x){ ...
General Programming
»
Uncategorised Quick Answers
»
General
Javascript
CSS
I want a clear understanding web services tutorial?
by
Tharaka MTR
Answer
27 Jan 2013
license:
CPOL
Here are some article for Web Serviceshttp://www.west-wind.com/presentations/dotnetwebservices/DotNetWebServices.asp[^]http://www.w3schools.com/webservices/default.asp[^]I recommend you to check the WCF...
General Programming
»
Uncategorised Quick Answers
»
General
ASP.NET
datetime formate problem
by
Tharaka MTR
Answer
27 Jan 2013
license:
CPOL
Use DateTime.ParseExact Methodhttp://msdn.microsoft.com/en-us/library/w2sa9yss.aspx[^]
General Programming
»
Uncategorised Quick Answers
»
General
C#
ASP.NET
how to code review of .net windwos application?
by
Tharaka MTR
Answer
27 Jan 2013
license:
CPOL
Check this articles you will get some ideaC# Code Reviews using StyleCop – Detailed Article[^]http://www.c-sharpcorner.com/UploadFile/dommym/a-real-code-review-in-C-Sharp/[^]http://weblogs.asp.net/tgraham/archive/2003/12/19/44763.aspx[^]
General Programming
»
Uncategorised Quick Answers
»
General
C#
SQL-Server
.NET
.NET4
Web service and Script service
by
Tharaka MTR
Technical Blog
26 Jan 2013
license:
CPOL
Web service and script service.
Web Development
»
Web Services
»
General
C#
ASP.NET
Windows
QA
Ajax
jQuery
WebService
ScriptManager
SQL Server Query statement
by
Tharaka MTR
Answer
26 Jan 2013
license:
CPOL
Check this.SELECT LV_TYPE,LV_TYPE,MIN(FROM_DATE) AS FROM_DATE ,MAX(TO_DATE) AS TO_DATE, COUNT(LVALUEP) AS LVALUE FROM tblLeaveGROUP BY PAYCODE,LV_TYPEPlease try followingSELECT PAYCODE,LV_TYPE, MIN(FROM_DATE) AS FROM_DATE, MAX(FROM_DATE) AS TO_DATE, COUNT('A') AS...
General Programming
»
Uncategorised Quick Answers
»
General
SQL-Server
SQL2008
multiple jquery not working together
by
Tharaka MTR
Answer
26 Jan 2013
license:
CPOL
It seems this issue occurred due to the conflict with two jquery file.There are several way to overcome this.One way is using jQuery.noConflict() method.http://api.jquery.com/jQuery.noConflict/[^]Also you avoid this by using the full jquery...
General Programming
»
Uncategorised Quick Answers
»
General
ASP.NET
jQuery
How to change rows to colums using view in sql 2008
by
Tharaka MTR
Answer
24 Jan 2013
license:
CPOL
You can use PIVOT query,http://msdn.microsoft.com/en-us/library/ms177410(v=sql.100).aspx[^]try your self and get back to us if you need any more help
General Programming
»
Uncategorised Quick Answers
»
General
SQL-Server
How to use Pivot query in MsAccess DataBase
by
Tharaka MTR
Answer
24 Jan 2013
license:
CPOL
Check the answer in below forum, you can use this type of methodhttp://stackoverflow.com/questions/6571470/ms-access-2010-sql-query-help[^]http://www.fmsinc.com/tpapers/queries/crosstab.html[^]
General Programming
»
Uncategorised Quick Answers
»
General
C#
In MSaccess how to get the output
by
Tharaka MTR
Answer
24 Jan 2013
license:
CPOL
Please check following two forum and article,http://stackoverflow.com/questions/6571470/ms-access-2010-sql-query-help[^]http://www.fmsinc.com/tpapers/queries/crosstab.html[^]
General Programming
»
Uncategorised Quick Answers
»
General
C#
onblur in javascript
by
Tharaka MTR
Answer
23 Jan 2013
license:
CPOL
Hi modify your javascript function as "Surname()" by removing the txt_ prefix.Problem here is, your text box and the java script function has same name.function SurName(){var x= document.getElementById("txt_SurName");x.value=x.value.toUpperCase(); }
General Programming
»
Uncategorised Quick Answers
»
General
C#
ASP.NET
Page 1 of 5
1
2
3
4
5
First
·
Prev
·
Next
·
Last
Advertise
|
Privacy
|
Mobile
Web02 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright ©
CodeProject
, 1999-2013
All Rights Reserved.
Terms of Use
Layout:
fixed
|
fluid