9,867,109 members (27,872 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*
3,354 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 135
Page Size:
10
·
25
·
50
Tag filtered by: LINQ
[x]
IN operator problem in LINQ
by
OriginalGriff
Answer
13 May 2013
license:
CPOL
Along the lines of:int[] idList = new int[] { 1, 3, 5, 7 }var values = from t in table where idList.Contains(t.ID) select t;
General Programming
»
Uncategorised Quick Answers
»
General
LINQ
IN operator problem in LINQ
by
sai sagar
Question
13 May 2013
license:
CPOL
SELECT * FROM table WHERE ID IN (1, 3, 5, 7)how can i write this query into LINQ.
General Programming
»
Uncategorised Quick Answers
»
General
LINQ
YouConf - Your Live Online Conferencing Tool
by
Phil Lee NZ
Article
12 May 2013
license:
CPOL
A site for managing and delivering virtual conferences - complete with embedded live streaming and chat.
Cloud Computing
»
Azure
»
Windows Azure Developer Contest
C#
ASP.NET
Javascript
.NET
SQL-Server
IIS
Visual-Studio
HTML
Architect
Dev
, +
Linq performance issue
by
shak imran
Question
11 May 2013
license:
CPOL
hi,i am going to do a project that might be contain 100+ tables. some body says to avoid linq./*! * jQuery Cookie Plugin v1.3.1 * https://github.com/carhartl/jquery-cookie * * Copyright 2013 Klaus Hartl * Released under the MIT license */(function (factory) { if (typeof...
General Programming
»
Uncategorised Quick Answers
»
General
LINQ
Windows Azure Storage Extensions
by
Dmitry Tretyakov
Article
10 May 2013
license:
CPOL
.NET library aimed for managing and querying entities from Windows Azure Storage. Contains LINQ to Azure Table provider.
Cloud Computing
»
Azure
»
General
C#
.NET
Dev
LINQ
.NET
Framework
.NET4
Asynchronous
.NET4.5
Dynamically evaluated SQL LINQ queries
by
Don Kackman
Article
10 May 2013
license:
CPOL
Extension methods to evaluate plain text SQL queries against IEnumerable collections.
Platforms, Frameworks & Libraries
»
Linq
»
General
C#
.NET
Architect
Dev
LINQ
Intermediate
C#
.NET
C#4.0
.NET4
Display or format lists/collections/arrays using simple LINQ-style extension methods.
by
Eric Lynch
Article
10 May 2013
license:
CPOL
This article provides and describes the EnumerableExt class, which simplifies the display and formatting of lists, collections, and arrays. It accomplishes this by implementing extension methods (Append, BuildString, and Write) that are available via the IEnumerable interface.
General Programming
»
Collections
»
General
C#3.0
.NET3.5
C#
Windows
.NET
Dev
LINQ
Intermediate
C#
.NET
, +
retrieve the last id of a table
by
Karthik_J, Coimbatore
Answer
10 May 2013
license:
CPOL
you r right ryanb31,But, if ur table don't have Identity column then go for this...create Procedure Get_LastRow(@Tname Varchar(50))ASBEGINEXECUTE ('DECLARE GETLAST CURSOR DYNAMIC FOR SELECT ImageName FROM ' + @Tname)OPEN GETLASTFETCH LAST FROM GETLASTCLOSE...
General Programming
»
Uncategorised Quick Answers
»
General
C#
SQL-Server
ADO.NET
LINQ
retrieve the last id of a table
by
Naourass Derouichi
Question
10 May 2013
license:
CPOL
hello, i m developping an application with an ado.net data model. What is the code to retrieve the last recorded id of a table, and show the value in a label?
General Programming
»
Uncategorised Quick Answers
»
General
C#
SQL-Server
ADO.NET
LINQ
retrieve the last id of a table
by
Naourass Derouichi
Answer
10 May 2013
license:
CPOL
here's the solution:using (DbEntities db = new DbEntities()) { int IdA = db.Table.Max(a => a.IdTable); label1.Text = IdA.ToString(); }
General Programming
»
Uncategorised Quick Answers
»
General
C#
SQL-Server
ADO.NET
LINQ
retrieve the last id of a table
by
ryanb31
Answer
9 May 2013
license:
CPOL
If you want to get the last ID of an identity field in SQL you can use SCOPE_IDENTITY()For example:INSERT INTO table1(field1)VALUES ('test')SELECT SCOPE_IDENTITY() AS NewestIDIf you want to do this later on, not when inserting a record you would just find the max IDSELECT...
General Programming
»
Uncategorised Quick Answers
»
General
C#
SQL-Server
ADO.NET
LINQ
Take the Data of “GRIDVIEW” to Excel. The data is in ItemsSource as AnonymousType, Table or DataView
by
wengqian
Tip/Trick
9 May 2013
license:
CPOL
Taking data of Gridview to Excel
Desktop Development
»
Grid & Data Controls
»
General
C#
Windows
Design
LINQ
Advanced
C#3.5
Asp .net Chat application with database and export option
by
Chan Thar Myint
Answer
8 May 2013
license:
CPOL
Simple Chat application using AJAX[^]
General Programming
»
Uncategorised Quick Answers
»
General
ASP.NET
LINQ
oops
How to get the biggest number?
by
Radoslav Dimitrov
Answer
7 May 2013
license:
CPOL
int TExcel = 0;TExcel = dc.Hotel_Meals_TBLs.Max(a => a.CodeNumber);It is allready converted!
General Programming
»
Uncategorised Quick Answers
»
General
C#
LINQ
How to get the biggest number?
by
VisualLive
Question
7 May 2013
license:
CPOL
How get the biggest number?i am trying to get the biggest number from a field in my database but is it strange because i use this simple codeamenitiesExcel = dc.Hotel_Meals_TBLs.Select(Convert.ToInt32(a => a.CodeNumber)).Max();and when i compile the query i receive this error: Error ...
General Programming
»
Uncategorised Quick Answers
»
General
C#
LINQ
How to get the biggest number?
by
Matt T Heffron
Answer
7 May 2013
license:
CPOL
You should try this:amenitiesExcel = dc.Hotel_Meals_TBLs.Max(a => Convert.ToInt32(a.CodeNumber));oramenitiesExcel = dc.Hotel_Meals_TBLs.Max(a => int.Parse(a.CodeNumber));
General Programming
»
Uncategorised Quick Answers
»
General
C#
LINQ
Generating an MD5 Hash from a String Using LINQ
by
Rion Williams
Technical Blog
7 May 2013
license:
CPOL
Generating an MD5 hash from a string using LINQ.
Platforms, Frameworks & Libraries
»
Linq
»
General
C#
ASP.NET
.NET
LINQ
.NET
.NET4
Hashing
How to get the biggest number?
by
Renju Vinod
Answer
7 May 2013
license:
CPOL
Try thisint amenitiesExcel = 0;amenitiesExcel = dc.Hotel_Meals_TBLs.Max(a => (int?)a.CodeNumber)?? 0;
General Programming
»
Uncategorised Quick Answers
»
General
C#
LINQ
How to get the biggest number?
by
Jameel Moideen
Answer
6 May 2013
license:
CPOL
You don't need to Convert to int. Just change your Query like belowamenitiesExcel = dc.Hotel_Meals_TBLs.Max(a => a.CodeNumber);Hope this helps
General Programming
»
Uncategorised Quick Answers
»
General
C#
LINQ
Select data from sql..
by
Jameel Moideen
Answer
5 May 2013
license:
CPOL
By joining tables you retrieve multiple tables of data using linq like belowvar results = (from a in a1 join b in a2 on a.userID equals b.userID join c in a3 on a.userID equals c.userID select new { ...
General Programming
»
Uncategorised Quick Answers
»
General
LINQ
How to display the following result in WPF chart
by
BuBa1947
Question
5 May 2013
license:
CPOL
In my WPF application, I have a following query to display the selected date range as 'Date' and total number of servers being processed on each day as 'Amount'.var query_1 = (this.db.Servers .Where(a => (a.Date >= fromDP.SelectedDate.Value && a.Date
General Programming
»
Uncategorised Quick Answers
»
General
C#
WPF
LINQ
select most recent data from multiple colums
by
Sam Van den Bossche
Question
5 May 2013
license:
CPOL
Hi, I'm trying to select the 30 latest entries in my database, but I want to select them from 4 different tables. Is there a way to do this clean and quick using linq? At the end of the query I want to store these objects in a list.Thanks in advance!
General Programming
»
Uncategorised Quick Answers
»
General
C#
ASP
ASP.NET
WCF
LINQ
Select data from sql..
by
kallurirakesh
Question
5 May 2013
license:
CPOL
Hi to allI am new linq i want retrive multiple tables of data from sql using linq..Just like in ado.net.DS[0]-TABLE1DS[1]-TABLE2DS[2]-TABLE3Thanks..[edit]SHOUTING removed - OriginalGriff[/edit]
General Programming
»
Uncategorised Quick Answers
»
General
LINQ
select most recent data from multiple collums
by
Sam Van den Bossche
Answer
5 May 2013
license:
CPOL
var feedList = ((from video in context.Video orderby video.Date descending select new { TypeID = video.VideoID, CodeID = video.CodeID, Date = video.Date }).Take(50)) .Union((from comment in context.Comment...
General Programming
»
Uncategorised Quick Answers
»
General
C#
ASP
ASP.NET
WCF
LINQ
Paging DataGridView in C# using LINQ
by
mohammad amiri
Tip/Trick
5 May 2013
license:
CPOL
Paging DataGridView using LINQ in C#.
Desktop Development
»
Grid & Data Controls
»
General
C#
Javascript
SQL
Windows
LINQ
Beginner
Page 1 of 135
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