or
Sample aspx from SSRS local report:
<asp:SqlDataSource ID="SqlDataSourceX" runat="server"ConnectionString="<%$ ConnectionStrings:ConnDB %>"
SelectCommand="SELECT * FROM [Jobs] WHERE ([DeptID] = @d)">
<SelectParameters>using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.ComponentModel;using IW_CCFA_GEKO.Model;namespace IW_CCFA_GEKO.Report.ReportModels { [DataObject] public class Products { protected CCFAGEKOEntities db = new CCFAGEKOEntities(); [DataObjectMethod(DataObjectMethodType.Select)] public List<Product> GetAllProducts() { var products = new List<Product>(); products.Add(new Product() {Name = "Produkt 1", Color = "blau", ListPrice = 2.55, ProductNumber = "654-789"}); products.Add(new Product() {Name = "Produkt 2", Color = "gelb", ListPrice = 1.20, ProductNumber = "345-768"}); products.Add(new Product() {Name = "Produkt 3", Color = "rot", ListPrice = 5.0, ProductNumber = "56-334"}); products.Add(new Product() {Name = "Produkt 4", Color = "grün", ListPrice = 3.9, ProductNumber = "234-159"}); return products; } }}