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?