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];//處理報(bào)錯(cuò)問(wèn)題!List<Dictionary<string, object>> list1 = new List<Dictionary<string, object>>();foreach (DataRow dr in newTabel.Rows)//每一行信息,新建一個(gè)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個(gè)值 分別是 王金龍 趙海偉 王楠 孟巖 請(qǐng)問(wèn)我怎么把這4個(gè)值賦給UserName2
- 1 回答
- 0 關(guān)注
- 854 瀏覽
添加回答
舉報(bào)
0/150
提交
取消