將最美的計算機軟件奉獻給社會

//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();