//DataContext類在System.Data.Linq命名空間中。
using System.Data.Linq;
//數據源
DataContext dc = new DataContext("data Source=192.168.0.66;database=LSS1;user id=sa;pwd=xit");
Table<User> users = dc.GetTable<User>();
//創建查詢
int age = Convert.ToInt32(this.txtAge.Text.ToString());
var result = from user in users
where user.Age == age
select new { 序號 = user.UserID, 姓名 = user.UserName, 年齡 = user.Age };
//執行查詢
this.GridView1.DataSource = result;
this.GridView1.DataBind();
浙公網安備 33010602011771號