Web form using linq

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?

I believe I can give a LINQ query although I am not an expert :)

I believe the table contains following column on which we do the search:
payment_month (which is a datetime type).
I am calling this as RecordDate.

Below is the sample code which id did for LINQ to Entities. The same should work for your db too.

class Program

{

static void Main(string[] args)

{

IList list = new List();

list.Add(new Schedule() { Name = "a", RecordDate = DateTime.Today });

list.Add(new Schedule() { Name = "b", RecordDate = DateTime.Today.AddDays(-1) });

list.Add(new Schedule() { Name = "c", RecordDate = DateTime.Today.AddMonths(-1) });

var selection = (from s in list

where s.RecordDate.Month == 11

&& s.RecordDate.Year == 2011

select s).ToList();

}

public class Schedule

{

public string Name;

public DateTime RecordDate;

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jean Paul15y ago
Accepted answer
I believe I can give a LINQ query although I am not an expert :)

I believe the table contains following column on which we do the search:
payment_month (which is a datetime type).
I am calling this as RecordDate.

Below is the sample code which id did for LINQ to Entities. The same should work for your db too.

class Program
{
static void Main(string[] args)
{
IList list = new List();
list.Add(new Schedule() { Name = "a", RecordDate = DateTime.Today });
list.Add(new Schedule() { Name = "b", RecordDate = DateTime.Today.AddDays(-1) });
list.Add(new Schedule() { Name = "c", RecordDate = DateTime.Today.AddMonths(-1) });

var selection = (from s in list
where s.RecordDate.Month == 11
&& s.RecordDate.Year == 2011
select s).ToList();

}
}

public class Schedule
{
public string Name;
public DateTime RecordDate;
}
dc15y ago
Thanks!