var ShangJiaoRenShu = string.Format(@"select u.Codefrom I_SalesForecast sf left join OT_User u on sf.CreatedBy=u.ObjectIDwhere sf.CreatedByParentId='{0}' and sf.CreatedTime>='{1}' and sf.CreatedTime<='{2}'", CreatedByParentId, Begin, End);SqlConnection conn1 = new SqlConnection(ConnectionString);conn1.Open();SqlCommand comm = new SqlCommand(ShangJiaoRenShu, conn1);SqlDataAdapter adapter = new SqlDataAdapter(comm);DataSet ds = new DataSet();//datatableadapter.Fill(ds);var newTabel = ds.Tables[0];//處理報錯問題!List<Dictionary<string, object>> list1 = new List<Dictionary<string, object>>();foreach (DataRow dr in newTabel.Rows)//每一行信息,新建一個Dictionary<string,object>,將該行的每列信息加入到字典{Dictionary<string, object> result = new Dictionary<string, object>();foreach (DataColumn dc in newTabel.Columns){result.Add(dc.ColumnName, dr[dc].ToString());}list1.Add(result);} foreach (var item in list1){UserName2 += item.ToString();} list1里有4個值 分別是 王金龍 趙海偉 王楠 孟巖 請問我怎么把這4個值賦給UserName2
- 1 回答
- 0 關注
- 857 瀏覽
添加回答
舉報
0/150
提交
取消