lambda表达式4
查看命令
Default3.aspx.cs
using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data.SqlClient;using System.Data.Linq;using DannyWeb;public partial class Default6 : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) { var conn = new SqlConnection("server=.;database=Northwind;uid=sa;pwd="); var ctx = new DataContext(conn); var cmd = new SqlCommand("select * from customers where customerID like 'A%'", conn); conn.Open(); var reader = cmd.ExecuteReader(); GridView1.DataSource = ctx.Translate<Customer>(reader); GridView1.DataBind(); conn.Close(); }}