日期:2014-05-17 浏览次数:20880 次
SqlConnection con = new SqlConnection("server='PC2012050719LFQ';database=AccessControl;uid=sa;pwd=lzr666;");
DataSet ds = new DataSet();
string strstr="select a.id,datediff(day,a.date,b.date) from tb_in a join tb_out b on a.RealName=b.RealName";
SqlDataAdapter sda = new SqlDataAdapter(strstr, con);
sda.Fill(ds, "tb_in");
Repeater3.DataSource = pds ;
Repeater3.DataBind();