有偿找一个懂C#的人解决一个问题

punkdoll77

如题，需要完成一个search功能，能够搜索两个table的信息，显示在gridview里面，目前只能显示一个table的信息，懂的请回复。谢谢~~~

fisher_1986

我周末可以帮看看，我邮箱是： uakevin.w@gmail.com

绿洲橘子

Write a select statement with a join between those two tables, then put this result to a data model. Using grid view to display this model . That is simple. You can search via google . Lot of example you can find.

calgaryNW

There are two tables such as AA and BB, assume there is empid field in AA, and there is empid field in BB, and your grid view's name is gdv, so:
# p7 S) N/ V- W2 S/ n7 a" C1 .sql statement is:
6 x6 F! n8 S3 W- o0 n1 R- nselect AA.empid, AA.XX, BB.XX from AA inner join BB on AA.empid=BB.empid
+ W! `5 E* d  d: Z; |9 {2. show data in grid view
then used DataTable get the result, for example Datatable name is dtResult:
/ M$ P: B8 H9 Ycode is :
gdv.datasource=dtResult;
gdv.DataBind();
+ y. \6 |8 U' x# i' M+ n
2 L  G$ p  b; g



' @1 t5 u  @# K# g" a5 `

punkdoll77

calgaryNW 发表于 2015-3-26 18:47
There are two tables such as AA and BB, assume there is empid field in AA, and there is empid field  ...

$ s; E! m7 g- i4 ^1 NThx. I am going to try it.

abear

这不是sql的问题吗？

punkdoll77

abear 发表于 2015-3-30 13:34
这不是sql的问题吗？

* ?* x0 X( X- q/ {8 }不是的。已经有人帮忙解决了。谢啦

punkdoll77

calgaryNW 发表于 2015-3-26 18:47
/ m" L2 t+ P8 b: K, e$ eThere are two tables such as AA and BB, assume there is empid field in AA, and there is empid field  ...

$ L9 E, h2 p! h  e2 i5 j谢谢啦，已经解决了。