表db_list??? id??? 服務(wù)器名(TableName)??井名字(WellId)???????時間?(InsertTime)?????????? ??? ????????????1???????? ?[WIS00001]?????????B1ST4??????????2011-12-01 20:09:34.737??
??? 1???????? ?[WIS00002]?????????B2ST4??????????2011-12-01 20:09:34.737?? ???? 表wits_86??? 自動生成GUID??? 井名WID????????? 時間?(time)??????????? 油嘴Nozzle????????????
?????????????? 242342?????????? ?B1ST4??????2012-08-24 16:45:31.600??????1616
大家不難看出.....list是主表,,,,找到井名字,通過服務(wù)器字段,找到wits_86表中油嘴字段,綁定到gv中,這樣怎么實現(xiàn)呢?
??????? public void bind()
??????? {
??????? string con = ConfigurationManager.ConnectionStrings["SQLServerConnectionString"].ConnectionString;
??????? SqlDataAdapter sda = new SqlDataAdapter("select id,TableName,WellId from dbo.db_list", con);
??????????? DataSet ds = new DataSet();
??????????? sda.Fill(ds);
?
??????????????? for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
??????????????? {
??????????????????? SqlConnection scn = new SqlConnection(con);
??????????????????? SqlDataAdapter sda1 = new SqlDataAdapter("select a.id,WellId,b.Nozzle from db_list as a left join " + ds.Tables[0].Rows[i]["TableName"] + ".dbo.wits_86 as b on a.WellId=b.WID", scn);
??????????????????? DataSet ds1 = new DataSet();
??????????????????? sda1.Fill(ds1);
??????????????????? dgUserList.DataSource = ds1;
??????????????????? dgUserList.DataBind();
??????????????? }
??????? }
?我寫的代碼.后臺綁定
但是為什么查出來的都是最后一個庫中的數(shù)據(jù)呢?循環(huán)錯了?請大神們幫幫忙吧!
最終效果是,石油油井.石油油嘴綁定到GREDVIEW...效果::B1ST4???? 1616
?
?
?
- 4 回答
- 0 關(guān)注
- 321 瀏覽
添加回答
舉報
0/150
提交
取消