private void Form1_Load(object sender, EventArgs e) { var sales = dc.Sales_by_Year(new DateTime(1990, 1, 1), new DateTime(2000, 1, 1)); saleGrid.DataSource = sales; var q = from c in dc.Customers select new { c.CustomerID, c.CompanyName }; dataGridView1.DataSource = q; }
/// <summary> /// Stored Procedure: Sales By Year /// </summary> /// <param name="beginningYear"></param> /// <param name="endingYear"></param> /// <returns></returns> public static List <Sales_by_YearResult> SalesByYear(DateTime?beginningYear, DateTime?endingYear) { NorthwindDataContext dc = new NorthwindDataContext(); return(dc.Sales_by_Year(beginningYear, endingYear).ToList <Sales_by_YearResult>()); }