Click here to Skip to main content
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*
  
5,750 Results

Search



Sort by



Match


Rating Range

Advanced Filters:


Page 1 of 115
Page Size: 10 · 25 · 50

Author filtered by: Mika Wendelius [x]
Tip/Trick 11 May 2013   license: CPOL
LINQ based alternative for "Counting how many times a letter appears in a string"
C#.NETArchitectDevQABeginner.NETDecryption.NET4
Re: Thoughts by Mika Wendelius
Forum Message 10 May 2013  
If they were consultants, I bet they were protecting their future income. First time they solved performance bottlenecks and next time they'll solve data issues :)
Re: OriginalGriff by Mika Wendelius
Forum Message 10 May 2013  
Nice!!!
Thoughts by Mika Wendelius
Forum Message 10 May 2013  
There are few things you should correct before making this public: Spelling mistakes, there are quite a few of them so please go through the text and make necessary modifications. You
Re: Formatting. by Mika Wendelius
Forum Message 22 Apr 2013  
The version that is pending for approval seems unformatted. The formatting should be done by the author, before publishing.
Re: Unambiguously Ambiguous by Mika Wendelius
Forum Message 10 Apr 2013  
Or does it refer only to the comment which is technically finished but proper explanation isn't implemented :)
My vote of 5 by Mika Wendelius
Forum Message 10 Apr 2013  
Thoroughly written and very informative!
Question by Mika Wendelius
Forum Message 4 Apr 2013  
Hi, While I understand your point that using a sequence may feel clumsy I don't quite understand why sequences promote poor code? Wasn't the example in your blog a situation where a developer d
Incorrect type and formatting by Mika Wendelius
Forum Message 27 Mar 2013  
This would be more appropriate as a tip than a full length article. Also before publishing as a tip: - the formatting needs to be corrected. - some explanations for the code would be required.
Forum Message 25 Mar 2013  
The download link seems to point outside Code Project (http://www.bkelly.ws/irig/vs_project_asyncsocket.zip). All the images and donwnload should be hosted here so that they are available when the art
A tip by Mika Wendelius
Forum Message 15 Mar 2013  
Currently this could qualify as a tip, but not as a full length article. The formatting of the code blocks should also be corrected. You can use the article editor to change the type.
My vote of 5 by Mika Wendelius
Forum Message 15 Mar 2013  
Well done, looks really good and helpful. Actually quite similar to a tool I'm currently building :)
Re: Not an article by Mika Wendelius
Forum Message 26 Feb 2013  
Agree, and even if posted as a tip, it needs at least some additions and explanation about the code. Currently the Entity as well as EntityCollection classes could be anything, AccountRecords is un
Taken from by Mika Wendelius
Forum Message 10 Feb 2013  
http://www.programcall.com/24/csnet/method-overloading-in-csnet.aspx[
Forum Message 4 Feb 2013  
Glad you didn't get kicked out :)
Forum Message 2 Feb 2013  
In order for them to be available when the tip is read.
Re: My vote of 5 by Mika Wendelius
Forum Message 1 Feb 2013  
Thanks :) The need to optimize rises from a bad design.My articles[
Missing picture by Mika Wendelius
Forum Message 1 Feb 2013  
For some reason the picture isn't showing. Also even though this is a tip I would really like to see a bit more explanation of the code.
Re: Chris'isms by Mika Wendelius
Forum Message 30 Jan 2013  
There's no Escape on Chris' keyboard. Also delete and backspace buttons are untouched.
Not sure about this by Mika Wendelius
Forum Message 30 Jan 2013  
The same tip has already been posted several times. For example, have a look at Select a column in a co
Re: The code by Mika Wendelius
Forum Message 29 Jan 2013  
Okay, if you explain the internal implementation in there "Using the code" then the heading is a bit misleading, but I noticed that you have changed the heading for that section. Currently this loo
The code by Mika Wendelius
Forum Message 29 Jan 2013  
With a quick look, it looks like interesting, but I would like to see more explanations how the control is actually done, not just how it's being used.
Answer 29 Jan 2013   license: CPOL
The conditions basically look just fine. With a quick look possible problems may be:- you haven't used table aliases in front of field names. In order to avoid ambiquity, always define the table alias where the field is taken from- if either of the columns may contain a NULL value, you have...
SQL-ServerSQL-ServerSQL2008T-SQL
Re: Who's who... by Mika Wendelius
Forum Message 28 Jan 2013  
:~ Who is ... :~ I tried... I really tried :)
Few layout related issues by Mika Wendelius
Forum Message 28 Jan 2013  
For some reason the picture isn't showing. Have you uploaded it properly? Also the download is typically included in the beginning of an article/tip. Currently you have placed the download in the e
Re: Who's who... by Mika Wendelius
Forum Message 28 Jan 2013  
Who are you (you must have seen this coming) :)
Re: My vote of 3 by Mika Wendelius
Forum Message 22 Jan 2013  
Thanks :) The need to optimize rises from a bad design.My articles[
Forum Message 21 Jan 2013  
It seems that you have two separate versions of this tip. When making modifications, just edit the tip instead of posting a new one.
Re: My vote of 5 by Mika Wendelius
Forum Message 19 Jan 2013  
Thank you :)
Tip/Trick 19 Jan 2013   license: CPOL
This tip shows how to get rows from a table where a field contains a number that is a power of 2 using LOG function.
SQLSQL-ServerArchitectDBADevBeginner
Tip/Trick 17 Jan 2013   license: CPOL
This tip describes how to calculate an aggregate for dynamically defined columns using UNPIVOT clause.
SQLSQL-ServerArchitectDBADevDesignIntermediate
Answer 13 Jan 2013   license: CPOL
If you use Access, one quite easy way is to use TransferText[^] method to save the data in a CSV file and then open it using Excel. You can use for example Interop for Access to call appropriate methods.Another way could be to use OleDb and open a connection with OleDbConnection and do a...
C#C#4.0
Answer 13 Jan 2013   license: CPOL
If you're wondering the difference between for and foreach, you can think the for as looping a counter whereas foreach loops through elemenents in a collection.Please refer to:- for[^]- foreach[^]About the code block, it's unclear why you have the variable a which stores the length...
.NETC#C#4.0
Missing space in INSERT INTO by Mika Wendelius
Forum Message 12 Jan 2013  
The code block containing INSERT INTO statements seems to be missing spaces between the INSERT and INTO. So instead of INSERTINTO ...
Suggestions by Mika Wendelius
Forum Message 12 Jan 2013  
The weight of the file sounds a bit odd. Should you change the title to "size of the file"? Another thing, could you use pow function when you divide the size of the file? So instead of dividing th
Answer 12 Jan 2013   license: CPOL
One way is to use CHARINDEX[^] to find the new line and use that to for SUBSTRING[^].So something like SELECT SUBSTRING( MyColumn, 1, CHARINDEX( CHAR(10), MyColumn)) ...
C#VB.NETVB.NETms-sql-server.NET4.5
Answer 12 Jan 2013   license: CPOL
Since you're using Sql Server 2000 I think the easiest option is to create a small stored procedure which loops through the rows. For each row you iterate through the values in Tn Used and if you find multiple values separated by a comma, insert each one in a temporary table along with approver...
SQL2000SQL-Server
Answer 12 Jan 2013   license: CPOL
In my opinion the best way would be to use the OUTPUT[^] clause. So you could modify your insert statement and add it to the SQL. Something like:INSERT INTO MyTable (column1, column2) VALUES (...)OUTPUT inserted.CustomersID INTO @customeridJust remember to define a SqlParameter for the...
VBSQL-ServerSQL2008VB.NETTSQL
Answer 12 Jan 2013   license: CPOL
I think the last break is at wrong level (inside the else), have a try with:string sql_count = string.Format("select count(*) from RegisterMaster where UserId='{0}' and Password='{1}'", TxtUserId.Text, TxtPassword.Text); string sql = string.Format("select count(*) from...
ASP.NET
Answer 12 Jan 2013   license: CPOL
If you use a SELECT statement inside the stored procedure, the result is returned to the calling program. This way the result is handled as a result set, not as output parameters.For example have a look at http://www.sqlteam.com/article/stored-procedures-returning-data[^]
C#C#4.0
Answer 12 Jan 2013   license: CPOL
You didn't post any code, but based on the stack trace, have a look at the line 175 in the Page_Load method:Csharp.klientiprov.Page_Load(Object sender, EventArgs e) in C:\Users\User\Documents\Visual Studio 2010\Projects\Csharp\Csharp\klientiprov.aspx.cs:175
C#C#4.0
Answer 11 Jan 2013   license: CPOL
You mean you want to have different control vendors. Like:- ComponentOne[^]- Infragistics[^]- Telerik[^]
VBVB.NETDevExpress
Answer 11 Jan 2013   license: CPOL
The cursor is quite similar in other systems. In Sql Server, have a look at DECLARE CURSOR[^]So your cursor definition would look something like:DECLARE c CURSOR FOR SELECT * FROM tbinstrument;In MySql, have a look at Cursor DECLARE Syntax[^]
SQL-ServerMySQLOracle
Problem in Sql Transaction by Mika Wendelius
Answer 11 Jan 2013   license: CPOL
Based on the description, it sounds like you're having either a lock collision or even a deadlock.Try investigating from SSMS what the halted session is waiting for. For this you can use either activity monitor or query sys.dm_tran_locks[^]
C#SQL-Server
Answer 11 Jan 2013   license: CPOL
Depending on the data source you use, you can include the image in the data. For example if you use a dataset as the data source, why not include the image inside a data column.For example, have a look at Image in Crystal Reports[^]
C#
Forum Message 11 Jan 2013  
Yep, looks better now :thumbsup: The need to optimize rises from a bad design.
Remove file under directory by Mika Wendelius
Answer 11 Jan 2013   license: CPOL
Not sure if I understood the question correctly, but to delete a file, you can use File.Delete[^] method.
C#ASP.NET
Benefit of using BinaryReader by Mika Wendelius
Forum Message 11 Jan 2013  
What's the benefit of using a BinaryReader on a text file? I think the obvious question you should answer in the tip is why not just use
substitute of datagrid by Mika Wendelius
Answer 11 Jan 2013   license: CPOL
There are lot's of third party tools you can buy. To name few:- DevExpress[^]- ComponentOne[^]- Infragistics[^]They all have their own kinds of grids to show the data. Depending on the technology you use you may want to investigate different packages of the vendors (ASP, WPF, Forms and...
C#C#4.0
Answer 11 Jan 2013   license: CPOL
Have a try with a bit different syntaxDBCC CHECKIDENT ("product", RESEED, 999);GOAlso make sure that you have the sufficient privileges, namely one of these:- sysadmin - db_owner- db_ddladmin
SQL-CESQL-ServerWebmatrix
Page 1 of 115
1 2 3 4 5 6 7 8 9 10
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