查询人员信息
条件：当此人员信息在部门部门下面则查询
1 public partial class LinqJoin : System.Web.UI.Page 2 { 3 4 protected void Page_Load(object sender, EventArgs e) 5 { 6 DataLoad(); 7 DataInit(); 8 } 9 /// <summary> 10 /// Sql查询 11 /// </summary> 12 public void DataInit() 13 { 14 //计算时间差 15 Stopwatch watch = new Stopwatch(); 16 //打开表 17 watch.Start(); 18 using (SqlConnection conn = new SqlConnection(@"server=HAPPY-PC;User ID=sa;Password=happy;database=Exam4.1_OK;Connection Reset=FALSE;Max Pool Size = 512;")) 19 { 20 conn.Open(); 21 22 using (SqlCommand cmd = conn.CreateCommand()) 23 { 24 //查询UserId<276234的有部门Id的用户信息 25 cmd.CommandText = "select a.* from users a inner join Structure c on a.StructureID=c.StructureID where a.UserId<276234"; 26 27 SqlDataAdapter adapter = new SqlDataAdapter(); 28 adapter.SelectCommand = cmd; 29 DataSet ds = new DataSet(); 30 31 adapter.Fill(ds); 32 33 this.GridView1.DataSource = ds; 34 this.GridView1.DataBind(); 35 ds.Dispose(); 36 37 } 38 } 39 //关闭表 40 watch.Stop(); 41 //打印时间 42 Response.Write("我是第一个："+watch.Elapsed.Milliseconds.ToString()); 43 } 44 /// <summary> 45 /// Linq查询 46 /// </summary> 47 private void DataLoad() 48 { 49 //计算时间差 50 Stopwatch watch = new Stopwatch(); 51 //打开表 52 watch.Start(); 53 using (LinqInnerJoinDataContext ctx = new LinqInnerJoinDataContext("server=HAPPY-PC;User ID=sa;Password=happy;database=Exam4.1_OK;Connection Reset=FALSE;Max Pool Size = 512;")) 54 { 55 //查询UserId<276234的有部门Id的用户信息 56 var table = from c in ctx.Users 57 join p in ctx.Structure 58 on c.StructureID equals p.StructureID.ToString() 59 where c.UserID < 276234 60 select c; 61 62 this.GridView2.DataSource = table; 63 this.GridView2.DataBind(); 64 } 65 //关闭表 66 watch.Stop(); 67 //显示时间 68 Response.Write("我是第二个:" + watch.Elapsed.Milliseconds.ToString()); 69 } 70 }
