TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
dc
NA
663
0
Web form using linq
Nov 11 2011 12:59 PM
For a C#.net 2010 web form application that I am working on, I am trying to determine how to complete the following tasks:
1. I will be obtaining month and year values from two different dropdown list controls.
2. I want to write a linq to sql statement that would be similar to the following:
select date1, date2, date3,date4, date5,date6
from dbo.Schedule.table
where datepart(mm,payment_month)= 01 and datepart(yyyy,payment_month) =2011
This table is entirely a schedule table. They key to the table is not worth using since it is an identity column that exists for the purpose of creating the table.
The month and year values would come in as parameters from two dropdownlist controls.
Thus could you tell me how to setup this linq to sql statement?
Note: I have written linq statement that return one value. However, I do not know how to write a linq statment to retrieve several rows from one column.
Thus can you give me a suggestion on how to complete this task and/or references that I can use?
Reply
Answers (
2
)
Range validator
Language in .NET Framework